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 Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000? Data type Data constraints Default value Null status Data type Data constraints Default value Null status 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 A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): foreign key. surrogate key. primary key. composite key. foreign key. surrogate key. primary key. composite key. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is: a column containing the primary key of another table. All of these used to define data types. used to define null status. a column containing the primary key of another table. All of these used to define data types. used to define null status. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The terms alternate key and candidate key mean the same thing. True False True False ANSWER DOWNLOAD EXAMIANS APP