UTpaper

Free mock tests & test series

Question 36Asked in DSSSB TGT Computer Science (Technical), 1 Aug 2021, Shift 1

Which of the following statement(s) is/are correct regarding a relation in second normal form?

Which of the following statement(s) is/are correct regarding a relation in second normal form? I. It is in first normal form II. Every non-key attribute is fully and functionally independent on the primary key
  1. AOnly I
  2. BOnly II
  3. CBoth I and II
  4. DNeither I nor II
Show answerHide answer

Correct answer: (A) Only I

Explanation

A 2NF relation must be in 1NF (I is correct). Statement II says non-key attributes are "independent" of the primary key, but 2NF requires them to be fully functionally dependent on it, so II is wrong.

From DSSSB TGT Computer Science PYQ (Technical), 1 Aug 2021, Shift 1

This is question 36 of DSSSB TGT Computer Science PYQ (Technical), 1 Aug 2021, Shift 1. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.