Data Models into Database Designs Which of the following columns is(are) are required in a table? A primary key An alternate key A foreign key A surrogate key A primary key An alternate key A foreign key A surrogate 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 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 A foreign key is: All of these a column containing the primary key of another table. used to define data types. used to define null status. All of these a column containing the primary key of another table. used to define data types. used to define null status. 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 When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Each entity is represented as a(n): file. attribute. tuple. table. file. attribute. tuple. table. ANSWER DOWNLOAD EXAMIANS APP