Skip to content
Related Articles

Related Articles

GATE | Quiz for Sudo GATE 2021 | Question 2
  • Last Updated : 14 Dec, 2020

Which of the option(s) is/are correct ?

Note – This question is multiple select questions (MSQ).
(A) Relation R have attributes {a1, a2, a3,…,an} can have maximum number of super keys are 2(n-1)
(B) Relation R have attributes {a1, a2, a3,… ,an} and the candidate key is “a1 a2 a3” then the possible number of super keys are 2(n-3).
(C) A relation R(A, B, C, D, E, F, G, H) with set of functional dependencies {CH → G, A → BC, B → CFH, E → A, F → EG} has 120 superkeys.
(D) The maximum number of superkeys for the relation schema R(E,F,G,H) with E as the key is 4.


Answer: (B) (C) (D)

Explanation: Only option (A) is false.

Relation R have attributes {a1, a2, a3,…,an} can have maximum number of super keys are 2n-1.

Refer – Number of possible Superkeys in DBMS

Quiz of this Question
Please comment below if you find anything wrong in the above post

My Personal Notes arrow_drop_up
Recommended Articles
Page :