Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command: LSNRCTL> STOP What happens 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 sessions are terminated and the active transactions are rolled back.
- DThe sessions are not allowed to perform any operations till the listener is started.