Explain How Oracle Uses Transactions to Shield Users from Changes

Question

Examlex · Accepted Answer

The Answer is The purpose of transaction processing is to enable every user to see a consistent view of the database.To achieve this consistency,a user cannot view or update data values that are part of another user's uncommitted transactions because these uncommitted transactions,which are called pending transactions,might be rolled back.The Oracle DBMS implements transaction processing by locking data rows associated with pending transactions.When the DBMS locks a row,other users cannot view or modify the row.When the user commits the transaction,the DBMS releases the locks on the rows,and other users can view and update the rows again.

Explain How Oracle Uses Transactions to Shield Users from Changes

Essay

Correct Answer:
Verified

Explain How Oracle Uses Transactions to Shield Users from Changes

Essay

Correct Answer:VerifiedShow Answer

Correct Answer:
Verified