Multiple choice

Which of the following statements is/are correct?

(i) SQL allows use of DISTINCT with count (*).

(ii) If is not legal to use DISTANCE with MAX and MIN.

(iii) If is ‘WHERE’ clause and a ‘HAVING’ clause appear in the same clause is applied first.

(iv) By default, the ‘ORDER BY’ clause list items in a descending order.

  1. All of the above

  2. (i), (ii), (iii)

  3. (ii), (iii)

  4. (iii)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Only statement (iii) is correct. SQL does not allow use of distance with COUNT(*). If is legal to use DISTINCT MAX and MIN. By default the ‘ORDER BY’ clause list items in an ascending order.

Keep practicing — related questions