To insert "Olsen" as the "LastName" in the "Persons" table using SQL, you can use the following syntax:
B. INSERT INTO Persons (LastName) VALUES ('Olsen')
Explanation:
Option A: INSERT ('Olsen') INTO Persons (LastName) - This is an incorrect syntax. The correct syntax for the INSERT statement requires the keyword "INTO" before the table name, followed by the column names in parentheses, and the keyword "VALUES" before the values to be inserted.
Option B: INSERT INTO Persons (LastName) VALUES ('Olsen') - This is the correct syntax. It specifies the table "Persons" and the column "LastName" where the value 'Olsen' will be inserted.
Option C: INSERT INTO Persons ('Olsen') INTO LastName - This is an incorrect syntax. The correct syntax for the INSERT statement requires the keyword "VALUES" before the values to be inserted.
Option D: INSERT FROM Persons ('Olsen') INTO LastName - This is an incorrect syntax. The correct syntax for the INSERT statement does not include the keyword "FROM" before the table name, and the column name should be specified before the keyword "VALUES".
Therefore, the correct answer is B. INSERT INTO Persons (LastName) VALUES ('Olsen').