Data Models into Database Designs A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): surrogate key. foreign key. composite key. primary key. surrogate key. foreign key. composite key. primary key. 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 that is less than another monetary value in the same row? Default value Null status Data constraints Data type Default value Null status Data constraints Data type ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs For every relationship, how many possible types of actions are there when enforcing minimum cardinalities? Three Two Six Four Three Two Six Four 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? An interrelation constraint A domain constraint A range constraint An intrarelation constraint An interrelation constraint A domain constraint A range constraint An intrarelation constraint ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs An intersection table is required to represent M:N relationships. 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. a surrogate key the primary key any alternate key a foreign key a surrogate key the primary key any alternate key a foreign key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS