单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）A The backup will consist of used data blocks only.B The database must be shut down to accomplish the backup.C The backup can be accomplished wit

题目
单选题
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）
A

The backup will consist of used data blocks only.

B

The database must be shut down to accomplish the backup.

C

The backup can be accomplished without shutting down the database.

D

The backup will contain all database files that have never been backed up.

相似考题

1.You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation? ()(Choose two.)A. Backup compression should be enabledB. Parallelism for the channel should be set to 2C. All the files must be backed up as backup setsD. The backup may be stored either on disk or on media with media manager

2. Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

3. Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）  A、 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.C、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.D、 If you restart the database，the database will not be opened.

4. To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）  A、 The database will open，and the tablespace automatically comes out of the backup mode.B、 The database will be mounted，and recovery must be performed on the USERS tablespace.C、 The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.D、 The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）A The backup will consist of used data blocks only.B The database must be shut down to accomplish the backup.C The backup can be accomplished wit”相关问题

  • 第1题：

    Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）

    • A、The data files can be recovered till the last committed transaction.
    • B、The data files can be recovered without shutting down the database.
    • C、The data file is taken offline automatically; the database remains open.
    • D、The data files can be recovered to the time of the most recent backup.

    正确答案:A

  • 第2题：

    Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）

    • A、The backup will consist of used data blocks only.
    • B、The database must be shut down to accomplish the backup.
    • C、The backup can be accomplished without shutting down the database.
    • D、The backup will contain all database files that have never been backed up.

    正确答案:B

  • 第3题：

    You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）

    • A、Backup compression should be enabled
    • B、Parallelism for the channel should be set to 2
    • C、All the files must be backed up as backup sets
    • D、The backup may be stored either on disk or on media with media manager

    正确答案:D,E

  • 第4题：

    You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）

    • A、The backup is similar to image copy.
    • B、The backup contains all used data blocks.
    • C、The backup contains only unused data blocks.
    • D、The backup contains all data blocks changed since the last incremental level 1 backup.

    正确答案:B

  • 第5题：

    Which of the following shut down options should not be used before performing a consistent whole database backup？（）

    • A、NORMAL
    • B、TRANSACTIONAL
    • C、ABORT
    • D、IMMEDIATE
    • E、INCONSISTENT

    正确答案:C

  • 第6题：

    单选题
    Which of the following shut down options should not be used before performing a consistent whole database backup？（）
    A

    NORMAL

    B

    TRANSACTIONAL

    C

    ABORT

    D

    IMMEDIATE

    E

    INCONSISTENT


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

  • 第7题：

    单选题
    Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）
    A

    The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

    B

    If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

    C

    If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

    D

    If you restart the database, the database will not be opened.


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

  • 第8题：

    单选题
    Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）
    A

    The data files can be recovered till the last committed transaction.

    B

    The data files can be recovered without shutting down the database.

    C

    The data file is taken offline automatically; the database remains open.

    D

    The data files can be recovered to the time of the most recent backup.


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

  • 第9题：

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

  • 第10题：

    单选题
    Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode（）
    A

    The backup will consist of used data blocks only.

    B

    The database must be shut down to accomplish the backup.

    C

    The backup can be accomplished without shutting down the database.

    D

    The backup will contain all database files that have never been backed up


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

  • 第11题：

    单选题
    You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
    A

    The backup is similar to image copy.

    B

    The backup contains all used data blocks.

    C

    The backup contains only unused data blocks.

    D

    The backup contains all data blocks changed since the last incremental level 1 backup.


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

  • 第12题：

    单选题
    Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）
    A

    The data files can be recovered till the last committed transaction.

    B

    The data files can be recovered without shutting down the database.

    C

    The data file is taken offline automatically； the database remains open.

    D

    The data files can be recovered to the time of the most recent backup.


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

  • 第13题：

    You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

    • A、You can perform consistent backups only.
    • B、You can perform a complete database backup without shutting down the database instance.
    • C、You can back up data files only when all data files have the same SCN recorded in the control file.
    • D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

    正确答案:B,D

  • 第14题：

    You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)

    • A、Backup compression should be enabled
    • B、Parallelism for the channel should be set to 2
    • C、All the files must be backed up as backup sets
    • D、The backup may be stored either on disk or on media with media manager

    正确答案:C,D

  • 第15题：

    Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）

    • A、The data files can be recovered till the last committed transaction.
    • B、The data files can be recovered without shutting down the database.
    • C、The data file is taken offline automatically； the database remains open.
    • D、The data files can be recovered to the time of the most recent backup.

    正确答案:A

  • 第16题：

    According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）

    • A、The backup is similar to image copy.
    • B、The backup contains all used data blocks.
    • C、The backup contains only unused data blocks.
    • D、The backup contains all data blocks changed since the last incremental level 1 backup.

    正确答案:B

  • 第17题：

    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

    • A、The database will open, and the tablespace automatically comes out of the backup mode
    • B、The database will be mounted, and recovery must be performed on the USERS tablespace.
    • C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
    • D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

    正确答案:C

  • 第18题：

    单选题
    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）
    A

    The database will open, and the tablespace automatically comes out of the backup mode

    B

    The database will be mounted, and recovery must be performed on the USERS tablespace.

    C

    The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.

    D

    The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.


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

  • 第19题：

    单选题
    Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）
    A

     The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

    B

     If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.

    C

     If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.

    D

     If you restart the database，the database will not be opened.


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

  • 第20题：

    单选题
    To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）
    A

     The database will open，and the tablespace automatically comes out of the backup mode.

    B

     The database will be mounted，and recovery must be performed on the USERS tablespace.

    C

     The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.

    D

     The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.


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

  • 第21题：

    多选题
    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）
    A

    The instance aborts.

    B

    The database cannot be recovered.

    C

    The database can be recovered by restoring the control files from the backup.

    D

    The database remains opened and you have to shut it down with the ABORT option.

    E

    The database can be restored till the point of the last closed whole database backup.


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

  • 第22题：

    多选题
    You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation？（）
    A

    Backup compression should be enabled

    B

    Parallelism for the channel should be set to 2

    C

    All the files must be backed up as backup sets

    D

    The backup may be stored either on disk or on media with media manager


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

  • 第23题：

    多选题
    You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)
    A

    Backup compression should be enabled

    B

    Parallelism for the channel should be set to 2

    C

    All the files must be backed up as backup sets

    D

    The backup may be stored either on disk or on media with media manager


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

相关内容