Microsoft Exam Questions

What should you include in the update statement?

You have a table that contains product IDs and product names.
You need to write an UPDATE statement to change the name of a specific product to glass.
What should you include in the update statement?

A.
SET ProduetName = ‘glass’

B.
LET ProduetName = ‘glass’

C.
EXEC ProduetName = ‘glass’

D.
ASSIGN ProduetName = ‘glass’