1
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

2
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.
3
GATE CSE 2022
Numerical
+1
-0

Consider a relation R(A, B, C, D, E) with the following three functional dependencies.

AB $$\to$$ C ; BC $$\to$$ D ; C $$\to$$ E;

The number of superkeys in the relation R is _________.

Your input ____
4
GATE CSE 2021 Set 2
MCQ (Single Correct Answer)
+1
-0.33

Consider the following statements S1 and S2 about the relational data model:

S1: A relation scheme can have at most one foreign key.

S2: A foreign key in a relation scheme R cannot be used to refer to tuples of R.

Which one of the following choices is correct? 

A
S1 is true and S2 is false.  
B
Both S1 and S2 are true.  
C
Both S1 and S2 are false.  
D
S1 is false and S2 is true. 
GATE CSE Subjects
Software Engineering
Web Technologies
EXAM MAP