Database Management System CT-4

A ___ is normalized after it has been organized.

• 1. Table

• 1. Database

• 1. Row

• 1. Column

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

• 1. Insert

• 1. Update

• 1. Delete

• 1. All of the above

Two attributes can be functionally ___ on/of each other.

• 1. Dependent

• 1. Independent

• 1. Both A and B

• 1. None of the above

Which of the following is not Armstrong’s Axiom?

• Pseudotransitivity rule

• Reflexivity rule

• Transitivity rule

• Augmentation rule

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

• 1. Abnormal

• 2. Normal

• 1. Special

• 1. None

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

• 1. 3

• 1. 4

• 1. 5

• 1. 6

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

• 1. 1NF

• 1. 10NF

• 1. 2NF

• 1. 3NF

An attribute that is ___ and the primary key of a table are typically functionally dependent on one another.

• 1. Non-Key

• 1. Key

• 1. One-Key

• 1. Many-Key

Functional dependencies are classified as ___ on the left.

• 1. Dependent

• 1. Determined

• 1. Determinants

• 1. Database

If a functional dependency is reflexive, B is a subset of A and A is the set of attributes, then

• B→A holds

• AB→C holds

• A→B holds

• None of the mentioned