Asked by Alexia Hutton on May 07, 2024
Verified
Which action query would you use if you wanted to add records from one table to a backup table?
A) Append query
B) Delete query
C) Backup query
D) Update query
Append Query
A database query that adds records from one or more sources to the end of a table.
Delete Query
A command or function in database management used to remove data or records from a table.
Backup Query
A request or operation to create a copy of data from a database to a secured place, intended to restore the original in case of data loss.
- Identify and enact various kinds of action queries, like Append, Delete, Update, and Make-Table.
Verified Answer
ZK
Zybrea KnightMay 12, 2024
Final Answer :
A
Explanation :
An append query is used to add records from one table to another. In this case, the backup table is the destination table and the original table is the source table. Therefore, an append query would be the best choice to transfer the records.
Learning Objectives
- Identify and enact various kinds of action queries, like Append, Delete, Update, and Make-Table.