Oracle Database 12c: Installation and Administration — Question 237

Your database is open in read/write mode and multiple users are connected to the database instance.
You execute the following command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
What would be the effect on current sessions?

Answer options

• A. They are not terminated but may only issue queries.
• B. They are not affected.
• C. They are terminated immediately.
• D. They are terminated after completing the transaction.

Correct answer: B

Explanation

The correct answer is B because executing 'ALTER SYSTEM ENABLE RESTRICTED SESSION' does not impact existing sessions; they remain unaffected and can continue their operations. The other options incorrectly suggest that sessions would be limited to queries, terminated immediately, or terminated after transactions, which are not the effects of this command.