Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command: LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance?()
- AThe sessions are able to perform only queries.
- BThe sessions are not affected and continue to function normally.
- CThe active transactions are rolled back and the sessions get terminated.
- DThe sessions are not allowed to perform any operations till the listener is started.