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 records in the “Customers” table where the “CustomerID” is 1. The “Name” field of all other records in the “Customers” table will not be affected.