Multiple choice technology databases

Which of the below is the correct query to update the columns of a table:

  1. update table TABLE_NAME set COMLUMN_NAME=<new values> where <conditions>

  2. update TABLE_NAME set COMLUMN_NAME=<new values> where <conditions>

  3. Both 1 & 2 are correct

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The UPDATE statement syntax requires specifying the table name directly after UPDATE, not using the TABLE keyword. Option B correctly shows 'UPDATE TABLE_NAME SET column_name=value WHERE condition'. Option A incorrectly includes 'TABLE' as a keyword before the table name.

Keep practicing — related questions