Data Models into Database Designs A foreign key is: All of these a column containing the primary key of another table. used to define null status. used to define data types. All of these a column containing the primary key of another table. used to define null status. used to define data types. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: Either of the above can be used. NULL. None of these NOT NULL. Either of the above can be used. NULL. None of these NOT NULL. 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 intrarelation constraint A range constraint An interrelation constraint A domain constraint An intrarelation constraint A range constraint An interrelation constraint 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 In a 1:1 relationship, the foreign key is placed in: either table without specifying parent and child tables. the parent table. either the parent table or the child table. the child table. either table without specifying parent and child tables. the parent table. either the parent table or the child table. the child table. 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS