Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

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?
A . INSERT
B. MERGE
C. UPDATE
D. CREATE

View Answer

Answer: C

Explanation:

Reference: https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15