Data Models into Database Designs A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): surrogate key. primary key. foreign key. composite key. surrogate key. primary key. foreign key. composite key. 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 a surrogate key any alternate key the primary key a foreign key a surrogate key any alternate key the primary key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The DBMS allows surrogate keys to be changed. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Intersection tables are ID-dependent on both their parent tables. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs An ideal primary key is short, numeric and seldom changing. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is: All of these used to define null status. a column containing the primary key of another table. used to define data types. All of these used to define null status. a column containing the primary key of another table. used to define data types. ANSWER DOWNLOAD EXAMIANS APP