CompTIA ITF+ FC0-U61 (V5) Practice Question

The correct approach is to use an UPDATE statement that changes the price only for the row whose item ID matches the product in question (for example: UPDATE inventory SET price = new_price WHERE item_id = 123;). The UPDATE statement is designed to modify existing data, and the WHERE clause ensures that only the intended record is changed. An INSERT statement would add a new record instead of changing the existing one, a SELECT statement merely retrieves data, and deleting and re-adding the row introduces unnecessary risk to referential integrity and audit trails.