Multiple choice technology databases

Which of the following will delete all the rows from the table T1

  1. Delete * from table T1

  2. Delete all from T1

  3. Delete * from T1

  4. Delete From T1

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

To delete all rows from a table T1, use 'DELETE FROM T1'. Option A is incorrect because DELETE doesn't use '*'. Option B is incorrect because 'all' is not valid SQL syntax. Option C is incorrect for the same reason as A. The correct syntax is DELETE FROM table_name with no WHERE clause.