Data Models into Database Designs For every relationship, there are six possible referential integrity actions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs 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. a surrogate key any alternate key a foreign key the primary key a surrogate key any alternate key a foreign key the primary key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The identifier of an entity will become the ________ of the new table. identity key foreign key main attribute primary key identity key foreign key main attribute primary key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following column properties specifies whether or not cells in a column must contain a data value? Default value Data type Data constraints Null status Default value Data type Data constraints Null status ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the foreign key is placed in: either table without specifying parent and child tables. the parent table. either the parent table or the child table. the child table. either table without specifying parent and child tables. the parent table. either the parent table or the child table. the child table. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship? Both of the above None of these MUST NOT MUST COVER Both of the above None of these MUST NOT MUST COVER ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS