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 Which of the following situation requires the use of ID-dependent entities? All of these Multivalued attributes only Association relationships only Archetype/instance relationships only All of these Multivalued attributes only Association relationships only Archetype/instance relationships only ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the primary key placement is arbitrary. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Cascading updates refers to child rows being automatically deleted when a parent row is deleted. 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. 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 When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited. False True False True ANSWER DOWNLOAD EXAMIANS APP