Multiple choice technology

With SQL, how can you return the number of records in the "Persons" table?

  1. SELECT COLUMNS(*) FROM Persons

  2. SELECT COUNT() FROM Persons

  3. SELECT COUNT(*) FROM Persons

  4. SELECT COLUMNS() FROM Persons

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

COUNT(*) is the standard SQL aggregate function that returns the total number of rows in a table, including NULL values. Option A uses non-existent COLUMNS function. Option B has empty COUNT() syntax - needs an argument like * or column name. Option D repeats the COLUMNS error.