Oracle
1Z0-062 · Question #163
1Z0-062 Question #163: Real Exam Question with Answer & Explanation
The correct answer is C: The sessions are not affected and continue to function normally.. Once a client is connected to the database (ie the server-side process is forked or is using a shared server process), the listener isn’t required any further. You could even shutdown the listener (preventing new connections) without affecting existing connections.
Question
Your database is open and the listener LISTNENER is up. You issue the command: LSNRCTL> RELOAD What is the effect of reload on sessions that were originally established by listener?
Options
- AOnly sessions based on static listener registrations are disconnected.
- BExisting connections are not disconnected; however, they cannot perform any operations until the
- CThe sessions are not affected and continue to function normally.
- DAll the sessions are terminated and active transactions are rolled back.
Explanation
Once a client is connected to the database (ie the server-side process is forked or is using a shared server process), the listener isn’t required any further. You could even shutdown the listener (preventing new connections) without affecting existing connections.
Community Discussion
No community discussion yet for this question.