Multiple choice technology databases

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

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

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

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

  4. INSERT INTO Table Persons (LastName) VALUES ('Olsen');
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The standard SQL syntax for inserting a value into a specific column is INSERT INTO table_name (column_name) VALUES (value);. The correct option matches this syntax perfectly. The other options violate standard SQL syntax constraints by using incorrect keywords or incorrect placement of values.

Keep practicing — related questions