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 range constraint An interrelation constraint An intrarelation constraint A domain constraint A range constraint An interrelation constraint An intrarelation constraint A domain constraint ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which is not true about surrogate keys? They are numeric. They have meaning to the user. They are fixed. They are short. They are numeric. They have meaning to the user. They are fixed. They are short. 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
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 any alternate key a foreign key the primary key a surrogate key any alternate key a foreign key the primary key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following situation requires the use of ID-dependent entities? Archetype/instance relationships only Association relationships only All of these Multivalued attributes only Archetype/instance relationships only Association relationships only All of these Multivalued attributes only 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
EXAMIANS