Data Models into Database Designs A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): primary key. composite key. surrogate key. foreign key. primary key. composite key. surrogate key. foreign key. 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 Which of the following column properties specifies whether or not cells in a column must contain a data value? Data type Default value Null status Data constraints Data type Default value Null status Data constraints 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 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 the primary key a foreign key a surrogate key any alternate key the primary key a foreign key a surrogate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required, a new child row can always be inserted. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS