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

Question

TuteeHUB · Accepted Answer

NA

TuteeHUB · Answer

UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

TuteeHUB · Answer

MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

TuteeHUB · Answer

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

TuteeHUB · Answer

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

1.	How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
A.	UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
B.	MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
C.	MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
D.	UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
Answer» E.

Discussion