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…

Non-privileged active transactions are prevented from issuing COMMIT or ROLLBACK statements once RESTRICTED SESSION is enabled, as their operations are terminated.

When RESTRICTED SESSION is enabled, non-privileged active sessions are effectively suspended, rendering them unable to initiate any new statements; existing active transactions will find subsequent operations blocked.

Non-privileged active sessions cannot continue to issue DML statements after RESTRICTED SESSION is enabled, due to their suspension and termination.

For non-privileged users with active transactions when RESTRICTED SESSION is enabled, these active transactions are automatically rolled back by the database system.

Non-privileged active sessions cannot continue to issue queries once RESTRICTED SESSION is enabled, as their activities are halted.

Active transactions from non-privileged sessions are immediately terminated upon enabling RESTRICTED SESSION, ceasing their operations without completion.