052-210(新增70题2018)

You executed the following command in the lsnrctl utility to stop the listener:

lsnrctl> STOP L1

What is the effect of this command if L1 is the only listener configured for your database?

A. It terminates all user sessions.

B. It prevents users from logging in to the database remotely.

C. It halts the server until all user transactions are completed.

D. The server hangs, so users will receive an error asking them to login again.

E. Connected users would get an error with the message "End of communication channel".

Answer: B

实验:

LSNRCTL> stop listener
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
The command completed successfully

--已经连接的会话不会中断

 

新登录用户报错