一抹曦阳-Oracle

661.View the Exhibit and examine the output. You execute the following RMAN command to perform thebackup operation:RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8;BACKUP DATABA

663.Which options would you consider while configuring a flash recovery area (fast recovery area in 11gRelease 2) for your production database that is running in ARCHIVELOG mode? (Choose all that

138.You are working on the APPDB database as a DB A. The database has a default Flashback DataArchive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1:DRO

389.The _______ writes the Flashback Database logs in the flash recovery area.A. FLSHB. FLDBC. RVWRD. RVRWE. FBDAAnswer: C 答案解析：RVWRRecovery Writer ProcessWrite

552.Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backupmode?A. alter tablespace DAVE_TBS backup mode;B. alter tablespace DAVE_TBS start backup;C. alt

549.Which is the correct command to put the database in ARCHIVELOG mode?A. alter database archivelogB. alter system enable archivelog modeC. alter database enable archiveD. alter database arch

548.What are the different logging modes available in Oracle Database 11g? (Choose two.)A. NOLOG modeB. NOARCHIVELOG modeC. LOGGING modeD. HOTDATABASE modeE. ARCHIVELOG modeAnswer: BE  

622.You need to maintain a record of all transactions on some tables for at least three years.Automatic undo management is enabled for the database.What must you do accomplish this task?A. Enabl

591.Which type of backup must be performed first with an incremental backup?A. Level 1B. Level 0C. Level 2D. Level 3Answer: B  RMAN can create multilevel incremental backups. Each incr

551.Which command will result in a trace file being created with the create controlfile command containedin it?A. alter database backup controlfile;B. alter database backup controlfile to trac

679.Which mode of database shutdown requires an instance recovery at the time of the next databasestartup?A.ABORTB.NORMALC.IMMEDIATED.TRANSACTIONALAnswer: A  答案解析： The possible

234.Which type of backup contains only the blocks that have changed since the last level 0 incrementalbackup?A. a cumulative level 1 backupB. a differential level 1 backupC. a full backupD

595.Which dynamic view displays the status of block-change tracking?A. V$BLOCK_CHANGEB. V$BLOCK_CHANGE_TRACKINGC. V$BLOCKCHANGED. V$BLOCK_TRACKINGAnswer: B 答案解析：V$BLOCK_CHANGE_TRACKING

147.You installed Oracle Database 11g afresh. Which statements are true regarding the default auditsettings in this database? (Choose all that apply.)A. The audit trail is stored in an operating

584.How is block-change tracking enabled?A. With alter database enable block change trackingB. With alter system enable block change trackingC. With an init.ora parameter changeD. With an spfi

78.You enable block change tracking. You issue the following command:BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you issue the following command:BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATAB

79.You executed the following command:RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';Which statement regarding the above command is correct?A. The '/u01/app/oracle/ora

47.You issue the following command on the RMAN prompt.REPORT NEED BACKUP DAYS 5;Which statement is true about executing this command?A. It will display a list of files that need incremental back

349.What is the result of this command? RMAN> Report need backup days 3;A. Lists all datafiles created in the last three days that are not backed up.B. Lists all datafiles not recoverable based on

190.You have control-file autobackups enabled. When starting your database from SQL*Plus, you receivethe following error message:SQL> startup ORA-01078: failure in processing system parameters L

10.Consider the following scenario for your database:-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The mostrecent backup to disk for the TOOLS tablespace

360.When performing a full database disaster recovery with RMAN, in what order would you executethese steps?A. Restore the control file from autobackups.B. Run the RMAN restore and recover com

152.You are performing incomplete recovery using RMAN. You execute the following RUN block:RUN{SET UNTIL SCN 1107600;RESTORE DATABASE;RECOVER DATABASE;}Which statement is true about the

272.You issue the following RMAN command to set a retention policy on a database:The safer , easier way to help you pass any IT exams.78 / 181RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

315.Which commands are used for RMAN database recovery? (Choose all that apply.)A. restoreB. repairC. copyD. recoverE. replaceAnswer: AD 答案解析：参考：使用RMAN RESTORE和RECOVER命令：http://blog.

286.The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo logfiles are stored on three locations. The Flash Recovery Area is one of the locations. The details are g

676.Which command creates an image copy?A. backup as copyB. backup copyC. copy as backupD. copy backAnswer: A 答案解析：image copyA bit-for-bit copy of a single data file, archived redo

667.What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?A. An upper limit on how far you can flash back the database, depending on the information in the redologsB. An upper limit

660.You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVELOG mode.The following steps must be perfo

184.Which RMAN backup command is used to create the block-change tracking file?A. alter database create block change tracking fileB. alter database enable block change fileC. alter database enab

593.Given the following steps, which would be the correct order to create a backup of an Oracle databasein NOARCHIVELOG mode?A. shutdown immediate from RMANB. Log into RMANC. startup mount f

268.You are using Recovery Manager (RMAN) for backup and recovery operations with a recoverycatalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM,you w

671.Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?A. Provid

302.You issue the following command:RMAN>CONFIGURE BACKUP OPTIMIZATION ON;What is the result of this command on your backups?A. An incremental backup strategy will be used automatically.B. Rea

504.View the Exhibit to examine the error during the database startup. You open an RMAN session for thedatabase instance. To repair the failure, you executed the following as the first command in

598.The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value?(Choose all that apply.)A. The initialization parameter should be set to 0 when the RMAN repository is

654.You are using Recovery Manager (RMAN) with a recovery catalog to back up your productiondatabase. The backups and the archived redo log files are copied to a tape drive on a daily basis.Be

89.You are using recovery Manager (RMAN) with a recovery catalog to backup up your productiondatabase. The backups and the archived redo log files are copied to a tape drive on a daily basis. The

346.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 operationsFile Type of Back

316.Given a complete loss of your database, in what order would you need to perform the followingRMAN operations to restore it?A. restore controlfileB. restore databaseC. restore spfileD.