Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command: 1snrctl > STOP What happens to the sessions that are presently connec

The correct answer is B. They are not affected and continue to function normally.. 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.

Configuring the Oracle Network Environment

Question

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:

1snrctl > STOP What happens to the sessions that are presently connected to the database Instance?

Options

AThey are able to perform only queries.
BThey are not affected and continue to function normally.
CThey are terminated and the active transactions are rolled back.
DThey are not allowed to perform any operations until the listener LISTENER is started.

How the community answered

(28 responses)

A
4% (1)
B
79% (22)
C
7% (2)
D
11% (3)

Explanation

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.

Topics

#Oracle Listener#Database Connectivity#Network Configuration

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice