多项选择题

A.flashback log filesB.backups that have become obsolet……

You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.
Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）

A.flashback log files
B.backups that have become obsolete
C.copies 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

<上一题目录下一题>

热门试题

单项选择题You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1）Shut down the instance. 2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3）Execute the ALTER DATABASE FLASHBACK OFF command. 4）Start up the instance and mount the database. 5）Execute the ALTER DATABASE FLASHBACKON command. 6）Open the database. Select the correct order in which these tasks need to be performed. （）

A.2，1，4，3，5，6
B.1，4，3，2，6，5
C.1，4，2，6，3，5
D.3，2，1，4，5，6

单项选择题You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task（）

A.Multiplex all database files
B.Configure the Flash Recovery Area.
C.Configure the database instance for ARCHIVELOG mode.
D.Configure the FAST_START_MTTR_TARGET initialization parameter.

单项选择题Theinstanceabnormallyterminatesbecauseofapoweroutage.Whichstatementistrueaboutredologfilesduringinstancerecovery（）

A.Inactive and current redo log files are required to accomplish recovery.
B.Online and archived redo log files are required to accomplish instance recovery.
C.All redo log entries after the last checkpoint are applied from redo log files to data files.
D.All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.

多项选择题Younoticethattheperformanceofthedatabasehasdegradedbecauseoffrequentcheckpoints.Whichtwoactionsresolvetheissue（）

A.Disable automatic checkpoint tuning.
B.Check the size of the redo log file size and increase the size if it is small.
C.Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D.Decrease the number of redo log members if there are more than one redo log members available in each redo log group.

多项选择题Whichtwostatementsaretrueaboutcheckpointing（）

A.The checkpoint frequency decreases with the smaller redo log file size.
B.It ensures that all committed data is written to the data files during normal shutdown.
C.The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D.It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.