List and describe three types of problems that can result from uncontrolled access to the database.
What will be an ideal response?
Dirty read problems can occur when a transaction that is updating the database fails and the updated values are rolled back to their original state. If a concurrent process is reading the data, it may retrieve the values that were not ultimately committed to the database.
Lost update problems can occur if two processes attempt to update the same record concurrently and the updates of one process are overwritten by the second process.
Incorrect summary problems can occur if a transaction attempts to read and summarize column values while the data is in an inconsistent state due to a concurrent update process.
You might also like to view...
Because key control information is already in place, a __________ can bypass certain preliminary boot tasks, and that saves time.
a. re-boot b. warm boot c. secondary boot d. cold boot
________ is a program within Windows 10 that you can use to capture images of all or a portion of your computer screen
A) Snag It Tool B) Cortana C) Snipping Tool D) Freeze Screen Tool
A(n) ________ is used to perform calculations that add, subtract, divide, or multiply cell contents
A) argument B) variable C) function D) formula
Which of the following is NOT found on the Actions panel menu in the course of your explorations?
You work at the local university's historical archives. You have some particularly tedious work ahead of you, processing a series of newly scanned prints from a historical collection that need to be cleaned up, color-corrected, and all converted to the same color mode before they are placed into your archive's photo database. A colleague tells you that you should read up on actions in order to simplify some of the tasks ahead of you. a. commands to manage actions b. commands to set options c. commands to record actions on the History panel d. commands to load new sets of predefined actions