单选题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 perfor

第1题：

第2题：

You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）

• A、It would attempt to start the default listener
• B、It would start the most recently created listener.
• C、It would display an error with a message asking for the listener name to be specified.
• D、It would show you a list of listeners and prompts for the listener name that you want to start.

第3题：

第4题：

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.

第5题：

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 Manager
• B、Listener Control utility
• C、Database Configuration Assistant
• D、Oracle Net Configuration Assistant

第6题：

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".

第7题：

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.

第8题：

第9题：

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

第10题：

You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command：   LSNRCTL>STATUS listener1   Which information will NOT be displayed when you issue the above command？（） 

• A、 whether the password is set in the listener or a file or not
• B、 the number of client connections the service handler has refused
• C、 the information will be displayed whether the instance can accept connections or not
• D、 the protocol addresses on which the listener is configured to listen