Q
What does PRAGMA AUTONOMOUS_TRANSACTION do in PL/SQL?
-
A
Disables all locks
-
B
Lets a block run its own independent transaction that commits separately
-
C
Turns off logging
-
D
Rolls back the main transaction
Correct Answer:
B. Lets a block run its own independent transaction that commits separately
Explanation:
It is commonly used for audit logging that must persist even if the main transaction rolls back.
