chapter 2 quiz 2

Question 1

The first step of the normalization process is to identify all the candidate keys of a relation. (T/F)

Answer 1

True

Question 2

In the normalization process, it is not necessary to identify all the functional dependencies in a relation.

Answer 2

False

Question 3

Normalization is the process of removing all functional dependencies from a relation

Answer 3

False

Question 4

A relational database stores data in the form of:

A) lists.

B) forms.

C) columns.

D) tables.

E) spreadsheets.

Answer 4

D) tables.

Question 5

SQL stands for:

A) Standard Query Language.

B) Structural Question Language.

C) Structured Query Language.

D) Standard Question Language.

E) Structured Question Language.

Answer 5

C) Structured Query Language.

Question 6

Surrogate key values have no meaning to the users.

Answer 6

True