Multiple choice technology databases

Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVEL 1 Paul Jones DBA 2 2 George Baker MGR 1 3 Roger Melvin CLERK 3 4 Jim Smith MGR 1 5 Kevin Street CLERK 3 6 Chris Eaton MGR 1 If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1

  1. 0

  2. 1

  3. 3

  4. 6

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

The DELETE statement uses a WHERE clause condition '1 = 1' which is always true for every row. This means the condition applies to all rows in the table, so all 6 rows will be deleted. The WHERE clause doesn't filter any rows out - it's a way to make the DELETE statement apply to the entire table. This is a common pattern for deleting all rows while still using the WHERE clause syntax (versus TRUNCATE which has different behavior regarding logging and triggers).