You have an inventory management database that contains the following table. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

The correct answer is C. UPDATE. Update statement is used to change the value of a column. https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15

Submitted by takeshi77· Mar 30, 2026Identify considerations for relational data on Azure

Question

You have an inventory management database that contains the following table. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

Exhibit

Options

AINSERT
BMERGE
CUPDATE
DCREATE

How the community answered

(61 responses)

A
7% (4)
B
3% (2)
C
89% (54)
D
2% (1)

Explanation

Update statement is used to change the value of a column. https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15

Topics

#SQL DML#UPDATE statement#relational database#T-SQL

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice