Which SQL command is used to remove specific records from a table?

Options

  • A. DROP
  • B. DELETE
  • C. ALTER
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. DELETE

Detailed Explanation

  • DELETE removes records from a table.
  • The WHERE clause can be used to delete selected rows.
  • Without WHERE, all records are deleted, but the table structure remains.