Database Fundamentals — Question 31

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?

Answer options

• A. SET ProduetName = 'glass'
• B. LET ProduetName = 'glass'
• C. EXEC ProduetName = 'glass'
• D. ASSIGN ProduetName = 'glass'

Correct answer: A

Explanation

The correct answer is A because the SQL syntax for updating a field requires the use of the SET keyword to assign a new value. The other options (B, C, and D) do not conform to SQL standards for updating records and would result in errors.