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?

Question

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?

Accepted Answer

B. They are not affected. The `ALTER SYSTEM ENABLE RESTRICTED SESSION` command is designed to prevent new user sessions from connecting to the database unless those users have been granted the `RESTRICTED SESSION` privilege. It specifically does not terminate or restrict any user sessions that are already established and active when the command is executed, allowing them to continue their operations normally.

Answer

A. They are not terminated but may only issue queries. Existing sessions are not restricted to only issuing queries; they continue to operate with their granted privileges.

Answer

C. They are terminated immediately. The command does not immediately terminate active sessions; it only influences subsequent connection attempts.

Answer

D. They are terminated after completing the transaction. Existing sessions are not terminated at all by this command, regardless of their transaction status.

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…

Question

Options

How the community answered

Why each option

Topics

Community Discussion