itgle.com

多选题Which two file types must be included in a closed database backup taken with operating system commands?()Adata filesBcontrol fileCpassword fileDonline redo log filesEinitialization parameter file

题目
多选题
Which two file types must be included in a closed database backup taken with operating system commands?()
A

data files

B

control file

C

password file

D

online redo log files

E

initialization parameter file


相似考题
更多“多选题Which two file types must be included in a closed database backup taken with operating system commands?()Adata filesBcontrol fileCpassword fileDonline redo log filesEinitialization parameter file”相关问题
  • 第1题:

    Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?()

    • A、 The redo log file should belong to an active group.
    • B、 The redo log file should belong to an inactive group.
    • C、 The redo log file should belong to the current group.
    • D、 The redo log file can be dropped only if all the transactions are stopped.
    • E、 Before a redo log file is dropped, it should be deleted from the operating system (OS).

    正确答案:B

  • 第2题:

    ASM supports all but which of the following file types?()

    • A、 Database files
    • B、 Spfiles
    • C、 Redo-log files
    • D、 Archived log files
    • E、 RMAN backup sets
    • F、 Password files
    • G、 init.ora files

    正确答案:F,G

  • 第3题:

    The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()

    • A、until SCN
    • B、until time
    • C、until cancel
    • D、using backup control file

    正确答案:C

  • 第4题:

    Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager (RMAN)()

    • A、Data files
    • B、Control files
    • C、Parameter file
    • D、Online redo log files
    • E、Server parameter file

    正确答案:B,E

  • 第5题:

    When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?()  

    • A、 log_file_name_convert
    • B、 convert_log_file_name
    • C、 file_name_convert_log
    • D、 redo_log_file_name_convert
    • E、 logfile_convert_directory

    正确答案:A

  • 第6题:

    多选题
    Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?() (Choose three.)
    A

    Alert log file

    B

    Archived redo log files

    C

    Control file autobackups

    D

    Server Parameter file (SPFILE)

    E

    Recovery Manager (RMAN) backup piece


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

  • 第7题:

    单选题
    Your database is having two control files, three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down?()
    A

    any control file

    B

    any archive log file

    C

    one of the redo log members

    D

    loss of the initialization parameter file

    E

    any data file belonging to the default permanent tablespac


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

  • 第8题:

    单选题
    Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?()
    A

     The redo log file should belong to an active group.

    B

     The redo log file should belong to an inactive group.

    C

     The redo log file should belong to the current group.

    D

     The redo log file can be dropped only if all the transactions are stopped.

    E

     Before a redo log file is dropped, it should be deleted from the operating system (OS).


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

  • 第9题:

    多选题
    Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?()
    A

    Alert log file

    B

    Archived redo log files

    C

    Control file autobackups

    D

    Server Parameter file (SPFILE)

    E

    Recovery Manager (RMAN) backup piece


    正确答案: B,C,E
    解析: 暂无解析

  • 第10题:

    多选题
    Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt:     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF;   RMAN> BACKUP DATABASE;   Which files from the database will be backed up as a result of this BACKUP command?()
    A

    control file

    B

    all datafiles

    C

    password file

    D

    online redo log file

    E

    archive redo log file

    F

    server parameter file

    G

    only the SYSTEM datafile


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

  • 第11题:

    多选题
    Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager (RMAN)()
    A

    Data files

    B

    Control files

    C

    Parameter file

    D

    Online redo log files

    E

    Server parameter file


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

  • 第12题:

    多选题
    You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The FlashRecovery Area is specified as the destination for the archived redo log files. You notice this warning in thealert log file:  ORA-19815: WARNING:// db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0remaining bytes available.  What would you do to reclaim the used space in the Flash Recovery Area()
    A

    Back up the Flash Recovery Area.

    B

    Decrease the retention time for the database backup and flashback log files.

    C

    Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS)commands.

    D

    Manually delete all the expired backup sets from the Flash Recovery Area by using operating system(OS) commands.


    正确答案: D,B
    解析: 暂无解析

  • 第13题:

    You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)

    • A、The KEEP option overrides the configured retention policy
    • B、The KEEP option is an attribute of an individual backup piece
    • C、The backup contains only data files and archived redo log files
    • D、The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

    正确答案:A,D

  • 第14题:

    Which three types of files can be automatically placed in the flash recovery area fast recovery area in 11g Release 2?()

    • A、 Alert log file
    • B、 Archived redo log files
    • C、 Control file autobackups
    • D、 Server Parameter file (SPFILE)
    • E、 Recovery Manager (RMAN) backup piece

    正确答案:B,C,E

  • 第15题:

    Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()

    • A、data files
    • B、control files
    • C、parameter file
    • D、online redo log files
    • E、server parameter file

    正确答案:B,E

  • 第16题:

    Your database is having two control files, three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down?()

    • A、any control file
    • B、any archive log file
    • C、one of the redo log members
    • D、loss of the initialization parameter file
    • E、any data file belonging to the default permanent tablespac

    正确答案:A

  • 第17题:

    多选题
    You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup?()
    A

    The backup contains data files, the server parameter file,and the control file even if the control file  autobackup is disabled.

    B

    The KEEP option overrides the configured retention policy.

    C

    The backup contains only data files and archived redo log files.

    D

    The KEEP option is an attribute of an individual backup piece.


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

  • 第18题:

    多选题
    When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUPcommand? ()
    A

    data file

    B

    password file

    C

    archivelog file

    D

    temporary file

    E

    online redo log file

    F

    the current control file

    G

    the tnsnames.ora file

    H

    current server parameter file


    正确答案: E,B
    解析: 暂无解析

  • 第19题:

    多选题
    You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup?()
    A

    ABORT

    B

    NORMAL

    C

    IMMEDIATE

    D

    TRANSACTIONAL


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

  • 第20题:

    多选题
    Which two file types must be included in a closed database backup taken with operating system commands?()
    A

    data files

    B

    control file

    C

    password file

    D

    online redo log files

    E

    initialization parameter file


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

  • 第21题:

    多选题
    On which three can you use Recovery Manager (RMAN) to perform incremental backup?()
    A

    data files

    B

    control files

    C

    tablespaces

    D

    password file

    E

    parameter file

    F

    whole database

    G

    flashback log file

    H

    archived log files

    I

    change tracking file


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

  • 第22题:

    多选题
    Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()
    A

    data files

    B

    control files

    C

    parameter file

    D

    online redo log files

    E

    server parameter file


    正确答案: E,B
    解析: 暂无解析

  • 第23题:

    多选题
    You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)
    A

    The KEEP option overrides the configured retention policy

    B

    The KEEP option is an attribute of an individual backup piece

    C

    The backup contains only data files and archived redo log files

    D

    The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled


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

  • 第24题:

    多选题
    When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUP command?()
    A

    data file

    B

    password file

    C

    archivelog file

    D

    temporary file

    E

    online redo log file

    F

    the current control file

    G

    the tnsnames.ora file

    H

    current server parameter file


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