Multiple choice technology databases

Which of the following will DELETE all of the rows from table T03?

  1. DELETE * FROM TABLE T03

  2. DELETE ALL FROM T03

  3. DELETE * FROM T03

  4. DELETE FROM T03

Reveal answer Fill a bubble to check yourself
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.