Site MapHelpFeedbackTrue or False Quiz
True or False Quiz
(See related pages)



1

In the case of a candidate key, removal of any of its columns causes it to no longer be a candidate key.
A)True
B)False
2

With regards to referential integrity constraints, when a foreign key is not part of a primary key, the table's structure dictates whether null values should be permitted.
A)True
B)False
3

A 1-M relationship is a connection between two tables in which rows of each table can be related to many rows of the other table.
A)True
B)False
4

The ON DELETE CASCADE clause of a foreign key constraint statement would cause related rows in another table to be deleted automatically.
A)True
B)False
5

Referential integrity imposes a particular order when performing insert operations on referenced rows in different tables.
A)True
B)False
6

In a natural join operation, the join columns have the same unqualified name, which is the column name without the table name.
A)True
B)False
7

A one-sided outer join can be useful in preserving rows in the result table in a situation where a table has null values in a foreign key.
A)True
B)False
8

Union compatibility requires that each table must have the same number of columns, but the corresponding columns can have different data types because the DBMS will convert them during query execution.
A)True
B)False
9

Two tables that are not union compatible can be made union compatible using the project operator.
A)True
B)False
10

The divide operator is more difficult to use than a join because the matching requirement is more stringent.
A)True
B)False





To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 3 > True or False Quiz