单选题You are using Enterprise Manager to schedule backups for your database.  Which type of script wouldbe generated by the backup scheduler（）A XML scriptB PL/SQL scriptC Operating system scriptD Recovery Manager （RMAN） script

第1题：

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

• A、You must configure block change tracking file
• B、You must have first level 1 backups for RMAN to restore blocks
• C、You must ensure that the SALES database is mounted or open
• D、You must have full or level 0 backups for RMAN to restore blocks
• E、You must take the tools01.dbf data file offline before you start a block media recovery

第2题：

Using the reports server how would you force the orders report in the orders entry application to run every six hours?（）

• A、Schedule the report's execution in the queue manager. 
• B、Schedule the reports execution using the R30RQM command line with scheduled parameter. 
• C、Create a trigger in the application to execute the report every six hours. 
• D、You cannot schedule a reports execution.

第3题：

You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）

• A、It is a SQL script.
• B、It is a PL/SQL file.
• C、It is an operating system （OS） file.
• D、It is a Recovery Manager （RMAN） script

第4题：

You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based？（）

• A、 column sizes
• B、 column data types
• C、 PCTFREE
• D、 projected number of row
• E、 PCTUSED

第5题：

You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）

• A、You are backing up to tape and your tape device performs its own compression.
• B、You are making image copies, and you have not enabled tablespace compression.
• C、You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
• D、You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
• E、You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves  media costs and archival storage.

第6题：

You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）

• A、Schedule the full backups to run after the nightly index is rebuilt.
• B、Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.
• C、Schedule an additional transaction log backup to run after the nightly index is rebuilt.
• D、Schedule a marker to be added to the transaction log before the nightly index is rebuilt.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

• A、The DBMS_JOB package
• B、The BACKUP_JOB package
• C、The DBMS_BACKUP_RESTORE package
• D、The calendar tool in the Operating System （OS）
• E、The backup scheduler in Enterprise Manager （EM）
• F、The DBMS_BACKUP_SCHEDULER packager inline mode

第14题：

You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）

• A、the XML script
• B、the PL/SQL script
• C、the DBMS_SCHEDULER package
• D、Enterprise Manager to schedule the backup

第15题：

You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）

• A、Oracle Management Agent
• B、Enterprise Manager with Grid Control
• C、Enterprise Manager with Database Control
• D、Operating System Socket for incoming requests
• E、Real Application Cluster （RAC） with three instances
• F、Enterprise Manager with Generic Database Management

第16题：

You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

• A、 space allocated in the tablespace
• B、 space required for the bitmap index on a column of the table
• C、 space remaining in the tablespace after creating the table
• D、 estimated value of the PCTFREE storage parameter

第17题：

You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？（）

• A、SQL script
• B、PL/SQL script
• C、Operating System （OS） script
• D、Enterprise Manager （EM） script
• E、Recovery Manager （RMAN） script

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：