单选题The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）AInactive and current redo log files are required to accomplish recovery.BOnline and archived redo log files are required to accomplish instance recovery.CAll redo log entries after the last checkpoint are applied from redo log files to data files.DAll redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.
单选题
The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）
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.
参考解析
解析：
暂无解析
相关考题：
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.
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? ()(Choose two) A. Control filesB. Password filesC. Inactive online redo log fileD. Archived log files required to perform recoveryE. Newly created tablespace which is not backed up
The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery（）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 data files
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 filesB、Backups that have become obsoleteC、User managed backups of the data files and control filesD、Archived redo log files that have multiple copies in a different archive location and not backed up
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.
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A、The online redo log files and archived redo log files are required to accomplish the recovery.B、The uncommitted transaction will be committed at the next startup of the database instance.C、The uncommitted transaction is rolled back automatically at the next opening of the database.D、The DBA has to perform the recovery on the database to recover the uncommitted transaction
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）A、 Control filesB、 Password filesC、 Inactive online redo log fileD、 Archived log files required to perform recoveryE、 Newly created tablespace which is not backed up
You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’. Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）A、 The archived redo log files will be overwritten.B、 The archived redo log files are deleted automatically.C、 The archived redo log files should be moved to some other location.D、 The archived redo log files are still maintained because the file names are unique.
You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）A、 multiplexed control filesB、 RMAN obsolete backupsC、 multiplexed online redo log filesD、 archived redo logs that have not been copied to tape
Which three statements are true about the stages of database startup？（）A、Data files and redo log files can be renamed at the MOUNT stage.B、Control files are read at the OPEN stage for the location of data files.C、Control files are required to bring the database to the NOMOUNT stage.D、Data files and redo log files are made available to users at the OPEN stage.E、Data files and online redo log files are checked for consistency while opening the database
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 filesB、backups that have become obsoleteC、copies of the data files and control filesD、archived redo log files that have multiple copies in a different archive location and not backed up
The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）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.
While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?（）A、The backup fails because one of the archived redo log files is missing. B、The backup succeeds but it would be without the missing archived log. C、During backup, you are prompted for the alternative destination for the missing archived redo log file. D、The backup succeeds because it fails over to one of the alternative archived redo log destinations.
You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.B、 Before the instance starts， you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？ （）A、Transactions are rolled back using redo log files.B、Transactions are rolled forward using redo log files.C、Transactions are rolled back using redo log files and archived log files.D、Transactions are rolled forward using redo log files and rolled back using redo log files.
单选题Which components are needed for successful and most efficient recovery.（）A The backup RB3 and the current online redo log filesB the backup RB2 and the archived redo log files after the log sequence number 15622C Backup R81 and the archived redo log hies after the log sequence number 12871D The backup RB3 and the archived redo log files after the log sequence number 16721
单选题You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）A multiplexed control filesB RMAN obsolete backupsC multiplexed online redo log filesD archived redo logs that have not been copied to tape
多选题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（）AFlashback log filesBBackups that have become obsoleteCUser managed backups of the data files and control filesDArchived redo log files that have multiple copies in a different archive location and not backed up
多选题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（）Aflashback log filesBbackups that have become obsoleteCcopies of the data files and control filesDarchived redo log files that have multiple copies in a different archive location and not backed up
单选题While performing the backup of the flash recovery area， you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area？（）A The backup fails because one of the archived redo log files is missing.B The backup succeeds but it would be without the missing archived log.C During backup，you are prompted for the alternative destination for the missing archived redo log file.D The backup succeeds because it fails over to one of the alternative archived redo log destinations.
单选题You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’. Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）A The archived redo log files will be overwritten.B The archived redo log files are deleted automatically.C The archived redo log files should be moved to some other location.D The archived redo log files are still maintained because the file names are unique.
单选题While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?（）AThe backup fails because one of the archived redo log files is missing. BThe backup succeeds but it would be without the missing archived log. CDuring backup, you are prompted for the alternative destination for the missing archived redo log file. DThe backup succeeds because it fails over to one of the alternative archived redo log destinations.
单选题Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）ARestore the latest whole backup, perform complete recovery, and open the database normallyBRestore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionCRestore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionDRestore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
单选题The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery（）AInactive and current redo log files are required to accomplish recovery.BOnline and archived redo log files are required to accomplish instance recovery.CAll redo log entries after the last checkpoint are applied from redo log files to data files.DAll redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
单选题Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？ （）ATransactions are rolled back using redo log files.BTransactions are rolled forward using redo log files.CTransactions are rolled back using redo log files and archived log files.DTransactions are rolled forward using redo log files and rolled back using redo log files.
单选题You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）AThe online redo log files and archived redo log files are required to accomplish the recovery.BThe uncommitted transaction will be committed at the next startup of the database instance.CThe uncommitted transaction is rolled back automatically at the next opening of the database.DThe DBA has to perform the recovery on the database to recover the uncommitted transaction
单选题Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）AA database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. BDuring recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. CAfter 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. DAt 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.