Microsoft Technology Associate Mta · Free Practice Question Easy
Question 12
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
ASSIGN ProduetName = 'glass' -
B
LET ProduetName = 'glass' -
C
SET ProduetName = 'glass' -
D
EXEC ProduetName = 'glass'
Reveal correct answer
Correct answer: C
Explanation
The UPDATE statement is used to modify the existing records in a table. UPDATE Syntax: UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE conditionDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
