What happens if you run a DELETE command that does not contain a WHERE clause?
A)The table will be deleted.
B)All rows will be deleted from the table.
C)All values would be replaced by nulls.
D)None of the above.

Question

What happens if you run a DELETE command that does not contain a WHERE clause?​
A)The table will be deleted.
B)​All rows will be deleted from the table.
C)All values would be replaced by nulls.
D)​None of the above.

Quizplus · Accepted Answer

If a DELETE command does not contain a WHERE clause, it will delete all rows from the table, which is known as a "TRUNCATE" operation. This can be potentially dangerous if executed accidentally, as it will erase all data from the table without any opportunity for recovery. It is important to always double-check the syntax and conditions of a DELETE statement before executing it.

What Happens If You Run a DELETE Command That Does