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 following query?select count(*) from employee

  1. Error

  2. 1

  3. No data Found

  4. 0

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

The COUNT(*) aggregate function counts the number of rows in a table. If a table has been created but contains no rows, the query returns 0 rather than an error or 'No data Found'.