What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?

A) Update
B) Select with self join
C) Is Null
D) Append

Update

The process of modifying existing data or software to bring it to a newer state or version.

Manager's Name

A data field intended to store the name of a person who holds a managerial position within an organization.

Records

In databases, records refer to individual rows in a table, where each record represents a unique piece of data or entity.