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 f

第1题：

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

第2题：

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

第3题：

You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database. 

• A、a， b， f， g
• B、c， f， g
• C、a， d， f， g
• D、a， f， g
• E、a， e， g

第4题：

You work as a database administrator for Supportcenter.cn. Your listener process， L1， is currently listening to three databases： CertK INDB04， SupportCenter DB05 and SupportCenter DB06. Using Database Configuration Assistant （DBCA） you create one more database， SupportCenter DB07， and enable dynamic registration. Which two commands of Listener Control Utility （lsnrct1） would you use to determine whether the dynamic registration occurred for the database， SupportCenter DB07， with the L1 listener process？（）

• A、SHOW L1
• B、SPAWN L1
• C、STATUS L1
• D、SERVICES L1
• E、STATUS LISTENER
• F、SERVICES LISTENER
• G、SHOWcurrent_listener

第5题：

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

第6题：

You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）

• A、Start the instance and open the database， instance recovery automatically recoverscontrol files
• B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
• C、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）
• D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
• E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

第7题：

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.

第8题：

You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

• A、You must have started the database instance in restricted mode.
• B、You must have started the database instance inNORMALmode.
• C、You must have started the database instance with server parameter file.
• D、You must have started the database instance but must not have mounted.
• E、You must have started the database instance but must not have opened.

第9题：

You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）

• A、Start the instance and open the database, instance recovery automatically recovers control files 
• B、Create a file based on the contents of the trace file and save it to the control file locations and start the database 
• C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 
• D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 
• E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

第10题：

You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

• A、 You will need to open the database with the resetlogs command.
• B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
• C、 You will use the resetlogs version of the create controlfile command.
• D、 You will use the noresetlogs version of the create controlfile command.
• E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command