Which of the following SQL queries is correct for inserting a new record into the Products table with the columns Product_ID, Product_Name and Price?

Question

Which of the following SQL queries is correct for inserting a new record into the  Products  table with the columns  Product_ID ,  Product_Name   and  Price ?

Accepted Answer

INSERT INTO Products (Product_ID, Product_Name, Price) VALUES (P001, 'Laptop', 1200);

Answer

INSERT INTO Products VALUES (1200, 'P001', 'Laptop');

Answer

INSERT INTO Products VALUES ('P001', 'Laptop', 'Electronics', 1200);

Answer

INSERT INTO Products (Product_ID, Product_Name, Price) VALUES ('P001', 'Laptop', 'Electronics');

Crowdly

Which of the following SQL queries is correct for inserting a new record into th...

Want instant access to all verified answers on moodle.myefrei.fr?