Q.1

Which is not true about surrogate keys?

  • They are short.
  • They are fixed.
  • They have meaning to the user.
  • They are numeric.
Q.2

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

  • Two
  • Three
  • Four
  • Six
Q.3

Which of the following column properties specifies whether or not cells in a column must contain a data value?

  • Null status
  • Data type
  • Default value
  • Data constraints
Q.4

Surrogate keys have much meaning for users.

  • True
  • False
Q.5

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

  • True
  • False
Q.6

Intersection tables are ID-dependent on both their parent tables.

  • True
  • False
Q.7

When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

  • True
  • False
Q.8

In a 1:1 relationship, the primary key placement is arbitrary.

  • True
  • False
Q.9

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?

  • Null status
  • Data type
  • Default value
  • Data constraints
Q.10

A primary key should be defined as:

  • NULL.
  • NOT NULL.
  • Either of the above can be used.
  • None of the above are correct.
Q.11

When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.

  • True
  • False
Q.12

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

  • True
  • False
Q.13

For every relationship, there are six possible sets of minimum cardinalities.

  • True
  • False
Q.14

Which of the following column properties would be used to specify that cells in a column must contain a monetary value?

  • Null status
  • Data type
  • Default value
  • Data constraints
Q.15

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

  • True
  • False
0 h : 0 m : 1 s