How is transaction control important in a shared environment?
What will be an ideal response?
When a user is in the middle of a transaction, he/she can review all DML statements’ results by using SELECT queries. After reviewing the results, the user can decide to roll back or commit. The user is getting results from database’s temporary storage area. The other users with privileges on the same table cannot view the results of the DML queries until the user commits the changes. Until the user commits all the changes, the rows with DML statements are locked. Other users cannot change the data in the locked rows. By committing, the user changes become permanent, all users can view the changes, locks are released, save points are removed, and other users can manipulate affected rows.
You might also like to view...
Social engineering is a complicated attack to learn and carry out.
Answer the following statement true (T) or false (F)
When setting up an email account, you need to know basic information such as the email address and signature. _________________________
Answer the following statement true (T) or false (F)
Management Information Systems (MIS) are valuable to modern companies because
A. New Information Systems always improve business processes B. Information Systems help businesses make more informed decisions C. We must collect as much data as possible D. None of the above
Common forms of mechanical locks include electric strike locks, which (usually) require people to announce themselves before being "buzzed" through a locked door. _________________________
Answer the following statement true (T) or false (F)