The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command：   RMANCONFIGURE MAXSETSIZE 10MB；     What will be the impact of the above setting？（）A、 While performing the backup of the datafile，data1.dbf，one backu

第1题：

You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）

• A、 The log sequence for the database will restart from 1.
• B、 The log sequence number will be written to the control file.
• C、 The log sequence number will be written to the datafile headers.
• D、 The log sequence number will be written to the initialization parameter file.

第2题：

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

第3题：

第4题：

You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

• A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
• B、 When a structural change is made to the database， then a backup of the current control file is performed.
• C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
• D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

第5题：

While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

• A、configure the database to run in ARCHIVELOG mode
• B、configure the Flash Recovery Area to enable automatic database backup
• C、schedule the database backup using DBMS_JOB package after creating the database
• D、schedule the database backup using Recovery Manager （RMAN）commands after creating the database
• E、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

第6题：

The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）  

• A、 The block change tracking feature must be enabled.
• B、 OMF must be configured on your database.
• C、 The database must be in ARCHIVELOG mode.
• D、 A USERID must be supplied.

第7题：

You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；  Which statement is true about this command（）

• A、The command must be issued in MOUNT state.
• B、The command succeeds only if the data file is offline.
• C、The command must be issued when the database is in the archivelog mode.
• D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

第8题：

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.

第9题：

What is the impact of the results of the output of the following command？（）   RMAN> report unrecoverable database；  Report of files that need backup due to unrecoverable operations  File Type of Backup Required Name  4 full or incremental C:///ORACLE/ORADATA/ORCL/USERS01.DBF  

• A、 There are no backup sets with any backups of the users01.dbf datafile.
• B、 The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.
• C、 The users01.dbf datafile is corrupted.
• D、 The users01.dbf datafile backup exceeds the retention criteria.
• E、 The last backup of the users01.dbf datafile failed and must be rerun.

第10题：

You configured the default backup device type as disk for RMAN backups. In your database，because of business requirements，you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this？（）  

• A、 MAXSETSIZE TO 2
• B、 DEVICE TYPE DISK PARALLELISM 2
• C、 RETENTION POLICY TO REDUNDANCY 2
• D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2