Data Models into Database Designs When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The DBMS allows surrogate keys to be changed. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required, a new child row can always be inserted. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: NOT NULL. None of these Either of the above can be used. NULL. NOT NULL. None of these Either of the above can be used. NULL. 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 foreign key any alternate key the primary key a surrogate key a foreign key any alternate key the primary key a surrogate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following columns is(are) are required in a table? A primary key A surrogate key An alternate key A foreign key A primary key A surrogate key An alternate key A foreign key ANSWER DOWNLOAD EXAMIANS APP