GATE CS 2026 (Forenoon) — Question 30

Database Management Systems (DBMS)Integrity Constraints & Functional DependenciesMSQ1 markMedium

Let \( P, Q, R \) and \( S \) be the attributes of a relation in a relational schema. Let \( X \rightarrow Y \) indicate functional dependency in the context of a relational database, where \( X, Y \subseteq \{P, Q, R, S\} \). Which of the following options is/are always true?
  1. A
    If \( \{P, Q\} \rightarrow \{R\} \) and \( \{P\} \rightarrow \{R\} \), then \( \{Q\} \rightarrow \{R\} \)
  2. B
    If \( \{P, Q\} \rightarrow \{R\} \), then (\( \{P\} \rightarrow \{R\} \) or \( \{Q\} \rightarrow \{R\} \))
  3. C
    If (\( \{P\} \rightarrow \{R\} \) and \( \{Q\} \rightarrow \{S\} \)), then \( \{P, Q\} \rightarrow \{R, S\} \)
  4. D
    If \( \{P\} \rightarrow \{R\} \), then \( \{P, Q\} \rightarrow \{R\} \)
Practise the full 2026-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 Integrity Constraints & Functional DependenciesTimed, 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