A listener named LISTENER is started.
A listener named LISTENER01 is started.
A listener named LISTENER02 is started.
The START command fails and no listener is started.
第1题:
Linux系统中,停止监听服务的命令是()
第2题:
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command: LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance?()
第3题:
You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process, named L1, has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task?()
第4题:
You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?()
第5题:
You issue these LSNRCTL commands: LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02 What is the result of issuing these commands?()
第6题:
You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process. Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?()
第7题:
The sessions are able to perform only queries.
The sessions are not affected and continue to function normally.
The sessions are terminated and the active transactions are rolled back.
The sessions are not allowed to perform any operations till the listener is started
第8题:
The sessions are able to perform only queries.
The sessions are not affected and continue to function normally.
The active transactions are rolled back and the sessions get terminated.
The sessions are not allowed to perform any operations till the listener is started.
第9题:
START
RELOAD
RESTART
REFRESH
START L1
RELOAD L1
RESTART L1
REFRESH L1
第10题:
A listener named LISTENER is started.
A listener named LISTENER01 is started.
A listener named LISTENER02 is started.
The START command fails and no listener is started.
第11题:
It terminates all user sessions.
It prevents users from logging in to the database remotely.
It halts the server until all user transactions are completed.
The server hangs, so users will receive an error asking them to login again.
Connected users would get an error with the message End of communication channel.
第12题:
Use the CHANGE_PASSWORD command of the Listener control utility.
Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.
Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.
Manually modify the listener.ora file to include the password for the listener and restart the listener.
第13题:
Linux系统中,查看监听服务状态的命令是()
第14题:
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command:LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance()
第15题:
The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file?()
第16题:
Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command: LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance()
第17题:
如何设置listener口令?()
第18题:
Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.
Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.
Issue the SERVICES command at the LSNRCTL> prompt.
Issue the STATUS command at the LSNRCTL> prompt.
第19题:
以Oracle用户运行lsnrctl命令
setlog_file
change_password
setpassword
save_config
第20题:
The sessions are able to perform only queries.
The sessions are not affected and continue to function normally.
The sessions are terminated and the active transactions are rolled back.
The sessions are not allowed to perform any operations till the listener is started.
第21题:
The sessions are able to perform only queries.
The sessions are not affected and continue to function normally.
The sessions are terminated and the active transactions are rolled back.
The sessions are not allowed to perform any operations till the listener is started
第22题:
by using the STATUS command of the Listener control utility
by using the STATUS L1 command of the Listener control utility
by using the SHOW RULES command of the Listener control utility
by using the SET PASSWORD command of the Listener control utility
by searching for the PASSWORD_LISTENER entry in the listener.ora file
第23题:
The listener process named L1 will disconnect the unauthorized users.
The listener process named L1 will be prevented from being started by unauthorized users.
The listener process named L1 will be prevented from being stopped by unauthorized users.
The listener process named L1 will be prevented from being reloaded by unauthorized users.
The listener process named L1 will be prevented from accepting connections from unauthorized users.
第24题:
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