Laura Is Adding a New Product to the CANDY Table

Multiple Choice

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) ;