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
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).