1
GATE CSE 2026 Set 1
MCQ (More than One Correct Answer)
+1
-0

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?

A

If $(\{P, Q\} \rightarrow\{R\}$ and $\{P\} \rightarrow\{R\})$, then $\{Q\} \rightarrow\{R\}$

B

If $\{P, Q\} \rightarrow\{R\}$, then $(\{P\} \rightarrow\{R\}$ or $\{Q\} \rightarrow\{R\})$

C

If $(\{P\} \rightarrow\{R\}$ and $\{Q\} \rightarrow\{S\})$, then $\{P, Q\} \rightarrow\{R, S\}$

D

If $\{P\} \rightarrow\{R\}$, then $\{P, Q\} \rightarrow\{R\}$

2
GATE CSE 2026 Set 1
MCQ (More than One Correct Answer)
+1
-0

In the context of relational database normalization, which of the following statements is/ are true?

A

It is always possible to obtain a dependency-preserving 3NF decomposition of a relation

B

It is always possible to obtain a dependency-preserving 1NF decomposition of a relation

C

It is not always possible to obtain a dependency-preserving BCNF decomposition of a relation

D

It is not always possible to obtain a dependency-preserving 2NF decomposition of a relation

3
GATE CSE 2024 Set 1
MCQ (More than One Correct Answer)
+1
-0

Which of the following statements about a relation $R$ in first normal form (1NF) is/are TRUE?

A

$R$ can have a multi-attribute key

B

$R$ cannot have a foreign key

C

$R$ cannot have a composite attribute

D

$R$ cannot have more than one candidate key

4
GATE CSE 2022
MCQ (Single Correct Answer)
+1
-0.33

In a relational data model, which one of the following statements is TRUE?

A
A relation with only two attributes is always in BCNF.
B
If all attributes of a relation are prime attributes, then the relation is in BCNF.
C
Every relation has at least one non-prime attribute.
D
BCNF decompositions preserve functional dependencies.

GATE CSE Subjects

Browse all chapters by subject

Software Engineering
Web Technologies