What is the correct syntax in SQL for the update?

  • A. UPDATE tblcustomer SET name = ‘sok’
  • B. UPDATE TABLE tblcustomer SET name = ‘sok’
  • C. UPDATE TABLE tblcustomer SET name = ‘sok’ WHERE cid = 101
  • D. None correct

Answer: Option C