Multiple choice technology databases

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

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

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

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

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

INSERT INTO table VALUES (...) is the correct syntax. Options A and B have incorrect word order, and D incorrectly adds 'Table' keyword.

Keep practicing — related questions