To change "Hansen" into "Nilsen" in the "LastName" column in the Persons table, you need to use an SQL UPDATE statement. Let's go through each option to understand why it is correct or incorrect:
Option A) UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen' - This option is incorrect because the syntax for the UPDATE statement is incorrect. The correct syntax is UPDATE table_name SET column_name = new_value WHERE condition.
Option B) MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen' - This option is incorrect because the syntax for the MODIFY statement is incorrect. The correct syntax for updating data in SQL is using the UPDATE statement.
Option C) UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen' - This option is correct because it follows the correct syntax for an SQL UPDATE statement. It updates the LastName column in the Persons table, setting the value to 'Nilsen' where the current value is 'Hansen'.
Option D) MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen' - This option is incorrect because the syntax for the MODIFY statement is incorrect. The correct syntax for updating data in SQL is using the UPDATE statement.
The correct answer is C. This option is correct because it uses the correct syntax for an SQL UPDATE statement to update the LastName column in the Persons table from 'Hansen' to 'Nilsen' where the current value is 'Hansen'.