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

INSERT INTO with VALUES is the correct syntax for adding a new record. The table name follows 'INSERT INTO', then VALUES with the data in parentheses. Options B, C, and D have incorrect word order or missing the table name specification.

Keep practicing — related questions