DBMS QUIZ UNIT 3- NORMALUZATION

A ___ is normalized after it has been organized.

• 1. Table

• 1. Database

• 1. Row

• 1. Column

By normalizing relations or sets of relations, one minimizes ___.

• 1. Data

• 1. Fields

• 1. Redundancy

• 1. Database

In addition to removing undesirable characteristics, normalization also eliminates ___ anomalies.

• 1. Insert

• 1. Update

• 1. Delete

• 1. All of the above

Redundancy is reduced in a database table by using the ___ form.

• 1. Abnormal

• 1. Normal

• 1. Special

• None

In practical applications, how many types of Normal Forms are there?

• 3

• 4

• 5

• 6

Which of the following is not a type of Normal Form?

• 1. 1NF

• 1. 2NF

• 1. 3NF

• 1. 10NF

Which of the following is a type of Normal Form?

• 1. ACNF

• 1. BCNF

• 1. CCNF

• 1. DCNF

When a relation contains an atomic value, it is a ___ relation.

• 1. 1NF

• 1. 2NF

• 3NF

• BCNF

2NF relations are those that are in 1NF with all the attribute types dependent on the ___ key.

• 1. Primary

• 1. Foreign

• 1. Composite

• 1. Alternate

When a relation is in 2NF and there is ___, it is in 3NF.

• 1. Transition Dependency

• 1. No Transition Dependency

• 1. Relational Dependency

• 1. No Relational Dependency