COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
|
|
UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
|
|
|
MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
|
|
|
MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
|
|
|
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
|
Explanation:
Detailed explanation-1: -With SQL, how can you delete the records where the “FirstName” is “Peter” in the Persons Table? DELETE FROM Persons WHERE FirstName = ‘Peter’;
There is 1 question to complete.