Q
Which statement makes a transaction see a consistent snapshot and permits no DML?
-
A
SET TRANSACTION READ ONLY;
-
B
SET TRANSACTION SNAPSHOT;
-
C
ALTER SESSION FREEZE;
-
D
SET LOCK READ;
Correct Answer:
A. SET TRANSACTION READ ONLY;
Explanation:
A read-only transaction sees data as of its start time, useful for consistent reports.
