- With SQL, how can you insert a new record into the "Persons" table?
-
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
-
INSERT ('Jimmy', 'Jackson') INTO Persons
-
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
-
None
The correct SQL syntax for inserting a record is INSERT INTO table_name VALUES (value1, value2...). Option C shows this correctly. Options A and B have incorrect syntax (INSERT VALUES instead of INSERT INTO VALUES, and INSERT ... INTO instead of INSERT INTO ...).
The standard SQL syntax for inserting a row is: INSERT INTO table_name VALUES (value1, value2, ...) — or with explicit column names: INSERT INTO table_name (col1, col2) VALUES (val1, val2). So "INSERT INTO Persons VALUES ('Jimmy', 'Jackson')" is syntactically correct SQL. The other options reverse or omit the required INTO/VALUES keyword ordering ("INSERT VALUES ... INTO" and "INSERT (...) INTO" are not valid SQL grammar), so they're correctly marked wrong.