niusouti.com

多选题Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）ADatabase datafilesBControl filesCArchived redo logsDOnline redo logsEFlashback logs

题目
多选题
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）
A

Database datafiles

B

Control files

C

Archived redo logs

D

Online redo logs

E

Flashback logs

相似考题

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.Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)A. Database datafilesB. Control filesC. Online redo logsD. Database pfilesE. Archived redo logs

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

4.Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()A. only the control file, the current SPFILE, and data filesB. only the current SPFILE and data files if autobackup is disabledC. only the data files and the archived redo logsD. the control file, current SPFILE file, data files, and archived redo logs

更多“多选题Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）ADatabase datafilesBControl filesCArchived redo logsDOnline redo logsEFlashback logs”相关问题

  • 第1题：

    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

  • 第2题：

    Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

    • A、 Database datafiles
    • B、 Control files
    • C、 Archived redo logs
    • D、 Online redo logs
    • E、 Flashback logs

    正确答案:A,B,D

  • 第3题：

    Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）  

    • A、 Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.
    • B、 Just back up the database datafiles without shutting down the database.
    • C、 You will have to wait until you can shut down the database to perform the backup.
    • D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
    • E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

    正确答案:C

  • 第4题：

    Which files are required for a full recovery of the database in ARCHIVELOG mode？（）

    • A、 Database datafiles
    • B、 Online redo logs
    • C、 Archived redo logs
    • D、 Backup control file
    • E、 Control file from a backup

    正确答案:A,C,D

  • 第5题：

    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

  • 第6题：

    Which of the following files cannot be backed up by RMAN? （）(Choose all that apply.）

    • A、Database datafiles
    • B、Control files
    • C、Online redo logs
    • D、Database pfiles
    • E、Archived redo logs

    正确答案:C,D

  • 第7题：

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

  • 第8题：

    多选题
    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 files

    B

    Password files

    C

    Inactive online redo log file

    D

    Archived log files required to perform recovery

    E

    Newly created tablespace which is not backed up


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

  • 第9题：

    多选题
    Which of the following files cannot be backed up by RMAN？（）
    A

    Database datafiles

    B

    Control files

    C

    Online redo logs

    D

    Database pfiles

    E

    Archived redo logs


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

  • 第10题：

    多选题
    Which of the following files cannot be backed up by RMAN? （）(Choose all that apply.）
    A

    Database datafiles

    B

    Control files

    C

    Online redo logs

    D

    Database pfiles

    E

    Archived redo logs


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

  • 第11题：

    单选题
    Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）
    A

    only the control file, the current SPFILE, and data files

    B

    only the current SPFILE and data files if autobackup is disabled

    C

    only the data files and the archived redo logs

    D

    the control file, current SPFILE file, data files, and archived redo logs


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

  • 第12题：

    单选题
    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）
    A

     Database Datafiles

    B

     Database Control Files

    C

     Online redo logs

    D

     Archived redo logs

    E

     The database SPFILE

    F

     None of the above，all these files are backed up


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

  • 第13题：

    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 files
    • B、 Password files
    • C、 Inactive online redo log file
    • D、 Archived log files required to perform recovery
    • E、 Newly created tablespace which is not backed up

    正确答案:A,D

  • 第14题：

    In which two cases would you perform only consistent backup？（）

    • A、You are working on a database where downtime is not tolerated.
    • B、You are working on a database where downtime can be tolerated.
    • C、You are working on a database that operates in ARCHIVELOG mode.
    • D、You are working on a database that operates in NOARCHIVELOG mode.
    • E、You are working on a database where all the tablespaces are locally managed.
    • F、You are working on a database where control files and redo log files are multiplexed.
    • G、You are working on a database where control files and redo log files are not multiplexed.

    正确答案:B,D

  • 第15题：

    Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）

    • A、only the control file, the current SPFILE, and data files
    • B、only the current SPFILE and data files if autobackup is disabled
    • C、only the data files and the archived redo logs
    • D、the control file, current SPFILE file, data files, and archived redo logs

    正确答案:D

  • 第16题：

    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

    • A、Database Datafiles 
    • B、Database Control Files 
    • C、Online redo logs
    • D、Archived redo logs 
    • E、The database SPFILE 
    • F、None of the above, all these files are backed up. 

    正确答案:C

  • 第17题：

    A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）

    • A、 clear the redo log group
    • B、 perform redo log file import
    • C、 perform an incomplete recovery
    • D、 perform a redo log recovery using Recovery Manager （RMAN）
    • E、 shut down the database and open the database in the NOARCHIVELOG mode

    正确答案:A

  • 第18题：

    多选题
    Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）
    A

    Database datafiles

    B

    Control files

    C

    Archived redo logs

    D

    Online redo logs

    E

    Flashback logs


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

  • 第19题：

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


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

  • 第20题：

    单选题
    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）
    A

    Database Datafiles 

    B

    Database Control Files 

    C

    Online redo logs

    D

    Archived redo logs 

    E

    The database SPFILE 

    F

    None of the above, all these files are backed up. 


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

  • 第21题：

    多选题
    Which two statements about Recovery Manager （RMAN） backups are true？ （）
    A

    Online redo log files can be backed up.

    B

    Archived redo log files are backed up.

    C

    Only used data blocks can be backed up as backup sets.

    D

    Only consistent database backups can be performed.

    E

    RMAN backup can be taken only if the database is configured in ARCHIVELOG mode.


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

  • 第22题：

    多选题
    Which files are required for a full recovery of the database in ARCHIVELOG mode？（）
    A

    Database datafiles

    B

    Online redo logs

    C

    Archived redo logs

    D

    Backup control file

    E

    Control file from a backup


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

  • 第23题：

    单选题
    A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）
    A

     clear the redo log group

    B

     perform redo log file import

    C

     perform an incomplete recovery

    D

     perform a redo log recovery using Recovery Manager （RMAN）

    E

     shut down the database and open the database in the NOARCHIVELOG mode


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

  • 第24题：

    多选题
    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 files

    B

    Password files

    C

    Inactive online redo log file

    D

    Archived log files required to perform recovery

    E

    Newly created tablespace which is not backed up


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

相关内容