Q.1

Which of the following situation requires the use of ID-dependent entities?

  • Association relationships only
  • Multivalued attributes only
  • Archetype/instance relationships only
  • All of the above use ID dependent entities
Q.2

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

  • foreign key
  • main attribute
  • primary key
  • identity key
Q.3

A foreign key is:

  • a column containing the primary key of another table.
  • used to define data types.
  • used to define null status.
  • all of the above are above correct.
Q.4

Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?

  • A domain constraint
  • A range constraint
  • An intrarelation constraint
  • An interrelation constraint
Q.5

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 domain constraint
  • A range constraint
  • An intrarelation constraint
  • An interrelation constraint
Q.6

The DBMS allows surrogate keys to be changed.

  • True
  • False
Q.7

(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

  • True
  • False
Q.8

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

  • True
  • False
Q.9

A foreign key is used to implement relationships between tables.

  • True
  • False
Q.10

Which of the following columns is(are) are required in a table?

  • A foreign key
  • An alternate key
  • A primary key
  • A surrogate key.
Q.11

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

  • primary key.
  • foreign key.
  • composite key.
  • surrogate key.
Q.12

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

  • either table without specifying parent and child tables.
  • the parent table.
  • the child table.
  • either the parent table or the child table.
Q.13

Cascading updates refers to child rows being automatically deleted when a parent row is deleted.

  • True
  • False
Q.14

When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

  • True
  • False
Q.15

When the parent entity is required and the parent has a surrogate key, update actions can be ignored.

  • True
  • False
Q.16

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

  • True
  • False
Q.17

All primary keys are required.

  • True
  • False
Q.18

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

  • True
  • False
Q.19

In 1:N relationships, which entity becomes the parent entity is arbitrary.

  • True
  • False
Q.20

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

  • either table without specifying parent and child tables.
  • the parent table.
  • the child table.
  • either the parent table or the child table.
0 h : 0 m : 1 s