Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

GATE | Quiz for Sudo GATE 2021 | Question 1

  • Last Updated : 14 Dec, 2020

Which of the following choice(s) is/are correct ?

Note – This question is multiple select questions (MSQ).
(A) If a table has only one candidate key then table can not be in 2 NF.
(B) A relation will be in 2NF if it is in 1NF and all non-key attributes are fully functional dependent on the primary key.
(C) First Normal Form (1NF) does not eliminate redundancy, but rather, it’s that it eliminates repeating groups.
(D) Relation should not have any attribute in Functional Dependency which is non-prime, the attribute that doesn’t occur in any candidate key.

Answer: (A) (B) (C)

Explanation: Only options (A), (B), and (C) are correct.

Option (D) is false.

Refer – Normalization Process in DBMS

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!