Multiple choice technology databases

AUTONOMUS_TRANSACTION is a

  1. Programming technique

  2. Automatically used in all prpgramme

  3. PL/SQL compiler directive

  4. All of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

AUTONOMOUS_TRANSACTION is a pragma (compiler directive) in PL/SQL that marks a routine as an autonomous transaction. This allows the routine to execute independently of the main transaction - it can commit or rollback without affecting the parent transaction's state. It's a PRAGMA directive, not a programming technique or automatic feature.

Keep practicing — related questions