Question 32

Which of the following statements is false with respect to Relational DBMS?

  1. AA disadvantage of highly normalized tables is that queries may require too many time consuming joins.
  2. BForeign key constraints are referential integrity constraints.
  3. CA primary key uniquely indentifies a row in a table.
  4. DNulls reduce space requirements in tables.
Show answerHide answer

Correct answer: (D) Nulls reduce space requirements in tables.

Explanation

Nulls do not reduce storage space, so (D) is false. The other statements are true: heavy normalization means more joins, foreign keys enforce referential integrity, and a primary key uniquely identifies a row.

From DSSSB TGT Computer Science Practice Set 3

This is question 32 of DSSSB TGT Computer Science Practice Set 3. 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.