What is the difference between an action query and a select query? When you are working with action queries, why is it important to create a backup of your database first?
What will be an ideal response?
A select query is used to display and manipulate data but not change it. An action query makes changes to records, or moves records from one table to another. Since there is no undo feature for an action query, the changes they make are permanent. In order to protect your data from mistakes while running action queries, it is a good idea to always create a backup database first, so if the action query does not work as anticipated, you have a backup to revert to.
You might also like to view...
Which operation is not supported in constant time by a double-ended queue (deque)?
a. Insertion at the front or rear item b. Access of the front or rear item c. Deletion of the front or rear item d. Access and deletion of the minimum item e. all of the above are supported
A(n) __________ risk is one that is higher than the risk appetite of the organization.
Fill in the blank(s) with the appropriate word(s).