Given the following options are in mySQL, which option correctly alters the last row on the table?

exams ACD100 V2 ACD100 exam 0 Comments

Review the following table.

Given the following options are in mySQL, which option correctly alters the last row on the table?
A . INSERT price = 0.9 –
INTO product –
WHERE product_id = 3;
B . MODIFY product –
UPDATE price = 0.9 –
WHERE product_id = 3;
C . SET product –
(price) VALUES (0.9)
WHERE product_id = 3;
D . UPDATE product –
SET price = 0.9 –
WHERE product_id = 3;