Which of the following queries modifies fields not records? A. Append B. Delete C. Make-Table D. Update

The correct answer is D. Update.

A. Append adds new records to a table.
B. Delete removes records from a table.
C. Make-Table creates a new table.
D. Update modifies fields in existing records.

For example, the following SQL query updates the “Name” field of all records in the “Customers” table:

UPDATE Customers
SET Name = 'John Doe'
WHERE CustomerID = 1;

This query will update the “Name” field of all