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

M

Mr. Dubey

🎓 Coach ⭐ 104.48K Points

📊 Database Management System (DBMS)

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

👁️

483

Total Visits

📽️

3 y ago

Published

🎖️

Mr. Dubey

Publisher

📈

94%

Success Rate