Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task

第1题：

第2题：

You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  

• A、 run { open script backup_database； run script backup_database }
• B、 run { engage script backup_database； }
• C、 run { run script backup_database； }
• D、 Run { execute script backup_database； }
• E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

第3题：

You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

• A、Mount the database
• B、Open the database in NORMAL mode
• C、Open the database in RESTRICTED mode
• D、Open the database with the RESETLOGS option

第4题：

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.  What would be your next step to improve performance？ （）

• A、Run the SQL Access Advisor.
• B、Run the Memory Advisor for the sga.
• C、Run the Memory Advisor for the pga.
• D、Run the Memory Advisor for the shared pool.
• E、Run the Memory Advisor for the buffer cache.

第5题：

You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）

• A、 Window
• B、 Program
• C、 Job class
• D、 Window group

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

A staging server is critical for an administrator to test updates without introducing risk into a production environment.  Which of the following steps should an administrator take to test on a staging server？（）

• A、Create and Configure a WebSphere Commerce Instance on the staging server
• B、Run the Stage Copy Utility to copy production server data into the staging server.
• C、Run the Stage Propagate Utility to propagate the staging server with production server data 
• D、Create and configure a Staging database

第14题：

You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.   Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）

• A、 0
• B、 1
• C、 NONE
• D、 DEFAULT

第15题：

Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.  What would be your next step to improve performance（）

• A、Run the SQL Access Advisor.
• B、Run the Memory Advisor for the sga
• C、Run the Memory Advisor for the pga.
• D、Run the Memory Advisor for the shared pool.
• E、Run the Memory Advisor for the buffer cache

第16题：

Your production database uses an Automatic Storage Management （ASM） instance to manage its files.  You want to add a new disk group to the ASM instance to manage the increased data load.  What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

• A、mount the new disk group in the ASM instance
• B、restart the ASM instance and the production database instance
• C、register the new disk groups in the production database instance
• D、restart the ASM instance without restarting the production database instance
• E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：