GATE DA 2025 — Question 57

Database Management and Warehousingintegrity constraints, normal formMSQ2 marksMedium

Consider a database relation R with attributes ABCDEFG, and having the following functional dependencies: A → BCEF \(\qquad\) E → DG \(\qquad\) BC → A Which of the following statements is/are correct?
  1. A
    A is the only candidate key of R
  2. B
    A, BC are the candidate keys of R
  3. C
    A, BC, E are the candidate keys of R
  4. D
    Relation R is not in Boyce-Codd Normal Form (BCNF)
Practise the full 2025 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 integrity constraints, normal formTimed, 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