Laura is adding a new product to the CANDY table, which has columns for the product ID, name, description, and price. Price is a dollars and cents value; the others are strings of characters. Which SQL command should Laura use to add the row for the new product?
A) INSERT CANDY ROW (534, Cordial fudge, Dark chocolate fudge squares topped with a cherry swirl, 5.85);
B) INSERT VALUES ('534', 'Cordial fudge', 'Dark chocolate fudge squares topped with a cherry swirl', 5.85) INTO CANDY;
C) INSERT INTO CANDY VALUES (534, Cordial fudge, Dark chocolate fudge squares topped with a cherry swirl, 5.85);
D) INSERT INTO CANDY VALUES ('534', 'Cordial fudge', 'Dark chocolate fudge squares topped with a cherry swirl', 5.85);

Question

Quizplus · Accepted Answer

The correct SQL syntax for inserting a new row into a table is "INSERT INTO table_name VALUES (value1, value2, ...);". Option D correctly follows this syntax, including using quotes around string values and not using quotes around numeric values.

Laura Is Adding a New Product to the CANDY Table