In SQL, which syntax is correct for updating data in tblclerk?

  • A. UPDATE tblclerk WHERE sid = 101
  • B. UPDATE tblclerk ON name = ‘dara’ WHERE sid = 101
  • C. UPDATE tblclerk SET name = ‘dara’ WHERE sid = 101
  • D. None correct

Answer: Option C