Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which SQL command is used to remove all rows from a table quickly without logging individual row deletions?

  1. A DELETE
  2. B TRUNCATE
  3. C DROP
  4. D REMOVE
Answer

TRUNCATE

TRUNCATE is DDL that drops and recreates the table. It cannot take a WHERE clause, resets AUTO_INCREMENT and causes an implicit commit.

All MySQL MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as