A primary key should be defined as: NULL. None of these NOT NULL. Either of the above can be used. TRUE ANSWER : ? YOUR ANSWER : ?
For every relationship, there are six possible referential integrity actions. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship? Both of the above MUST NOT None of these MUST COVER TRUE ANSWER : ? YOUR ANSWER : ?
For every relationship, there are six possible sets of minimum cardinalities. False True TRUE ANSWER : ? YOUR ANSWER : ?
An intersection table is required to represent M:N relationships. False True TRUE ANSWER : ? YOUR ANSWER : ?
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key. True False TRUE ANSWER : ? YOUR ANSWER : ?
In a 1:1 relationship, the foreign key is placed in: the child table. the parent table. either table without specifying parent and child tables. either the parent table or the child table. TRUE ANSWER : ? YOUR ANSWER : ?
When the parent entity is required and the parent has a surrogate key, update actions can be ignored. True False TRUE ANSWER : ? YOUR ANSWER : ?
A foreign key is used to implement relationships between tables. True False TRUE ANSWER : ? YOUR ANSWER : ?
Cascading updates refers to child rows being automatically deleted when a parent row is deleted. False True TRUE ANSWER : ? YOUR ANSWER : ?