Asked by Jayden Williams on Jun 18, 2024
Verified
To remove retired employees from an Employee table, create a(n) _____ query.
A) Delete
B) Parameter
C) History
D) Update
Delete Query
A command or instruction in a database management system to remove records from a database based on specified criteria.
Parameter Query
A type of database query that requires the user to provide one or more parameters, or criteria, before the query is executed to retrieve specific data.
History Query
A search or inquiry into the recorded events or actions, often in a database or a web browser, to retrieve or review past information.
- Distinguish and employ diverse action queries such as Append, Delete, Update, and Make-Table.
- Comprehend the method of deleting or inserting records into an existing table through the use of Delete and Append queries.
Verified Answer
MC
Michael CrowseyJun 22, 2024
Final Answer :
A
Explanation :
The Delete query is used for removing data from a table, in this case, removing retired employees from the Employee table.
Learning Objectives
- Distinguish and employ diverse action queries such as Append, Delete, Update, and Make-Table.
- Comprehend the method of deleting or inserting records into an existing table through the use of Delete and Append queries.