Data Models into Database Designs When the parent entity is required, a new child row can always be inserted. False True False True 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. 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 cells in a column must be one of a specific set of possible values? A range constraint A domain constraint An interrelation constraint An intrarelation constraint A range constraint A domain constraint An interrelation constraint An intrarelation constraint ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Intersection tables are ID-dependent on both their parent tables. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is: a column containing the primary key of another table. All of these used to define data types. used to define null status. a column containing the primary key of another table. All of these used to define data types. used to define null status. 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 type Data constraints Default value Null status Data type Data constraints Default value ANSWER DOWNLOAD EXAMIANS APP