Q. 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’
πŸ’¬ Discuss
βœ… Correct Answer: (D) UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

You must be Logged in to update hint/solution

πŸ’¬ Discussion

πŸ“Š Question Analytics

πŸ‘οΈ
545
Total Visits
πŸ“½οΈ
3 y ago
Published
πŸŽ–οΈ
Mr. Dubey
Publisher
πŸ“ˆ
90%
Success Rate