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 ('Jimmy', 'Jackson') INTO Persons

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

  4. INSERT ('Jimmy', 'Jackson') INTO Persons
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

INSERT INTO table VALUES (...) is the correct syntax. The table name must come after INTO, not at the end. Option A follows this pattern correctly.

Keep practicing — related questions