单选题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（）AThe sessions are able to perform only queries.BThe sessions are not affected and continue to function normally.CThe sessions are terminated and the active transactions are rolled back.DThe sessions are not allowed to perform any operations till the listener is started
单选题
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（）
A
The sessions are able to perform only queries.
B
The sessions are not affected and continue to function normally.
C
The sessions are terminated and the active transactions are rolled back.
D
The sessions are not allowed to perform any operations till the listener is started
参考解析
解析：
暂无解析
相关考题：
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?() A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl >STOPWhat happens to the sessions that are presently connected to the database Instance?（）A. They are able to perform only queries.B. They are not affected and continue to function normally.C. They are terminated and the active transactions are rolled back.D. They are not allowed to perform any operations until the listener LISTENER is started
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".
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？（）A、The sessions are able to perform only queries.B、The sessions are not affected and continue to function normally.C、The active transactions are rolled back and the sessions get terminated.D、The sessions are not allowed to perform any operations till the listener is started.
our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）A、Oracle Net ManagerB、Listener Control utilityC、Database Configuration AssistantD、Oracle Net Configuration Assistant
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（）A、The sessions are able to perform only queries.B、The sessions are not affected and continue to function normally.C、The sessions are terminated and the active transactions are rolled back.D、The sessions are not allowed to perform any operations till the listener is started
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？（）A、 by using the STATUS command of the Listener control utilityB、 by using the STATUS L1 command of the Listener control utilityC、 by using the SHOW RULES command of the Listener control utilityD、 by using the SET PASSWORD command of the Listener control utilityE、 by searching for the PASSWORD_LISTENER entry in the listener.ora file
You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）A、More than one database is to be registered with the listener.B、The users will connect the database by using the host naming method.C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.D、The database that is to be registered with the listener is configured in shared server mode.E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL CONNECT scott/tiger@orcl What could be the reason for this?（）A、The listener is not running on the database node.B、The TNS_ADMIN environment variable is set to the wrong value.C、The orcl.oracle.com database service is not registered with the listener.D、The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E、The listener is running on a different port.
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（）A、The sessions are able to perform only queries.B、The sessions are not affected and continue to function normally.C、The sessions are terminated and the active transactions are rolled back.D、The sessions are not allowed to perform any operations till the listener is started.
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）A、Oracle Net ManagerB、Listener Control utilityC、Database Configuration AssistantD、Oracle Net Configuration Assistant
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A、 Oracle Net ManagerB、 Listener Control utilityC、 Database Configuration AssistantD、 Oracle Net Configuration Assistant
You issue these LSNRCTL commands： LSNRCTL SET CURRENT_LISTENER listener01 LSNRCTL START listener02 What is the result of issuing these commands？（）A、A listener named LISTENER is started.B、A listener named LISTENER01 is started.C、A listener named LISTENER02 is started.D、The START command fails and no listener is started.
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？（）A、STARTB、RELOADC、RESTARTD、REFRESHE、START L1F、RELOAD L1G、RESTART L1H、REFRESH L1
单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A Oracle Net ManagerB Listener Control utilityC Database Configuration AssistantD Oracle Net Configuration Assistant
单选题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（）AThe sessions are able to perform only queries.BThe sessions are not affected and continue to function normally.CThe sessions are terminated and the active transactions are rolled back.DThe sessions are not allowed to perform any operations till the listener is started
单选题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？（）AThe sessions are able to perform only queries.BThe sessions are not affected and continue to function normally.CThe active transactions are rolled back and the sessions get terminated.DThe sessions are not allowed to perform any operations till the listener is started.
单选题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（）AThe sessions are able to perform only queries.BThe sessions are not affected and continue to function normally.CThe sessions are terminated and the active transactions are rolled back.DThe sessions are not allowed to perform any operations till the listener is started.
单选题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？（）ASTARTBRELOADCRESTARTDREFRESHESTART L1FRELOAD L1GRESTART L1HREFRESH L1
单选题Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）AOracle Net ManagerBListener Control utilityCDatabase Configuration AssistantDOracle Net Configuration Assistant
单选题You issue these LSNRCTL commands： LSNRCTL SET CURRENT_LISTENER listener01 LSNRCTL START listener02 What is the result of issuing these commands？（）AA listener named LISTENER is started.BA listener named LISTENER01 is started.CA listener named LISTENER02 is started.DThe START command fails and no listener is started.
单选题You were recently hired by an organization 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？（）Aby using the STATUS command of the Listener control utilityBby using the STATUS L1 command of the Listener control utilityCby using the SHOW RULES command of the Listener control utilityDby using the SET PASSWORD command of the Listener control utilityEby searching for the PASSWORD_LISTENER entry in the listener.ora file
单选题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？（）AIt terminates all user sessions.BIt prevents users from logging in to the database remotely.CIt halts the server until all user transactions are completed.DThe server hangs， so users will receive an error asking them to login again.EConnected users would get an error with the message End of communication channel.
多选题You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）AMore than one database is to be registered with the listener.BThe users will connect the database by using the host naming method.CThe Oracle Enterprise Manager is to be used to monitor an Oracle9i database.DThe database that is to be registered with the listener is configured in shared server mode.EThe listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
单选题our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）AOracle Net ManagerBListener Control utilityCDatabase Configuration AssistantDOracle Net Configuration Assistant
单选题The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL CONNECT scott/tiger@orcl What could be the reason for this?（）AThe listener is not running on the database node.BThe TNS_ADMIN environment variable is set to the wrong value.CThe orcl.oracle.com database service is not registered with the listener.DThe DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.EThe listener is running on a different port.
单选题Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl STOPWhat happens to the sessions that are presently connected to the database Instance?（）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