In a 1:1 relationship, the foreign key is placed in: either the parent table or the child table. the child table. either table without specifying parent and child tables. the parent table. TRUE ANSWER : ? YOUR ANSWER : ?
In 1:N relationships, which entity becomes the parent entity is arbitrary. True False TRUE ANSWER : ? YOUR ANSWER : ?
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key. True False TRUE ANSWER : ? YOUR ANSWER : ?
When the parent entity is required, a new parent row can always be inserted. True False TRUE ANSWER : ? YOUR ANSWER : ?
An intersection table is required to represent M:N relationships. False True TRUE ANSWER : ? YOUR ANSWER : ?
For every relationship, how many possible sets of minimum cardinalities are there? Six Three Four Two TRUE ANSWER : ? YOUR ANSWER : ?
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value. the primary key a foreign key any alternate key a surrogate key TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000? Default value Null status Data type Data constraints TRUE ANSWER : ? YOUR ANSWER : ?