Multiple choice technology databases

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

  1. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen';

  2. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen ;

  3. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen' ;

  4. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen' ;
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

UPDATE table SET column=value WHERE condition is the standard SQL syntax. MODIFY and INTO are not valid keywords in UPDATE statements.

Keep practicing — related questions