Which of the following will DELETE all of the rows from table T03?
-
DELETE * FROM TABLE T03
-
DELETE ALL FROM T03
-
DELETE * FROM T03
-
DELETE FROM T03
D
Correct answer
Explanation
DELETE FROM T03 is the correct SQL syntax to delete all rows from a table. Options A and C incorrectly use DELETE * which is invalid syntax - DELETE operates on rows, not columns. Option B incorrectly uses DELETE ALL which is not standard SQL syntax.