单选题Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）A user-managed backups.B partial database backups.C consistent database backups.D inconsistent database

题目
单选题
Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）
A

user-managed backups.

B

partial database backups.

C

consistent database backups.

D

inconsistent database backups.

相似考题

1.You are managing a 24*7 database. The backup strategy for the database is to perform user－managedbackups.Identify two prerequisites to perform the backups. (Choose two.)()A. The database must be opened in restricted mode.B. The database must be configured to run in ARCHIVELOG mode.C. The tablespaces are required to be in backup mode before taking the backup.D. The tablespaces are required to be in read-only mode before taking the backup

2.Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）A、user-managed backups.B、partial database backups.C、consistent database backups.D、inconsistent database backups.

3.You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup

4. You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）A、You must have change tracking enabled in your databaseB、Your database must be running in NOARCHIVELOG modeC、To back up a tablespace, it must be in backup modeD、To back up a tablespace, it must first be taken offline

更多“单选题Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）A user-managed backups.B partial database backups.C consistent database backups.D inconsistent database”相关问题

  • 第1题：

    You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）

    • A、The database must be opened in restricted mode.
    • B、The database must be configured to run in ARCHIVELOG mode.
    • C、The tablespaces are required to be in backup mode before taking the backup.
    • D、The tablespaces are required to be in read-only mode before taking the backup

    正确答案:B,C

  • 第2题：

    You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

    • A、The database crashes.
    • B、The DBA needs to re-create the file.
    • C、The file gets re-created automatically.
    • D、The file gets restored automatically from the last backup.
    • E、The DBA needs to perform a complete database recovery.
    • F、The DBA needs to perform an incomplete database recovery.

    正确答案:C

  • 第3题：

    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

  • 第4题：

    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.

    正确答案:B,C

  • 第5题：

    Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）

    • A、You can perform open database backups.
    • B、You can perform closed database backups.
    • C、You cannot perform schema-level logical backups.
    • D、You can perform the backup of only the SYSTEM tablespace when the database is open.

    正确答案:B

  • 第6题：

    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

  • 第7题：

    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

  • 第8题：

    多选题
    Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day， 7 days a week production environment？（）
    A

    ARCHIVELOG mode.

    B

    NOARCHIVELOG mode.

    C

    Open database backups.

    D

    Consistent whole backups.


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

  • 第9题：

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


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

  • 第10题：

    单选题
    Which command would you use to determine what database backups are currently available for restore?（）
    A

    list database backup

    B

    report database backup  

    C

    list backup of database

    D

    list summary backup

    E

    report backup of database


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

  • 第11题：

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

  • 第12题：

    多选题
    You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）
    A

    The database must be opened in restricted mode.

    B

    The database must be configured to run in ARCHIVELOG mode.

    C

    The tablespaces are required to be in backup mode before taking the backup.

    D

    The tablespaces are required to be in read-only mode before taking the backup


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

  • 第13题：

    Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）

    • A、You can perform online whole database backups.
    • B、You can performofflinewhole database backups.
    • C、You cannot perform schema-level export/import operations.
    • D、You can perform the backup of only the SYSTEM tablespace when the database is open.

    正确答案:B

  • 第14题：

    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

  • 第15题：

    You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

    • A、The database must be opened in restricted mode.
    • B、The database must be configured to run in ARCHIVELOG mode.
    • C、The tablespaces are required to be in backup mode before taking the backup.
    • D、The tablespaces are required to be in read-only mode before taking the backup

    正确答案:B,C

  • 第16题：

    Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day， 7 days a week production environment？（）

    • A、ARCHIVELOG mode.
    • B、NOARCHIVELOG mode.
    • C、Open database backups.
    • D、Consistent whole backups.

    正确答案:A,C

  • 第17题：

    Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）

    • A、Online backups.
    • B、Skipping unused block. 
    • C、Partial database backups.
    • D、Incremental block-level backup.
    • E、Detection of corrupted blocks during backup.

    正确答案:B,D,E

  • 第18题：

    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

  • 第19题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured 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


    正确答案： A,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题：

    单选题
    You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）
    A

    You must have change tracking enabled in your database

    B

    Your database must be running in NOARCHIVELOG mode

    C

    To back up a tablespace, it must be in backup mode

    D

    To back up a tablespace, it must first be taken offline


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

  • 第22题：

    单选题
    You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）
    A

    The database crashes.

    B

    The DBA needs to re-create the file.

    C

    The file gets re-created automatically.

    D

    The file gets restored automatically from the last backup.

    E

    The DBA needs to perform a complete database recovery.

    F

    The DBA needs to perform an incomplete database recovery.


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

  • 第23题：

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

相关内容