niusouti.com

多选题The loss of which two types of files may require a recovery with the RESETLOGS option？（）Acontrol filesBpassword fileCarchived log filesDsystem-critical data files for which all the redo entries are presentEnon-system-critical data files for which all t

题目
多选题
The loss of which two types of files may require a recovery with the RESETLOGS option？（）
A

control files

B

password file

C

archived log files

D

system-critical data files for which all the redo entries are present

E

non-system-critical data files for which all the redo entries are present

相似考题

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

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

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

4.The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）A、data filesB、backup setsC、control filesD、archived redo log files

更多“多选题The loss of which two types of files may require a recovery with the RESETLOGS option？（）Acontrol filesBpassword fileCarchived log filesDsystem-critical data files for which all the redo entries are presentEnon-system-critical data files for which all t”相关问题

  • 第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题：

    After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）

    • A、The online redo log files and online data files are opened.
    • B、All the online data file headers are checked for consistency.
    • C、Instance recovery is performed before opening the database.
    • D、The path and existence of all the log file members are checked

    正确答案:A,B

  • 第3题：

    Which type of database file is spread across all disks in a disk group？（）

    • A、 All types of files are spread across all disks in the disk group.
    • B、 Datafiles
    • C、 Redo log files
    • D、 Archived redo log files
    • E、 Control files

    正确答案:A

  • 第4题：

    The loss of which two types of files may require a recovery with the RESETLOGS option？（）

    • A、 control files
    • B、 password file
    • C、 archived log files
    • D、 system-critical data files for which all the redo entries are present
    • E、 non-system-critical data files for which all the redo entries are present

    正确答案:A,C

  • 第5题：

    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)

    • A、Creating the control file for the duplicate database
    • B、Restoring the target data files to the duplicate database
    • C、Performing complete recovery using all available backups
    • D、Generating a new, unique DBID for the duplicate database
    • E、Copying the online redo log files from the target database to the duplicate database

    正确答案:C,E

  • 第6题：

    View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

    • A、 all the data files belonging to the USERS tablespace
    • B、 password file
    • C、 online redo log files
    • D、 the current control file
    • E、 archived redo log files
    • F、 the current server parameter file
    • G、 data files belonging to the USERS tablespace and all the default tablespaces

    正确答案:A,D,F

  • 第7题：

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

  • 第8题：

    单选题
    You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure， the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files？（）
    A

    Only the data files.

    B

    All of the data files and the control files.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    Only the data files belonging to the SYSTEM tablespace and the control files.


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

  • 第9题：

    多选题
    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?（）
    A

    Creating the control file for the duplicate database

    B

    Restoring the target data files to the duplicate database

    C

    Performing complete recovery using all available backups

    D

    Generating a new, unique DBID for the duplicate database

    E

    Copying the online redo log files from the target database to the duplicate database


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

  • 第10题：

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

  • 第11题：

    单选题
    You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
    A

     loss of one of the tablespaces

    B

     loss of a system data file

    C

     loss of one of the control files

    D

     loss of a tempfile

    E

     loss of the only member of an unarchived redo log group

    F

     loss of a member from each redo log group


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

  • 第12题：

    多选题
    After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN；  Which two statements are true（）
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


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

  • 第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题：

    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题：

    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

  • 第16题：

    You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

    • A、 loss of one of the tablespaces
    • B、 loss of a system data file
    • C、 loss of one of the control files
    • D、 loss of a tempfile
    • E、 loss of the only member of an unarchived redo log group
    • F、 loss of a member from each redo log group

    正确答案:E

  • 第17题：

    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）

    • A、 Creating the control file for the duplicate database
    • B、 Restoring the target data files to the duplicate database
    • C、 Performing complete recovery using all available backups
    • D、 Generating a new， unique DBID for the duplicate database
    • E、 Copying the online redo log files from the target database to the duplicate database

    正确答案:C,E

  • 第18题：

    多选题
    View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）
    A

    all the data files belonging to the USERS tablespace

    B

    password file

    C

    online redo log files

    D

    the current control file

    E

    archived redo log files

    F

    the current server parameter file

    G

    data files belonging to the USERS tablespace and all the default tablespaces


    正确答案： G,F
    解析： 暂无解析

  • 第19题：

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

  • 第20题：

    单选题
    You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.  In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
    A

    loss of a tempfile

    B

    loss of a system data file

    C

    loss of one of the control files

    D

    loss of one of the tablespaces

    E

    loss of a member from each redo log group

    F

    loss of the only member of an unarchived redo log group


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

  • 第21题：

    多选题
    The loss of which two types of files may require a recovery with the RESETLOGS option？（）
    A

    control files

    B

    password file

    C

    archived log files

    D

    system-critical data files for which all the redo entries are present

    E

    non-system-critical data files for which all the redo entries are present


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

  • 第22题：

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

  • 第23题：

    多选题
    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)
    A

    Creating the control file for the duplicate database

    B

    Restoring the target data files to the duplicate database

    C

    Performing complete recovery using all available backups

    D

    Generating a new, unique DBID for the duplicate database

    E

    Copying the online redo log files from the target database to the duplicate database


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

  • 第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
    解析： 暂无解析

相关内容