Data Models into Database Designs Which of the following columns is(are) are required in a table? A primary key An alternate key A surrogate key A foreign key A primary key An alternate key A surrogate key A foreign key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs An ideal primary key is short, numeric and seldom changing. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Intersection tables are ID-dependent on both their parent tables. True False True False 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. any alternate key a surrogate key the primary key a foreign key any alternate key a surrogate key the primary key a foreign key ANSWER DOWNLOAD EXAMIANS APP
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 In 1:N relationships, which entity becomes the parent entity is arbitrary. True False True False ANSWER DOWNLOAD EXAMIANS APP