Oracle Database 12c: Installation and Administration — Question 74

A database is open READ WRITE and the instance has multiple sessions some of which have active transactions.
You execute this command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
Which three are true about the active transactions? (Choose three.)

Answer options

• A. They may issue COMMIT or ROLLBACK statements
• B. They are suspended and unable to issue any statements
• C. They may continue to issue DML statements
• D. They are rolled back automatically
• E. They may continue to issue queries
• F. They are terminated immediately

Correct answer: A, C, E

Explanation

The correct answers A, C, and E are true because active transactions can still complete their DML operations and issue COMMIT or ROLLBACK commands. They are not suspended or terminated immediately, and queries can continue to run. Options B, D, and F are incorrect as they misrepresent the behavior of active transactions under restricted session conditions.