Q.1

When mapping a multivalued attribute into a relation which of the following is true?

  • One relation is created.
  • Two relations are created.
  • Three relations are created.
  • Four relations are created.
Q.2

A relation has which of the following properties?

  • Each row is not unique.
  • Attributes can have the same name within a given table.
  • Each relation has a unique name.
  • The order of the columns is significant.
Q.3

If no multivalued attributes exist in a relation, then the relation is in what normal form?

  • First normal form
  • Second normal form
  • Third normal form
  • Fourth normal form
Q.4

When mapping a ternary relationship with an associative entity into a relation which of the following is true?

  • One relation is created.
  • Two relations are created.
  • Three relations are created.
  • Four relations are created.
Q.5

A primary key is which of the following?

  • Any attribute
  • An attribute that uniquely identifies each row
  • An attribute that uniquely identifies each column
  • A derived attribute
Q.6

The relational model consists of:

  • data in the form of tables.
  • data redundancy.
  • operations using non-SQL languages.
  • unorganized data.
Q.7

When mapping a regular entity into a relation which of the following is true?

  • One relation is created.
  • Two relations are created.
  • Three relations are created.
  • Four relations are created.
Q.8

When mapping a binary many-to-many relationship into a relation which of the following is true?

  • One relation is created.
  • Two relations are created.
  • Three relations are created.
  • Four relations are created.
Q.9

When mapping a supertype/subtype relationship which of the following is true?

  • The supertype primary key is assigned to each subtype.
  • The subtype primary key is assigned to each supertype.
  • There is no link between the supertype/subtype entities.
  • There is no primary key/foreign key relationship between a supertype/subtype.
Q.10

Relations are:

  • two-dimensional tables.
  • three-dimensional tables.
  • four-dimensional tables.
  • five-dimensional tables.
Q.11

The entity integrity rule states that:

  • no primary key attribute may be null.
  • no primary key can be composite.
  • no primary key may be unique.
  • no primary key may be equal to a value in a foreign key.
Q.12

When mapping a many-to-many unary relationship into a relation which of the following is true?

  • One relation is created.
  • Two relations are created.
  • Three relations are created.
  • Four relations are created.
Q.13

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

  • First normal form
  • Second normal form
  • Third normal form
  • Fourth normal form
Q.14

A foreign key is which of the following?

  • Any attribute
  • The same thing as a primary key
  • An attribute that serves as the primary key of another relation
  • An attribute that serves no purpose
Q.15

A transitive dependency is which of the following?

  • A functional dependency between two or more key attributes.
  • A functional dependency between two or more nonkey attributes.
  • A relation that is in first normal form.
  • A relation that is in second normal form.
0 h : 0 m : 1 s