Examice

Exam ACD100 All QuestionsBrowse all questions from this exam

Go to Exam

Question 17

Review the following table.

Which option correctly deletes the last row from the table?

REMOVE product_id = 3 IN product;

DELETE FROM product WHERE product_id = 3;

DELETE product_i = 3 FROM product;

REMOVE FROM product WHERE product_id = 3;

Correct Answer: B

To delete the last row from the table, the correct SQL syntax is 'DELETE FROM product WHERE product_id = 3;'. This command will remove the row from the table where the product_id is 3, corresponding to the 'Orange' row. Options A and D use the 'REMOVE' keyword, which is not valid in SQL. Option C contains a syntax error and does not correctly specify the column name.

Discussion

yanoolthecoolOption: B

B, Delete FROM

Nova077Option: B

correct answer is B