quiz

Normalization in DBMS

1. What is the primary purpose of database normalization?

  • A) To eliminate redundancy and inconsistencies in data
  • B) To speed up data retrieval operations
  • C) To decrease the storage space required for the database
  • D) To simplify complex queries
A) To eliminate redundancy and inconsistencies in data Explanation

2. Which functional dependency does not ensure a completely non-trivial relationship?

  • A) P -> Q, Q -> R
  • B) P -> Q, Q -> S, R -> S
  • C) P -> Q, Q -> R, R -> S
  • D) P -> Q, Q -> RS
D) P -> Q, Q -> RS Explanation

3. Which normal form requires that each column in a table contains atomic values and each row is uniquely identified?

  • A) Second Normal Form (2NF)
  • B) First Normal Form (1NF)
  • C) Third Normal Form (3NF)
  • D) Boyce-Codd Normal Form (BCNF)
B) First Normal Form (1NF) Explanation

4. Which property of functional dependencies is reflected in the statement “if P -> Q and Q -> R, then P -> R”?

  • A) Reflexivity
  • B) Transitivity
  • C) Augmentation
  • D) None of the above
B) Transitivity Explanation

5. Which of the following are not Armstrong’s Axioms?

  • A) Reflexivity
  • B) Augmentation
  • C) Transitivity
  • D) Integrity
D) Integrity Explanation

Quick Links