ITPub博客

（602）On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am.Which option must you use to check whether a flashback operation can recover the database to the specified time?A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE...

（601）You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager(RMAN).Which two are the prerequisites to perform this operation?(Choose two)A. You must configure block change tracking fileB. You must have first level 1 backups...

（600）Which of the following statements are true about the BACKUP command?(Choose all that apply.)A. The BACKUP command can not be used to make image copies of a datafile.B. The BACKUP command can improve performance by multiplexing backup files.C. The BACKUP can take advantage of the bl...

（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）