GATE CS 2022 (Forenoon) — Question 14

Database Management Systems (DBMS)Normalization Schemes (1NF, 2NF, 3NF, BCNF Boundaries)MCQ1 mark · −1/3 if wrongEasy

In a relational data model, which one of the following statements is TRUE?
  1. A
    A relation with only two attributes is always in BCNF.
  2. B
    If all attributes of a relation are prime attributes, then the relation is in BCNF.
  3. C
    Every relation has at least one non-prime attribute.
  4. D
    BCNF decompositions preserve functional dependencies.
Practise the full 2022-FN paper
Challenge a friend: WhatsApp Telegram
From RENYXERAThis week's 10-question challengeSame 10 past-GATE questions for everyone this week — see where you stand.
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