Multiple choice technology databases

The table employee contains 20 records. What is the output of the query " Select 8 from Employee"?

  1. No Rows retrieved

  2. 8 is displayed 20 times

  3. 8 is displayed 1 time

  4. error message

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

Selecting a literal constant like 8 from a table evaluates that constant for every row matching the query. Since the employee table contains 20 records, the number 8 is returned 20 times.