What is a potential disadvantage of running an update query?How can you recover from an error that occurs when running this type of query?

What will be an ideal response?


One potential disadvantage of running an update query is that records can be changed accidentally by executing it more than one time. A good strategy would be to protect your original data by backing up your database and keeping it in a secure storage location, in case data is changed inadvertently.

Computer Science & Information Technology

You might also like to view...

DES is an encryption standard

a. adopted by the NIST b. also known as the DEA c. sometimes used to secure financial transactions d. all of the above

Computer Science & Information Technology

Experiment with the Hello CGI example presesnted in Figures 9.10 and Figure 9.11.

a. Obtain the source files for the Hello CGI example presesnted in Figures 9.10 and Figure 9.11. b. Install hello.html on the web server: be sure to open its access to world-readable. c. Compile hello.c (with util.c for the query-string processing routines) to generate an executable Hello.cgi. (The command is%gcc hello.c util.c -o hello.cgi). Install hello.cgi on the web server: be sure to open its access to world-readable and world-executable. d. Open a browser and specify the URL for hello.html. When the page is displayed, press the button to submit the form and invoke hello.cgi. e. Summarize the experiment and report the result.

Computer Science & Information Technology

On a network, users with Read/Write permission can edit and delete files

Indicate whether the statement is true or false

Computer Science & Information Technology

A(n) ______ frame encloses all of the column headings for a record group.

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

Computer Science & Information Technology