Your database is open and the LISTENER listener is running. 

第1题：

You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）

• A、It gets it from the parameter file.
• B、The listener prompts for details on startup.
• C、The listener gathers information from the control file.
• D、The instance automatically registers with the default listener.
• E、The listener gets this information through thelistener.orafile.

第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 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？（）

• A、 Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.
• B、 Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.
• C、 Issue the SERVICES command at the LSNRCTL> prompt.
• D、 Issue the STATUS command at the LSNRCTL> prompt.

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

第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题：

Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listener， database， and the configuration of the application. How would you avoid this scenario？（）

• A、lock the listener
• B、hide the listener
• C、create multiple listeners
• D、run listener on a remote client
• E、set a password for the listener
• F、store listener.ora in a non-default location