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 Data constraints Data type Null status Default value Data constraints Data type Null status 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 When the parent entity is required and the parent has a surrogate key, update actions can be ignored. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: NOT NULL. NULL. Either of the above can be used. None of these NOT NULL. NULL. Either of the above can be used. None of these 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): composite key. foreign key. surrogate key. primary key. composite key. foreign key. surrogate key. primary key. 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