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 making changes, additions, or corrections to software or data to bring it up to date.

Self Join

A type of SQL join where a table is joined to itself to extract information that is related within the same table.

Is Null

A term used in databases and programming to indicate that a data value does not exist or is missing.