itgle.com

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

题目

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.
相似考题

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.

2.Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)A. The user has dropped an important table that needs to be recovered.B. The database files are corrupted when the database is open.C. You are not able to start up the database instance because the required database files are missing.D. The archived log files are missing for which backup is not available.

3. 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

4.You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?()A. Archived redo log files are backed up along with data files.B. Only data files are backed up and a restore point named FY06Q4 is created.C. Archived log files are backed up along with data files, and the archived log files are deleted.D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

更多“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”相关问题

  • 第1题：

    Which  statements are true about checkpointing（）

    • 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 onlineredo log files

    正确答案:B,C

  • 第2题：

    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.

    正确答案:D

  • 第3题：

    Identify two situations in which you can use Data Recovery Advisor for recovery.（） 

    • A、 The user has dropped an important table that needs to be recovered.
    • B、 The database files are corrupted when the database is open.
    • C、 You are not able to start up the database instance because the required database files are missing.
    • D、 The archived log files are missing for which backup is not available.

    正确答案:B,C

  • 第4题：

    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.

    正确答案:C

  • 第5题：

    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.

    正确答案:B

  • 第6题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第7题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    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. 


    正确答案： B
    解析： 暂无解析

  • 第9题：

    多选题
    Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)
    A

    The user has dropped an important table that needs to be recovered.

    B

    The database files are corrupted when the database is open.

    C

    You are not able to start up the database instance because the required database files are missing.

    D

    The archived log files are missing for which backup is not available.


    正确答案： B,C
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    多选题
    Identify two situations in which you can use Data Recovery Advisor for recovery.（）
    A

    The user has dropped an important table that needs to be recovered.

    B

    The database files are corrupted when the database is open.

    C

    You are not able to start up the database instance because the required database files are missing.

    D

    The archived log files are missing for which backup is not available.


    正确答案： D,C
    解析： 暂无解析

  • 第12题：

    单选题
    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：   LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ LOG_ARCHIVE_DEST_2 = ’SERVICE = stdb1’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’   Examine the following RMAN command issued to set the deletion policy for archived log files：   RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt； 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.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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

    正确答案:C

  • 第14题：

    Which two statements are true about checkpointing（）

    • 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.

    正确答案:B,C

  • 第15题：

    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

    正确答案:A,B

  • 第16题：

    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. 

    正确答案:D

  • 第17题：

    Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)

    • A、The user has dropped an important table that needs to be recovered.
    • B、The database files are corrupted when the database is open.
    • C、You are not able to start up the database instance because the required database files are missing.
    • D、The archived log files are missing for which backup is not available.

    正确答案:B,C

  • 第18题：

    单选题
    ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.  Which statement is true in this 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.


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）
    A

    The backup will terminate because the FORMAT clause was not configured for the channel

    B

    It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

    C

    It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

    D

    It backs up the data files and archived log files to tape, making two copies of each data file and archived log file


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    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
    解析： 暂无解析

相关内容