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.

Computer Science & Information Technology

You might also like to view...

Videos can be embedded in a blog from all of these sources EXCEPT ________

A) a smartphone B) YouTube C) a webcam D) a TV

Computer Science & Information Technology

Critical Thinking QuestionsCase 8-1Because users interact with sites on a variety of user agents, you, as a Web site designer, need a way to determine some parameters of the device that your site will be viewed on or output to so that you can customize pages for display on or output to that device and create responsive sites. Which of the following do you know is the scanning method of a TV display, and optimally progressive or interface?

A. grid B. resolution C. scan D. monochrome

Computer Science & Information Technology

The Unfreeze command locks columns and rows into place

Indicate whether the statement is true or false

Computer Science & Information Technology

A(n) ____________________ is a symbol that is designed to help customers remember a business and its products.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology