Data Models into Database Designs Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values? A domain constraint An interrelation constraint An intrarelation constraint A range constraint A domain constraint An interrelation constraint An intrarelation constraint A range constraint 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? Null status Data constraints Default value Data type Null status Data constraints Default value Data type ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The DBMS allows surrogate keys to be changed. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship? MUST NOT MUST COVER Both of the above None of these MUST NOT MUST COVER Both of the above 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): surrogate key. primary key. composite key. foreign key. surrogate key. primary key. composite key. foreign key. ANSWER DOWNLOAD EXAMIANS APP