ITPub博客

（599）Given the following steps,which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups enabled?a. backup archivelog all;b. backup database all;c. backup controlfile;d. backup archivelog,database,controlfile delete 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 being used.B. The initialization parameter should be set to greater than 0 with the RMAN reposit...

（597）What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?A. CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIAB. CONFIGURE DEFAULT DEVICE TYPE TO TAPEC. CONFIGURE DEFAULT DEVICE TYPE TO SBTD. CONFIGURE DEFAULT DEVICE TYPE TO SBT_T...

（596）What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?A. Channel failoverB. Restartable backupsC. Rescheduable backupsD. Automatic backup recoveryE. Channel rec...

（595）Which dynamic view displays the status of block-change tracking?A. V$BLOCK_CHANGEB. V$BLOCK_CHANGE_TRACKINGC. V$BLOCKCHANGED. V$BLOCK_TRACKING答案：（B）

（594）Which of the following most closely represents an image copy?A. Unix cp command of a fileB. Bit-by-bit copy of a fileC. Windows COPY command of a fileD. All of the above答案：（D）

（593）Given the following steps,which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?a. shutdown immediate from RMANb. Log into RMANc. startup mount from RMANd. backup databasee. alter database openf. backup database plus archivelog d...

（592）Which backup option defines a user-defined name for a backup?A. FORMATB. NAMEC. TAGD. FORMAT U%答案：（C）解析：FORMAT：指明备份文件的路径和文件名%U：一个唯一的文件名，代表%u_%p_%cTag：通过tag可以唯一标示备份集，标示方法可自定义...

(591)Which type of backup must be performed first with an incremental backup?A. Level 1B. Level 0C. Level 2D. Level 3答案：（B）

（590）Which of the following best describes a full backup?A. All datafiles of a databaseB. All datafiles,archive logs,and control filesC. All datafiles and control filesD. All the used blocks in a datafile答案：（D）

（589）Which of the following best describes a full backup?A. All datafiles of a databaseB. All datafiles,archive logs,and control filesC. All datafiles and control filesD. All the used blocks in a datafile答案：（D）

（588）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 databaseB. backup database and archivelogsC. backup database plus archivelogsD. backup database plus archivelog delete inputE. backup...

（587）Compressed backups work with which of the following commands?A. copy as backupB. backup as copyC. backupD. copy答案：（C）

（586）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:1. Control-file auto backups were enabled.2. The size of backup sets was not restricted.3. One channel was allocated....

（585）What type of backup is stored in a proprietary RMAN format?A. Backup setB. Image copyC. Backup sectionD. Backup group答案：（A）

（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 spfile parameter change答案：（A）

(583)During recovery, you need to know if log sequence 11 is in the online redo logs,and if so,you need to know the names of the online redo logs so you can apply them during recovery.Which view or views would you use to determine this information?(Choose all that apply.)A. V$LOGFILEB...

（582）You are trying to recover your database. During the recovery process,you receive the following error:ORA-00279:change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1ORA-00289:suggestion:/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/...

（581）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 r...