Multiple choice technology databases

Delete from Employee where grade = ‘Y’” deletes

  1. All rows of the Employee table

  2. Rows of the Employee table where the set grade is ‘Y’

  3. Delete 1 row

  4. Nothing will be deleted

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

DELETE with WHERE clause removes only rows matching the condition. It will delete all Employee rows where grade equals 'Y'. If no rows match, nothing is deleted.