单选题Consider the following command：  Backup database plus archivelog delete input；  How many backup sets would be created by this command if the following were true：（）  Control-file a NN uto backups were enabled.  NN The size of backup sets was not restric

第1题：

Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’；   Which two statements are true regarding the backup created using this command？（）

• A、 The copy of the datafile created is stored in the RMAN repository.
• B、 The copy of the datafile created can be viewed using the LIST BACKUP command.
• C、 The copy of the datafile created using this COPY command can be placed only on the disk.
• D、 The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
• E、 The copy of the datafile created can be used for recovering the database using the user-managed recovery method.

第2题：

You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

• A、Corrupted blocks, if any, are repaired.
• B、Checks are performed for physical corruptions.
• C、Checks are performed for logical corruptions.
• D、Checks are performed to confirm whether all database files exist in correct locations
• E、Backup sets containing both data files and archive logs are created.

第3题：

The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command：   RMAN>CONFIGURE MAXSETSIZE 10MB；     What will be the impact of the above setting？（）

• A、 While performing the backup of the datafile，data1.dbf，one backup set is created.
• B、 While performing the backup of the datafile，data1.dbf，two backup sets are created.
• C、 While performing the backup of the datafile，data1.dbf，three backup sets are created.
• D、 While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.

第4题：

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN> RUN 2> { 3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4> BACKUP DATABASE; 5> } Which statement is true about the outcome?（）

• A、Only one channel is allocated and the backup is created in the flash recovery area
• B、Only one channel is allocated and the backup is created in the destination specified for channel 1
• C、Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
• D、Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

第5题：

You perform a backup using the following BACKUP command：   RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE；   Which statement is true of this command？（）  

• A、 A different procedure is required to restore a database from compressed backups
• B、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.
• C、 Using this command to create backups minimizes the bandwidth consumed
• D、 Using this command to create backups improves the performance of the backup process

第6题：

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

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Weekly backups of the system are done on Sundays， and daily backups are done the rest of the week.  Which of following backup methods were used if the system crashes on Friday and only requires two backup sets to recover the system？（）

• A、 Incremental and snapshot
• B、 Full and differential
• C、 Full and incremental
• D、 Differential and incremental

第14题：

You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）

• A、A different procedure is required to restore a database from compressed backups 
• B、The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies. 
• C、Using this command to create backups minimizes the bandwidth consumed.
• D、Using this command to create backups improves the performance of the backup process 

第15题：

You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）

• A、 The command generates an error.
• B、 The command backs up the tablespace and creates a backup set of size 200 MB
• C、 The command backs up the tablespace and creates two backup sets of size 100 MB each.
• D、 The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

第16题：

What is the purpose of the recover command？（） 

• A、 Recover database datafiles from physical disk backup sets.
• B、 Recover required incremental backups from physical disk backup sets.
• C、 Recover required archived redo logs from physical disk backup sets.
• D、 Apply incremental backups to recover the database. 
• E、 Apply archived redo logs to recover the database.

第17题：

Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）  

• A、 backup database
• B、 backup database and archivelogs
• C、 backup database plus archivelogs
• D、 backup database plus archivelog delete input
• E、 backup database and archivelog delete input

第18题：

Consider the following command：  Backup database plus archivelog delete input；  How many backup sets would be created by this command if the following were true：（）  Control-file a NN uto backups were enabled.  NN The size of backup sets was not restricted.  NN One channel was allocated.  

• A、 1
• B、 2
• C、 3
• D、 4
• E、 5

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：