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:A
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’