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 define data types. used to define null status. a column containing the primary key of another table. All of these TRUE ANSWER : ? YOUR ANSWER : ?
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key. True False TRUE ANSWER : ? YOUR ANSWER : ?
The terms alternate key and candidate key mean the same thing. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table? A range constraint An interrelation constraint An intrarelation constraint A domain constraint TRUE ANSWER : ? YOUR ANSWER : ?
When the parent entity is required, a new child row can always be inserted. False True TRUE ANSWER : ? YOUR ANSWER : ?
The identifier of an entity will become the ________ of the new table. identity key main attribute foreign key primary key 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 any alternate key a surrogate key a foreign key TRUE ANSWER : ? YOUR ANSWER : ?