Explore topic-wise MCQs in Database.

This section includes 5 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.

1.

IS?$

A. In second normal form but not in third normal form
B. In third normal form but not in BCNF
C. In BCNF
D. None of the mentioned
Answer» C. In BCNF
Discussion
2.

Which one of the following statements about normal forms is FALSE?

A. BCNF is stricter than 3NF
B. Lossless, dependency-preserving decomposition into 3NF is always possible
C. Lossless, dependency-preserving decomposition into BCNF is always possible
D. Any relation with two attributes is in BCNF
Answer» D. Any relation with two attributes is in BCNF
Discussion
3.

Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

A. Zero
B. More than zero but less than that of an equivalent 3NF decomposition
C. Proportional to the size of F+
D. Indeterminate
Answer» C. Proportional to the size of F+
Discussion
4.

Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is

A. dependency preserving and lossless join
B. lossless join but not dependency preserving
C. dependency preserving but not lossless join
D. not dependency preserving and not lossless join
Answer» E.
Discussion
5.

Which normal form is considered adequate for normal relational database design?

A. 2NF
B. 5NF
C. 4NF
D. 3NF
Answer» E.
Discussion