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? 

Answer options:

A. INSERT
B. MERGE
C. UPDATE
D. CREATE

C

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