The ____ parameter for the SET TRANSACTION forces all queries to see a snapshot of data prior to the start of a transaction,regardless of how many DML statements are within a transaction.
A) READ ONLY
B) ISOLATION LEVEL READ COMMITTED
C) USE ROLLBACK SEGMENT
D) READ WRITE

Question

Quizplus · Accepted Answer

The READ ONLY parameter for the SET TRANSACTION statement ensures that all queries within a transaction see a snapshot of the data as it existed at the start of the transaction, regardless of how many DML statements are executed within the transaction. This helps ensure consistent and predictable results during concurrent access to the database. The other options are not relevant to enforcing a snapshot of data.

The ____ Parameter for the SET TRANSACTION Forces All Queries