Review the following table.
Which option correctly deletes the last row from the table?
ACD100 Exam QuestionsBrowse all questions from this exam
ACD100 Exam - Question 17
Show AnswerHide Answer
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
2 commentsNova077Option: B
Jul 4, 2023correct answer is B
yanoolthecoolOption: B
Dec 26, 2023B, Delete FROM