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

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

If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）  

• A、 Recover the online redo log from backup.
• B、 Delete and re-create the log file.
• C、 Use the alter database clear logfile command to clear the log file.
• D、 Shut down the database and restart it.
• E、 Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.

第3题：

You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

• A、 The DBWn process writes to the datafile.
• B、 Changes in the background process are recorded.
• C、 The log file is updated with the current SCN number.
• D、 The System Change Number （SCN） is recorded in the control file.
• E、 The changes to the listener configuration in the listener.ora file are recorded.

第4题：

You manually create an additional listener process，L1，for databases PROD，  PAYDB and FINDB. While starting up the listener process，you get the following error message： LSNRCTL> start l1  Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr： please wait...  TNSLSNR for Linux： Version 10.1.0.2.0 - Production  System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on： （ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899））  TNS-12542： TNS：address already in use TNS-12560：  TNS：protocol adapter error TNS-00512： Address already in use  Linux Error： 98： Address already in use  Listener failed to start. See the error message（s） above...  What action would you take to overcome this error without disrupting any existing database communications？（）

• A、stop and restart the listener process
• B、set the TNS_ADMIN environmental variable
• C、stop all running listener processes and restart the listener process
• D、change the port number to an unused port number and restart the listener process
• E、change the IP address to host machine name in the LISTENER.ORA file and restart the listener process

第5题：

You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）

• A、Image of the control file
• B、Location of the control file
• C、Contents of the control file in text format
• D、SQL command to re-create the database
• E、SQL command to re-create the control file
• F、Contents of the control file in binary format

第6题：

You have just run this syntax to start the listener from the Listener Control utility：   LSNRCTL>START   Starting /mstgelai/oracle/bin/tnslsnr： please wait…  System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log  Listening on： （DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521））） Connecting to…  The command completed successfully   What is the name of the Listener you started？（）

• A、TNSLSNR
• B、LISTENER
• C、LOCAL_LISTENER
• D、DEFAULT_LSRN

第7题：

A developer wants a web application to be notified when the application is about to be shut down. Which two actions are necessary to accomplish this goal？（）

• A、Include a listener directive in a JSP page
• B、configure a listener in the TLD file using the  element
• C、Include a  element in the web application deployment descriptor
• D、configure a listener in the application deployment descriptor， using the  element
• E、Include a class implementing ServletContextListener as part of the web application deploymen

第8题：

Which two statements are true regarding trace options on Junos devices?（）

• A、You can see the contents of the log file by entering the show log <filename> command
• B、Trace options will send information to your screen automatically
• C、Trace options are limited to one protocol at a time
• D、The file name and set of flags may be specified when enabling trace options

第9题：

You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup， you need the database ID （DBID）. In which two sources would you find the DBID？ （）

• A、 the alert log file
• B、 the server parameter file
• C、 the formatted name of a control file autobackup
• D、 an RMAN session log file
• E、 the trace file

第10题：

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 utility
• B、 by using the STATUS L1 command of the Listener control utility
• C、 by using the SHOW RULES command of the Listener control utility
• D、 by using the SET PASSWORD command of the Listener control utility
• E、 by searching for the PASSWORD_LISTENER entry in the listener.ora file