Question 1

In general, denormalization produces

Accepted Answer

faster performance.

Answer

more join

Answer

a slower system response

Answer

less data redundancy

Question 2

Some normalization forms are

Accepted Answer

all of the above

Answer

1NF

Answer

2NF

Answer

3NF

Answer

none of the above

Question 3

A table that displays data redundancies yields the following anomalies:

Accepted Answer

all of the above

Answer

update anomalies

Answer

insertion anomalies

Answer

deletion anomalies

Answer

none of the above

Question 4

The term first normal form (1NF) describes the tabular format in which:

Accepted Answer

all of the above

Answer

all the key attributes are defined.

Answer

there are no repeating groups in the table. Row/column intersection can contain one and only one value, not a set of values.

Answer

all attributes are dependent on the primary key

Answer

none of the above

Question 5

A table is in the Fourth Normal Form (4NF) if

Accepted Answer

B and C

Answer

All attributes must be dependent on the primary key, and must be dependent on each other.

Answer

All attributes must be dependent on the primary key, but must be independent of each other.

Answer

No row can contain two or more multivalued facts about an entity

Answer

A and C

Question 6

The conflicts between design efficiency, information requirements, and processing speed are often resolved through

Accepted Answer

compromises that include denormalization

Answer

conversion from 1NF to 2NF

Answer

conversion from 2NF to 3NF

Answer

conversion from 3NF to 4NF

Ohne Titel

Erstelle ein kostenloses Konto, um dieses Quiz zu beenden