Q.1

A key:

  • must always be composed of two or more columns.
  • can only be one column.
  • identifies a row.
  • identifies a column.
Q.2

A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.

  • True
  • False
Q.3

Row is synonymous with the term:

  • record.
  • relation.
  • column.
  • field.
Q.4

A functional dependency is a relationship between or among attributes.

  • True
  • False
Q.5

The only reason for the existence of relations is to store instances of functional dependencies.

  • True
  • False
Q.6

In a relation, the rows are sometimes called "records."

  • True
  • False
Q.7

An attribute is a(n):

  • column of a table.
  • two dimensional table.
  • row of a table.
  • key of a table.
Q.8

A functional dependency is always an equation.

  • True
  • False
Q.9

The primary key is selected from the:

  • composite keys.
  • determinants.
  • candidate keys.
  • foreign keys.
Q.10

A key is a group of one or more attributes that uniquely identifies a row.

  • True
  • False
Q.11

A relation is in 5NF when multivalued dependencies are isolated in their own relation.

  • True
  • False
Q.12

A relation is a two-dimensional table.

  • True
  • False
Q.13

Any table that meets the definition of a relation is said to be in first normal form.

  • True
  • False
Q.14

A relation has cells that hold multi-value entries.

  • True
  • False
Q.15

Keys made up of two or more attributes are called composite keys.

  • True
  • False
Q.16

Given the functional dependency R → S , R is called the determinant.

  • True
  • False
Q.17

The functional dependency R → S means that the value of S can be determined when we are given a value of R.

  • True
  • False
Q.18

In a relation, the columns are sometimes called "attributes."

  • True
  • False
Q.19

Given the functional dependency R → (S,T) , then it is also true that R → S.

  • True
  • False
Q.20

In a relation, the rows are sometimes called "fields."

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