Multiple choice technology databases

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

  1. INSERT INTO Persons (LastName) VALUES ('Olsen')

  2. INSERT ('Olsen') INTO Persons (LastName)

  3. INSERT INTO Persons ('Olsen') INTO LastName

  4. INSERT INTO Persons ('Olsen')

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When inserting into specific columns, use INSERT INTO TableName (ColumnName) VALUES (value). The column list in parentheses must match the values. Options B, C, and D have incorrect syntax - column placement or keyword order is wrong.

Keep practicing — related questions