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