DATA MODELS INTO DATABASE DESIGNS QUIZ

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

either the parent table or the child table.

the parent table.

either table without specifying parent and child tables.

the child table.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

the parent table.

the child table.

either the parent table or the child table.

either table without specifying parent and child tables.

TRUE ANSWER : ?
YOUR ANSWER : ?

The DBMS allows surrogate keys to be changed.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

primary key

main attribute

foreign key

identity key

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

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?

A range constraint

An interrelation constraint

A domain constraint

An intrarelation constraint

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?

Data constraints

Default value

Null status

Data type

TRUE ANSWER : ?
YOUR ANSWER : ?

Each entity is represented as a(n):

table.

attribute.

file.

tuple.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑