Asked by Darcey Borellini on Jul 05, 2024
Verified
Create a(n) _____ query to change the name of a supervisor in an Employee table.
A) Make-Table
B) Update
C) Self-Join
D) Target
Update Query
In database management, a query that modifies the values of existing records in a table according to specified criteria.
Make-Table Query
In databases, a query that creates a new table from data selected from one or more other tables.
Self-Join Query
A database query that joins a table to itself to aggregate or compare rows within the same table based on a set of criteria.
- Acquire the skill to amend data or configurations in tables utilizing Update queries.
Verified Answer
BL
Beatrice LingadJul 05, 2024
Final Answer :
B
Explanation :
The Update query is used to modify existing data in a table. In this case, we want to change the name of a supervisor in an Employee table. Therefore, an Update query is the best choice.
Learning Objectives
- Acquire the skill to amend data or configurations in tables utilizing Update queries.