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. the primary key a surrogate key any alternate key a foreign key the primary key a surrogate key any alternate key a foreign key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following columns is(are) are required in a table? A foreign key A surrogate key A primary key An alternate key A foreign key A surrogate key A primary key An alternate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:N relationship, the foreign key is placed in: the child table. either the parent table or the child table. the parent table. either table without specifying parent and child tables. the child table. either the parent table or the child table. the parent table. either table without specifying parent and child tables. 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. foreign key. composite key. primary key. surrogate key. foreign key. composite key. primary key. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: None of these Either of the above can be used. NOT NULL. NULL. None of these Either of the above can be used. NOT NULL. 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 range constraint An intrarelation constraint An interrelation constraint A domain constraint A range constraint An intrarelation constraint An interrelation constraint A domain constraint ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS