Data Models into Database Designs Intersection tables are ID-dependent on both their parent tables. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the foreign key is placed in: either table without specifying parent and child tables. either the parent table or the child table. the parent table. the child table. either table without specifying parent and child tables. either the parent table or the child table. the parent table. the child table. ANSWER DOWNLOAD EXAMIANS APP
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 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 Default value Data type Data constraints Null status Default value Data type Data constraints 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
Data Models into Database Designs Which is not true about surrogate keys? They are short. They are fixed. They are numeric. They have meaning to the user. They are short. They are fixed. They are numeric. They have meaning to the user. ANSWER DOWNLOAD EXAMIANS APP