Oracle认证考试

Which three types of files can be automatically placed in the flash recovery area fast recovery area in 11g Release 2?()A、 Alert log fileB、 Archived redo log filesC、 Control file autobackupsD、 Server Parameter file (SPFILE)E、 Recovery Manager (RMAN) backu

题目

Which three types of files can be automatically placed in the flash recovery area fast recovery area in 11g Release 2?()

  • A、 Alert log file
  • B、 Archived redo log files
  • C、 Control file autobackups
  • D、 Server Parameter file (SPFILE)
  • E、 Recovery Manager (RMAN) backup piece
如果没有搜索结果,请直接 联系老师 获取答案。
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:Which statement is true regarding what this command accomplishes?()

A. All archived redo log files backed up at least twice to tape are deleted.

B. All archived redo log files backed up at least once to tape are eligible for deletion.

C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.


参考答案:D

第2题:

You configured the Flash Recovery Area (FRA) for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which twofiles are removed automatically if the space is required in the FRA as per the retention policy()

  • A、Flashback log files
  • B、Backups that have become obsolete
  • C、User managed backups of the data files and control files
  • D、Archived redo log files that have multiple copies in a different archive location and not backed up

正确答案:A,B

第3题:

Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()

A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover

B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area


参考答案:C, D

第4题:

You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup, you need the database ID (DBID). In which two sources would you find the DBID? ()

  • A、 the alert log file
  • B、 the server parameter file
  • C、 the formatted name of a control file autobackup
  • D、 an RMAN session log file
  • E、 the trace file

正确答案:C,D

第5题:

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery?()

  • A、Change the RMAN archived log deletion policy
  • B、Use the RMAN CROSSCHECK command to reclaim the archived log space
  • C、Change the RMAN retention policy to retain backups for a shorter period of time
  • D、Use OS command to move files from the flash recovery area to some other location

正确答案:B,D

第6题:

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?() (Choose three.)

A. Alert log file

B. Archived redo log files

C. Control file autobackups

D. Server Parameter file (SPFILE)

E. Recovery Manager (RMAN) backup piece


参考答案:B, C, E

第7题:

Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()

  • A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 
  • B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 
  • C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 
  • D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

正确答案:A

第8题:

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?()

A. Alert log file

B. Archived redo log files

C. Control file autobackups

D. Server Parameter file (SPFILE)

E. Recovery Manager (RMAN) backup piece


参考答案:B, C, E

第9题:

On which three can you use Recovery Manager (RMAN) to perform incremental backup?()

  • A、data files
  • B、control files
  • C、tablespaces
  • D、password file
  • E、parameter file
  • F、whole database
  • G、flashback log file
  • H、archived log files
  • I、change tracking file

正确答案:A,C,F

第10题:

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area?()

  • A、 backup pieces
  • B、 copies of all the parameter files
  • C、 trace file generated using BACKUP CONTROLFILE TO TRACE
  • D、 control file autobackups

正确答案:A,D

更多相关问题