DATA MODELS INTO DATABASE DESIGNS QUIZ

The identifier of an entity will become the ________ of the new table.

primary key

main attribute

identity key

foreign key

TRUE ANSWER : ?
YOUR ANSWER : ?

In a 1:1 relationship, the foreign key is placed in:

the parent table.

either the parent table or the child table.

either table without specifying parent and child tables.

the child table.

TRUE ANSWER : ?
YOUR ANSWER : ?

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?

An interrelation constraint

A domain constraint

An intrarelation constraint

A range constraint

TRUE ANSWER : ?
YOUR ANSWER : ?

The terms alternate key and candidate key mean the same thing.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

For every relationship, there are six possible referential integrity actions.

True

False

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 type

Data constraints

TRUE ANSWER : ?
YOUR ANSWER : ?

Surrogate keys have much meaning for users.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which is not true about surrogate keys?

They are fixed.

They are short.

They are numeric.

They have meaning to the user.

TRUE ANSWER : ?
YOUR ANSWER : ?

A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

surrogate key.

primary key.

composite key.

foreign key.

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

any alternate key

a foreign key

TRUE ANSWER : ?
YOUR ANSWER : ?

↑