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? (Choose the best answer)
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.
Explanation:
b
B
Already Connected users can perform their DML/DDL activities , but no new session can be created for the users
B: Specify ENABLE to allow only users with RESTRICTED SESSION system privilege to log on to Oracle Database. Existing sessions are not terminated.