To change records in a table, use the UPDATE keyword to specify the name of the table to update and the ___ keyword to specify the value to assign to the fields in the records that match the condition in the WHERE keyword.
A) CHANGE
B) INSERT
C) PUT
D) SET

Question

Quizplus · Accepted Answer

The keyword to use to specify the value to assign to the fields in the records is SET. Therefore, the correct choice is D. A - CHANGE is not a keyword used to update records in SQL. B - INSERT is used to insert new records, not change existing ones. C - PUT is not a keyword used in SQL for modifying records.

To Change Records in a Table, Use the UPDATE Keyword