itgle.com

多选题You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup？（）AABORTBNORMALCIMMEDIATEDTRANSACTIONAL

题目
多选题
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

相似考题

1. You are using Enterprise Manager to schedule backups for your database.  Which type of script would begenerated by the backup scheduler（）A、XML scriptB、PL/SQL scriptC、Operating system scriptThis document was downloaded from =>> http：//www.amaderforum.comD、Recovery Manager （RMAN） script

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

3. You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）A、The DBMS_JOB packageB、The BACKUP_JOB packageC、The DBMS_BACKUP_RESTORE packageD、The calendar tool in the Operating System （OS）E、The backup scheduler in Enterprise Manager （EM）F、The DBMS_BACKUP_SCHEDULER packager inline mode

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

参考答案和解析
正确答案： D,A
解析： 暂无解析
更多“多选题You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup？（）AABORTBNORMALCIMMEDIATEDTRANSACTIONAL”相关问题

  • 第1题：

    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

    正确答案:A,B

  • 第2题：

    Which two are characteristics of user-managed backup and recovery operations？（）

    • A、Recovery is initiated using SQL*Plus.
    • B、Database files are backed up using SQL commands.
    • C、Database files are backed up with Recovery Manager.
    • D、Database files are restored using Recovery Manager.
    • E、Database files are backed up using operating system commands.

    正确答案:A,B

  • 第3题：

    You configured the default backup device type as disk for RMAN backups. In your database，because of business requirements，you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this？（）  

    • A、 MAXSETSIZE TO 2
    • B、 DEVICE TYPE DISK PARALLELISM 2
    • C、 RETENTION POLICY TO REDUNDANCY 2
    • D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

    正确答案:C

  • 第4题：

    Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）  

    • A、 Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.
    • B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.
    • C、 Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.
    • D、 The database will open with the file in hot backup mode. You can restart the backup at any time.
    • E、 The datafile in hot backup mode will be corrupted and you will have to recover it.

    正确答案:C

  • 第5题：

    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

    • A、The backup status will be marked expired in RMAN recovery catalog.
    • B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
    • C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
    • D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
    • E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

    正确答案:C

  • 第6题：

    You are performing a backup of your database across the network. While taking the backup， you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup？（）

    • A、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET；
    • B、 CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY；
    • C、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET；
    • D、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY；

    正确答案:C

  • 第7题：

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

    B

    Online backup

    C

    consistent backup

    D

    incremental backup

    E

    inconsistent backup


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

  • 第8题：

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

  • 第9题：

    单选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
    A

    The backup status will be marked expired in RMAN recovery catalog.

    B

    The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.

    C

    The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl

    D

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.

    E

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.


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

  • 第10题：

    单选题
    You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？（）
    A

    SQL script

    B

    PL/SQL script

    C

    Operating System （OS） script

    D

    Enterprise Manager （EM） script

    E

    Recovery Manager （RMAN） script


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

  • 第11题：

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

  • 第12题：

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

  • 第13题：

    You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）

    • A、 The backup will not be performed at all.
    • B、 three times
    • C、 four times
    • D、 six times

    正确答案:C

  • 第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?（）

    • 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

  • 第15题：

    You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？ （）

    • A、SQL script
    • B、PL/SQL script
    • C、Operating System （OS） script
    • D、Enterprise Manager （EM） script
    • E、Recovery Manager （RMAN） script

    正确答案:E

  • 第16题：

    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

  • 第17题：

    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

    正确答案:B,C,D

  • 第18题：

    单选题
    You are using Enterprise Manager to schedule backups for your database.  Which type of script wouldbe generated by the backup scheduler（）
    A

    XML script

    B

    PL/SQL script

    C

    Operating system script

    D

    Recovery Manager （RMAN） script


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

  • 第19题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


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

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

  • 第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 work as a database administrator for Supportcenter.cn. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this？（）
    A

    The DBMS_JOB package

    B

    The BACKUP_JOB package

    C

    The DBMS_BACKUP_RESTORE package

    D

    The calendar tool in the Operating System （OS）

    E

    The backup scheduler in Enterprise Manager （EM）

    F

    The DBMS_BACKUP_SCHEDULER packager inline mode


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

  • 第24题：

    单选题
    You configured the default backup device type as disk for RMAN backups. In your database，because of business requirements，you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this？（）
    A

     MAXSETSIZE TO 2

    B

     DEVICE TYPE DISK PARALLELISM 2

    C

     RETENTION POLICY TO REDUNDANCY 2

    D

     DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2


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

相关内容