DATABASE DESIGN USING NORMALIZATION QUIZ

When the parent entity is required, a new child row can always be inserted.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A primary key should be defined as:

None of these

Either of the above can be used.

NOT NULL.

NULL.

TRUE ANSWER : ?
YOUR ANSWER : ?

All primary keys are required.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An intersection table is required to represent M:N relationships.

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?

Data type

Null status

Default value

Data constraints

TRUE ANSWER : ?
YOUR ANSWER : ?

A foreign key is:

used to define null status.

All of these

used to define data types.

a column containing the primary key of another table.

TRUE ANSWER : ?
YOUR ANSWER : ?

An ideal primary key is short, numeric and seldom changing.

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?

Null status

Default value

Data constraints

Data type

TRUE ANSWER : ?
YOUR ANSWER : ?

For every relationship, how many possible sets of minimum cardinalities are there?

Six

Two

Three

Four

TRUE ANSWER : ?
YOUR ANSWER : ?

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

the parent table.

the child table.

either table without specifying parent and child tables.

either the parent table or the child table.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑