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 th

第1题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

• A、 control file
• B、 all datafiles
• C、 password file
• D、 online redo log file
• E、 archive redo log file
• F、 server parameter file
• G、 only the SYSTEM datafile

第2题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

• A、 online redo log files
• B、 alert log files
• C、 control file
• D、 datafiles associated with the SYSTEM tablespace

第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题：

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.

第5题：

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. 

第6题：

Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）

• A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
• B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
• C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
• D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

第7题：

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

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

• A、 when you change the name of a datafile
• B、 when you drop a table from the database
• C、 when you take an export of the database
• D、 when you back up the database using OS utilities
• E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
• F、 when you issue a BACKUP command from inside the RMAN run block

第15题：

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）

• A、Data files that belong to only the root container
• B、Data files that belong to the root container and all the pluggable databases (PDBs)
• C、Data files that belong to only the root container and PDB$SEED
• D、Data files that belong to the root container and all the PDBs excluding PDB$SEED

第16题：

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

• A、 Start the database in the MOUNT stage.
• B、 Back up the control file to trace.
• C、 Set the DBID
• D、 Issue the RECOVER DATABASE command.

第17题：

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

第18题：

Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS.  The database is still running.  Which answer properly describes the rder of the steps that you would use to recover from this error？（）   a. Shut down the database.  b. Take the users_01.dbf datafile offline with the alter database command.  c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database.  h. Bring the users_01.dbf datafile online with the alter database command. 

• A、a， c， f， g
• B、b， c， f， h
• C、a， b， c， f， g
• D、a， b， c， f， g， h
• E、b， c， f， e， g

第19题：

Given the script   create script db_backup_datafile_script  {backup datafile and 1， and2 plus archivelog delete input；} Run {execute script db_backup_datafile_script using 2；}   What is the result of running this command？（）  

• A、 The script will fail since you instructed RMAN to back up only one datafile rather than two
• B、 The script will successfully back up datafile 3 without error
• C、 The script will fail since it uses a substitution variable which is not supported
• D、 The execute script command will prompt for the value of and2 since it’s not included in the command
• E、 The script will fail because you cannot use the plus archivelog command when backing up

第20题：

第21题：

第22题：

第23题：