An ideal primary key is short, numeric and seldom changing. True False TRUE ANSWER : ? YOUR ANSWER : ?
A primary key should be defined as: NULL. Either of the above can be used. None of these NOT NULL. TRUE ANSWER : ? YOUR ANSWER : ?
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities? Six Three Two Four TRUE ANSWER : ? YOUR ANSWER : ?
A foreign key is used to implement relationships between tables. False True TRUE ANSWER : ? YOUR ANSWER : ?
When the parent entity is required, a new child row can always be inserted. True False TRUE ANSWER : ? YOUR ANSWER : ?
When the parent entity is required and the parent has a surrogate key, update actions can be ignored. False True TRUE ANSWER : ? YOUR ANSWER : ?
When the parent entity is required, a new parent row can always be inserted. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000? Data constraints Data type Null status Default value TRUE ANSWER : ? YOUR ANSWER : ?
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 a foreign key any alternate key TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following columns is(are) are required in a table? A primary key An alternate key A surrogate key A foreign key TRUE ANSWER : ? YOUR ANSWER : ?