GATE CS 2026 (Forenoon) — Question 31

Database Management Systems (DBMS)Normalization Schemes (1NF, 2NF, 3NF, BCNF Boundaries)MSQ1 markMedium

In the context of relational database normalization, which of the following statements is/are true?
  1. A
    It is always possible to obtain a dependency-preserving 3NF decomposition of a relation
  2. B
    It is always possible to obtain a dependency-preserving 1NF decomposition of a relation
  3. C
    It is not always possible to obtain a dependency-preserving BCNF decomposition of a relation
  4. D
    It is not always possible to obtain a dependency-preserving 2NF decomposition of a relation
Practise the full 2026-FN paper
Challenge a friend: WhatsApp Telegram
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
Practise more on Normalization Schemes (1NF, 2NF, 3NF, BCNF Boundaries)Timed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group