To change "Hansen" into "Nilsen" in the "LastName" column in the "Persons" table, you would use the UPDATE statement. Let's go through each option to understand why it is correct or incorrect:

Option A) MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen' - This option is incorrect because the correct keyword to use for updating records in SQL is UPDATE, not MODIFY.

Option B) MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen' - This option is incorrect because the INTO keyword is not used in the UPDATE statement. The correct syntax is UPDATE table_name SET column_name = new_value WHERE condition.

Option C) UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen' - This option is incorrect because, again, the INTO keyword is not used in the UPDATE statement. Additionally, the new value should be 'Nilsen', not 'Hansen'.

Option D) UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen' - This option is correct. The UPDATE statement is used to modify records in a table. In this case, it will update the "LastName" column in the "Persons" table, setting the value to 'Nilsen' for all records where the current value in the "LastName" column is 'Hansen'.

Therefore, the correct answer is D.

• Thanks
• Wrong explanation

To select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter," you can use the following SQL query:

D. SELECT * FROM Persons WHERE FirstName='Peter'

Let's go through each option to understand why it is correct or incorrect:

Option A) SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter' - This option is incorrect because the "LIKE" operator is used for pattern matching and not for exact matching. In this case, we need to match the exact value of "Peter," so the "=" operator should be used instead.

Option B) SELECT * FROM Persons WHERE FirstName<>'Peter' - This option is incorrect because it selects all the records where the value of the column "FirstName" is not equal to "Peter." However, we want to select all the records where the value is equal to "Peter," so this option is not the correct choice.

Option C) SELECT [all] FROM Persons WHERE FirstName='Peter' - This option is incorrect because the keyword "all" is not necessary in the SELECT statement. The correct syntax is to use the asterisk (*) to select all columns.

Option D) SELECT * FROM Persons WHERE FirstName='Peter' - This option is correct because it selects all the records from the table "Persons" where the value of the column "FirstName" is equal to "Peter." This is the correct choice because it matches the given conditions.

The correct answer is D. SELECT * FROM Persons WHERE FirstName='Peter'. This option is correct because it selects the desired records where the value of the column "FirstName" is "Peter".

• Thanks
• Wrong explanation