Which is not a valid way of backing up a control file？（）  

第1题：

You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What does the statement generate？（）

• A、A text copy of the control file.
• B、A binary copy of the control file.
• C、A file containing a SQL statement which will re-create the database.
• D、A file containing a SQL statement which will re-create the control file.

第2题：

When configuring the messaging system， which of the following are valid parameters for the file transport？ （）

• A、File Name
• B、Operating System
• C、Location
• D、Host
• E、Mode

第3题：

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）  

• A、 Restore and recover the datafile.
• B、 Restore and recover the tablespace.
• C、 Restore and recover the database.
• D、 Restore and recover the control file.
• E、 Restore and recover the parameter file.

第4题：

Which two statements regarding the control file and Recover Manager are true？ （）

• A、The control file can grow in size.
• B、The control file can store RMAN scripts.
• C、CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.
• D、The RMAN catalog can exist solely in the control file of the target database.

第5题：

You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

• A、Datafiles
• B、 Current control file
• C、 Server parameter file （spfile）
• D、 Password file

第6题：

In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command：  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically？ （）

• A、a tablespace is taken offline
• B、the database instance is restarted
• C、a new data file is added to an existing tablespace
• D、a successful backup is recorded in the RMAN repository
• E、the RMAN connection is disconnected from the target database

第7题：

You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）

• A、Image of the control file
• B、Location of the control file
• C、Contents of the control file in text format
• D、SQL command to re-create the database
• E、SQL command to re-create the control file
• F、Contents of the control file in binary format

第8题：

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.

第9题：

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

• A、Database Datafiles 
• B、Database Control Files 
• C、Online redo logs
• D、Archived redo logs 
• E、The database SPFILE 
• F、None of the above, all these files are backed up. 

第10题：

You performed a backup of the flash recovery area by using the following command for the first time： RMAN> BACKUP RECOVERY AREA;  Which files in the flash recovery area are backed up？（）

• A、flashback logs
• B、current control file
• C、control file autobackups
• D、incremental backup sets