多选题Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（）AThe command restores only th

第1题：

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（） 

• A、 The command restores only the missing control file.
• B、 The command restores all the control files.
• C、 The command fails because the database is running.
• D、 This is the correct way to address this problem.
• E、 This is not the correct way to address this problem.

第2题：

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

• A、The database is in mount state.
• B、One of the tablespaces is offline.
• C、One of the tablespaces is read only.
• D、The database operates in ARCHIEVELOG mode. 
• E、The database operates in NOARCHIEVELOG mode.

第3题：

第4题：

There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

• A、Only bring the tablespace back online.
• B、Only recover the tablespace and then bring the tablespace back online.
• C、Shut down the database， recover the data file and then start up the database.
• D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
• E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

第5题：

Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

• A、 redo logs
• B、 control file
• C、 temporary files of temporary tablespace
• D、 the latest backup of only the damaged data file
• E、 the latest backup of all the data files In the USERS tablespace

第6题：

You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）

• A、 a list of files that require a backup within three days
• B、 a list of files that have not been backed up for three days
• C、 a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
• D、 a list of files for which a backup has already been performed and may need a backup after three days

第7题：

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

• A、archival
• B、log writer
• C、database writer
• D、system monitor
• E、process monitor
• F、change tracking writer

第8题：

You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old  In which situation would you receive such an error？（）

• A、You performed rollback after commit.
• B、If a log switch occurs in your database.
• C、Thearchiverfails to generate an archived log file.
• D、Instance recovery fails to find one of the redo log files.
• E、A long-running query is unable to get read-consistent image.
• F、If you perform manual undo management operations in auto mode.

第9题：

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

第10题：

A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

• A、 backup database all
• B、 backup compressed database
• C、 backup as compressed backupset database
• D、 backup as compressed backup database plus archivelog all
• E、 backup as compressed backupset database plus compress archivelog all