Which SQL command is used to modify existing records in a table?

Options

  • A. INSERT
  • B. UPDATE
  • C. ALTER
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. UPDATE

Detailed Explanation

  • UPDATE command modifies existing records in a table.
  • The WHERE clause specifies which records should be updated.
  • Without WHERE, all rows may be updated.