Examice

Exam ACD100 All QuestionsBrowse all questions from this exam

Go to Exam

Question 15

Review the following table.

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

INSERT price = 0.9 -

INTO product -

WHERE product_id = 3;

MODIFY product -

UPDATE price = 0.9 -

WHERE product_id = 3;

SET product -

(price) VALUES (0.9)

WHERE product_id = 3;

UPDATE product -

SET price = 0.9 -

WHERE product_id = 3;

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

yanoolthecoolOption: D

D, no brainer, if it didn't start with UPDATE (or MERGE(or FLASHBACK (or etc.. advanced stuff))) then its not gonna 'alter' the row.