Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:1snrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?The listener is used when the connection is established. The immediate impact of stopping the listener will be that no new session can be established from a remote host. Existing sessions are not compromised.
Question:
What happens to the sessions that are presently connected to the database Instance?
Options:
They are able to perform only queries.
They are not affected and continue to function normally.
They are terminated and the active transactions are rolled back.
They are not allowed to perform any operations until the listener LISTENER is started.
Correct Answer
The Correct Answer for this Question is
They are not affected and continue to function normally.
