单选题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/o

第1题：

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.

第2题：

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

第3题：

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.

第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: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）

• A、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy
• B、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup
• C、  Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf
• D、Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails

第6题：

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

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）

• A、 The log sequence for the database will restart from 1.
• B、 The log sequence number will be written to the control file.
• C、 The log sequence number will be written to the datafile headers.
• D、 The log sequence number will be written to the initialization parameter file.

第15题：

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

第16题：

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

第17题：

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

• A、 Use the CHANGE_PASSWORD command of the Listener control utility.
• B、 Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.
• C、 Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.
• D、 Manually modify the listener.ora file to include the password for the listener and restart the listener.

第18题：

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、START
• B、RELOAD
• C、RESTART
• D、REFRESH
• E、START L1
• F、RELOAD L1
• G、RESTART L1
• H、REFRESH L1

第19题：

第20题：

第21题：

第22题：

第23题：