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

Question

Quizplus · Accepted Answer

An update query would be used to change the manager's name from "Jones" to "Ames" for all selected records. The other query types listed (select with self join, is null, append) are not relevant to this task.

What Type of Query Should You Create If You Want