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.

Computer Science & Information Technology

You might also like to view...

CommView is an example of which of the following?

a. Key logger b. Packet sniffer c. Virus d. Tool for industrial espionage

Computer Science & Information Technology

____ limit search results to just those pages with a specific Web page title, URL, text, or top-level domain.

A. Keyword searches B. Directory searches C. Field searches D. Phrase searches

Computer Science & Information Technology