多选题Which three data components are needed for point-in-time recovery?（）AThe error logBThe backup logCThe general query logDBinary logsEThe data backupFConfiguration files

题目
多选题
Which three data components are needed for point-in-time recovery?（）
A

The error log

B

The backup log

C

The general query log

D

Binary logs

E

The data backup

F

Configuration files

相似考题

1.Which options must you configure while performing an automated Tablespace Point－in－Time Recovery (TSPITR) by using Recovery Manager (RMAN)?()A. New channels for restore and recovery tasksB. New name for the data files of the tablespaceC. Auxiliary name for the data files of the tablespaceD. Auxiliary destinations for an auxiliary set of data files

2.Which three data components are needed for point－in－time recovery?()A.The error logB.The backup logC.The general query logD.Binary logsE.The data backupF.Configuration files

3.A general purpose MySQL instance is configured with the following options:—log-slow-queries—long-query-time=,0001—log-slow-admin-queries—general-log—log-bin—binlog-format=STATEMENT—innodb-flush-log-at-trx-commit=1Which three statements are true（）。A.The General Query Log records more data than the Binary LogB.The binary Log records more data than the General Query LogC.The Slow Query Log records more data than the General Query LogD.The General Query Log records more data than the Slow Query LogE.The Slow Query Log records more data than the Binary LogF.The Binary Log records more data than the Slow Query Log

4.Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）A. Redo logsB. Control fileC. The latest backup of only the damaged data fileD. The latest backup of all the data file in the USERS tablespaceE. Temporary files of temporary tablespaceF. Archive Logs since the latest backup to point of failure

更多“多选题Which three data components are needed for point-in-time recovery?（）AThe error logBThe backup logCThe general query logDBinary logsEThe data backupFConfiguration files”相关问题

  • 第1题：

    Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)

    A. Redo logs

    B. Control file

    C. The latest backup of only the damaged data file

    D. The latest backup of all the data file in the USERS tablespace

    E. Temporary files of temporary tablespace

    F. Archive Logs since the latest backup to point of failure


    参考答案：A, C, F

  • 第2题：

    Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）

    • A、Redo logs
    • B、Control file
    • C、The latest backup of only the damaged data file
    • D、The latest backup of all the data file in the USERS tablespace
    • E、Temporary files of temporary tablespace
    • F、Archive Logs since the latest backup to point of failure

    正确答案:A,C,F

  • 第3题：

    Which three data components are needed for point-in-time recovery?（）

    • A、The error log
    • B、The backup log
    • C、The general query log
    • D、Binary logs
    • E、The data backup
    • F、Configuration files

    正确答案:D,E,F

  • 第4题：

    A general purpose MySQL instance is configured with the following options: —log-slow-queries —long-query-time=,0001 —log-slow-admin-queries —general-log —log-bin —binlog-format=STATEMENT —innodb-flush-log-at-trx-commit=1 Which three statements are true（）。

    • A、The General Query Log records more data than the Binary Log
    • B、The binary Log records more data than the General Query Log
    • C、The Slow Query Log records more data than the General Query Log
    • D、The General Query Log records more data than the Slow Query Log
    • E、The Slow Query Log records more data than the Binary Log
    • F、The Binary Log records more data than the Slow Query Log

    正确答案:A,D,E

  • 第5题：

    Which options must you configure while performing an automated Tablespace Point-in-Time Recovery(TSPITR) by using Recovery Manager (RMAN)?（）

    • A、New channels for restore and recovery tasks
    • B、New name for the data files of the tablespace
    • C、Auxiliary name for the data files of the tablespace
    • D、Auxiliary destinations for an auxiliary set of data files

    正确答案:D

  • 第6题：

    多选题
    Data files of which three tablespaces can be recovered by performing an open recovery？（）
    A

    TEMP

    B

    UNDO

    C

    INDEX

    D

    SYSAUX

    E

    SYSTEM


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

  • 第7题：

    多选题
    The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）
    A

    Restore the data file and perform incomplete recovery.

    B

    Restore the data file and perform point-in-time recover.

    C

    Drop the tablespace and lose all data in the tablespace.

    D

    Restore the database and lose all data since the last backup.


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

  • 第8题：

    单选题
    You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP  FORMAT ’/BACKUP/df_%d_%s_%p.bus’  DATABASE filesperset = 2；  Which components are included in the backup？（）
    A

    Only the data files.

    B

    Only the data files and the online logs.

    C

    The data files， control files， and the online logs.

    D

    The data files and control files， but not the online logs.


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

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

    多选题
    For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）
    A

    RMAN image copies

    B

    RMAN database backups

    C

    RMAN tablespace backups

    D

    user­managed backups placed in the flash recovery area

    E

    user­managed backups that have been cataloged with RMAN

    F

    user­managed data file backups for which the full path name is specified


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

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

    多选题
    Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）
    A

    Redo logs

    B

    Control file

    C

    The latest backup of only the damaged data file

    D

    The latest backup of all the data file in the USERS tablespace

    E

    Temporary files of temporary tablespace

    F

    Archive Logs since the latest backup to point of failure


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

  • 第13题：

    The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）

    • A、data files
    • B、backup sets
    • C、control files
    • D、archived redo log files

    正确答案:A,B,D

  • 第14题：

    Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)

    • A、Redo logs
    • B、Control file
    • C、The latest backup of only the damaged data file
    • D、The latest backup of all the data file in the USERS tablespace
    • E、Temporary files of temporary tablespace
    • F、Archive Logs since the latest backup to point of failure

    正确答案:A,C,F

  • 第15题：

    Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

    • A、 redo logs
    • B、 control file
    • C、 temporary files of temporary tablespace
    • D、 the latest backup of only the damaged data file
    • E、 the latest backup of all the data files In the USERS tablespace

    正确答案:A,B,D

  • 第16题：

    You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP  FORMAT ’/BACKUP/df_%d_%s_%p.bus’  DATABASE filesperset = 2；  Which components are included in the backup？（）

    • A、Only the data files.
    • B、Only the data files and the online logs.
    • C、The data files， control files， and the online logs.
    • D、The data files and control files， but not the online logs.

    正确答案:D

  • 第17题：

    Data files of which three tablespaces can be recovered by performing an open recovery？（）

    • A、TEMP
    • B、UNDO
    • C、INDEX
    • D、SYSAUX
    • E、SYSTEM

    正确答案:A,C,D

  • 第18题：

    多选题
    Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)
    A

    Redo logs

    B

    Control file

    C

    The latest backup of only the damaged data file

    D

    The latest backup of all the data file in the USERS tablespace

    E

    Temporary files of temporary tablespace

    F

    Archive Logs since the latest backup to point of failure


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

  • 第19题：

    多选题
    A general purpose MySQL instance is configured with the following options: —log-slow-queries —long-query-time=,0001 —log-slow-admin-queries —general-log —log-bin —binlog-format=STATEMENT —innodb-flush-log-at-trx-commit=1 Which three statements are true（）。
    A

    The General Query Log records more data than the Binary Log

    B

    The binary Log records more data than the General Query Log

    C

    The Slow Query Log records more data than the General Query Log

    D

    The General Query Log records more data than the Slow Query Log

    E

    The Slow Query Log records more data than the Binary Log

    F

    The Binary Log records more data than the Slow Query Log


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

  • 第20题：

    多选题
    Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?（）
    A

    The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.

    B

    The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.

    C

    The C # # A_ADMIN user can perform wallet operations.

    D

    The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).

    E

    The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.


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

  • 第21题：

    单选题
    A system administrator had a disk failure on an HMC. The disk was replaced and the HMC was loaded from the Product Recovery CD. The system administrator had performed a backup to DVD of the HMC data before the system failed. After restoring the backup files, it was noticed that no profile files were restored. What is the most likely cause of this problem?（）
    A

    The profile data was not initialized after restoring the backup CD

    B

    The profile data was not backed up before doing the Critical Console Data backup

    C

    A Critical Console Data backup was performed which backs up user data， but not profile data

    D

    A Save Upgrade data was done instead of a backup Critical Console Data and the profile files were not included


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

  • 第22题：

    多选题
    You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file， if it has already been backed up.（）
    A

    The data file backup is done with multiple channels

    B

    The data files is in the read-write mode after being backed up in the read only mode

    C

    The backup was taken after the data files was taken offline-normal or is in the read only mode

    D

    The data file backup complies with the back retention policy and the backup duplexing fe ture


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

  • 第23题：

    多选题
    Which three data components are needed for point-in-time recovery?（）
    A

    The error log

    B

    The backup log

    C

    The general query log

    D

    Binary logs

    E

    The data backup

    F

    Configuration files


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

  • 第24题：

    多选题
    Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）
    A

    redo logs

    B

    control file

    C

    temporary files of temporary tablespace

    D

    the latest backup of only the damaged data file

    E

    the latest backup of all the data files In the USERS tablespace


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

相关内容