Multiple choice technology databases

A new table has been created in the employee. There are no rows in the table.What would be the output of the query?select count(*) from employee

  1. No data found

  2. Error

  3. 1

  4. 0

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

COUNT() is an aggregate function that returns the total number of rows in a table, including null values. When a table is empty (no rows), COUNT() returns 0, not an error or 'No data found' message. This is fundamental SQL behavior.