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. the primary key a surrogate key a foreign key any alternate key the primary key a surrogate key a foreign key any alternate 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 Which of the following column properties would be used to specify that cells in a column must contain a monetary value? Data constraints Null status Data type Default value Data constraints Null status Data type Default value 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 Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table? A domain constraint A range constraint An intrarelation constraint An interrelation constraint A domain constraint A range constraint An intrarelation constraint An interrelation constraint 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
EXAMIANS