Cascading updates refers to child rows being automatically deleted when a parent row is deleted. True False TRUE ANSWER : ? YOUR ANSWER : ?
In a 1:1 relationship, the foreign key is placed in: the child table. the parent table. either the parent table or the child table. either table without specifying parent and child tables. TRUE ANSWER : ? YOUR ANSWER : ?
In a 1:1 relationship, the primary key placement is arbitrary. True False TRUE ANSWER : ? YOUR ANSWER : ?
A primary key should be defined as: Either of the above can be used. NULL. None of these NOT NULL. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following column properties specifies whether or not cells in a column must contain a data value? Default value Null status Data constraints Data type TRUE ANSWER : ? YOUR ANSWER : ?
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 TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following column properties would be used to specify that cells in a column must contain a monetary value? Data constraints Default value Data type Null status TRUE ANSWER : ? YOUR ANSWER : ?
An ideal primary key is short, numeric and seldom changing. True False TRUE ANSWER : ? YOUR ANSWER : ?
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? Default value Null status Data type Data constraints TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table? A range constraint An intrarelation constraint An interrelation constraint A domain constraint TRUE ANSWER : ? YOUR ANSWER : ?