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

Answer: C

Explanation:

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

Latest DP-900 Dumps Valid Version with 134 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments