Review the following table.
Given the following options are in mySQL, which option correctly alters the last row on the table?
ACD100 Exam QuestionsBrowse all questions from this exam
ACD100 Exam - Question 15
Show AnswerHide Answer
Correct Answer: D
The correct SQL command to update the price of the product with product_id = 3 is 'UPDATE product SET price = 0.9 WHERE product_id = 3;'. This command correctly specifies the UPDATE statement to modify the existing row and the SET clause to assign the new price value, followed by the WHERE clause to target the specific row based on product_id.
Discussion
1 commentyanoolthecoolOption: D
Dec 26, 2023D, no brainer, if it didn't start with UPDATE (or MERGE(or FLASHBACK (or etc.. advanced stuff))) then its not gonna 'alter' the row.