Asked by Donald Winters on Jul 03, 2024
Verified
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.
- Learn the purpose and functionality of different query types.
Verified Answer
PM
Paige MorganJul 08, 2024
Final Answer :
A
Explanation :
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.
Learning Objectives
- Learn the purpose and functionality of different query types.