Oracle
1Z0-497 · Question #30
Your database is open and the listener is running. The DBA stops the listener by using the command: LSNRCTL> STOP What happens to the sessions that are currently connected to the database instance?
The correct answer is B. They are not affected and continue to function normally. See the full explanation below for the reasoning.
Question
Your database is open and the listener is running. The DBA stops the listener by using the command:
LSNRCTL> STOP What happens to the sessions that are currently connected to the database instance?
Options
- AThey can 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 till the listener is started.
How the community answered
(55 responses)- A15% (8)
- B75% (41)
- C4% (2)
- D7% (4)
Community Discussion
No community discussion yet for this question.