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

technology databases

  1. MODIFY 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. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

Show answer
Correct Option: D

Find more quizzes: