The ___________ statement in SQL is used to remove one or more rows from a table.

  • DELETE
  • DROP
  • TRUNCATE
  • UPDATE
The DELETE statement in SQL is used to remove one or more rows from a table based on specified conditions. When you execute a DELETE statement, you can use the WHERE clause to specify which rows to delete. If you omit the WHERE clause, all rows in the table will be deleted, which should be done with caution as it can lead to data loss. Unlike TRUNCATE, DELETE is a DML (Data Manipulation Language) statement that generates transaction logs and can be rolled back if necessary. Understanding how to use DELETE safely and effectively is important for managing data in SQL databases.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *