Multiple choice technology databases

With SQL, how can you insert a new record into the "Persons" table?

  1. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

  2. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

  3. INSERT ('Jimmy', 'Jackson') INTO Persons

  4. INSERT VALUES ('Jimmy', 'Jackson')

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

The correct SQL syntax for inserting a new record is 'INSERT INTO table_name VALUES (values)' as shown in option A. Options B, C, and D have incorrect syntax - they either place keywords in wrong order, omit required keywords, or miss the table name entirely.

Keep practicing — related questions