UTpaper

Free mock tests & test series

Question 153

Which statement about COUNT(*) is correct?

  1. AIt counts only distinct rows
  2. BIt counts only columns
  3. CIt ignores rows with NULL values
  4. DIt counts all rows including rows with NULL values
Show answerHide answer

Correct answer: (D) It counts all rows including rows with NULL values

Explanation

COUNT(column) ignores NULLs; COUNT(*) does not.

From DSSSB TGT Computer Science Full Mock Test 4

This is question 153 of DSSSB TGT Computer Science Full Mock Test 4. 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.