Normalization Questions

MCQ bookmark_border

11.

a)

A

Be in Second Normal Form

B

Be in Third Normal Form

C

Have a single attribute key

D

Have a composite key

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

12.

a)

A

Eliminate all hidden dependencies

B

Eliminate the possibility of a insertion anomalies

C

Have a composite key

D

Have all non key fields depend on the whole primary key

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

13.

one ofthe following statements about normal forms is FALSE?

A

BCNF is stricter than 3 NF

B

Lossless, dependency

C

Loss less, dependency ? preserving decomposition into BCNF is always possible

D

Any relation with two attributes is BCNF

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

14.

Functional Dependencies are the types of constraints that are based on______

A

Key

B

Key revisited

C

Superset key

D

None of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

15.

a)

A

Functional dependency

B

Database modeling

C

Normalization

D

Decomposition

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

16.

a)

A

1NF

B

2NF

C

3NF

D

All of the mentioned

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

17.

a)

A

2NF

B

3NF

C

4NF

D

5NF

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

18.

a)

A

1NF

B

2NF

C

3NF

D

4NF

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

19.

For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

A

1 NF only

B

2 NF and hence also in 1 NF

C

3NF and hence also in 2NF and 1NF

D

BCNF and hence also in 3NF, 2NF and 1NF

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

20.

We can use the following three rules to find logically implied functional dependencies. This collection of rules is called

A

Axioms

B

Armstrong?s axioms

C

Armstrong

D

Closure

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion