单选题You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）A RMAN> BACKUP DURATIO

题目
单选题
You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）
A

RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE

B

RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE

C

RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE 

D

RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

相似考题

1.You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()A. The backup as copy can only be taken to diskB. The backup as copy can only be taken to tapeC. Backup can be performed only when the instance is shutdownD. Backup will constitute all used and unused blocks in the database

2.You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?（）A、backup database plus archivelogB、backup database plus archivlog until time ‘10:00‘C、backup database plus archivelog timeout ‘10:00‘D、backup database plus archivelog duration 10:00

3.You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）A、A backup of the target database when it is mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online， read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online， read/write data files when the database is in the NOMOUNT state.

4.You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).A. The backup as copy can only be taken to diskB. The backup as copy can only be taken to tapeC. Backup can be performed only when the instance is shutdownD. Backup will constitute all used and unused blocks in the database

更多“单选题You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）A RMAN BACKUP DURATION”相关问题

  • 第1题：

    You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）

    • A、RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE
    • B、RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE
    • C、RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE 
    • D、RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

    正确答案:A

  • 第2题：

    How long will this backup be allowed to run？（）  Backup as compressed backupset duration 2：00 minimize load database

    • A、 2 minutes
    • B、 2 hours
    • C、 2 days
    • D、 The command will generate an error.
    • E、 This backup is not constrained by any time limitation.

    正确答案:B

  • 第3题：

    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

    • A、backup of offline tablespaces
    • B、backup of read­only tablespaces
    • C、backup of system­critical tablespaces
    • D、backup of online， locally managed tablespaces
    • E、backup of read/write dictionary­managed tablespaces

    正确答案:A,B

  • 第4题：

    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

    正确答案:A,E,F

  • 第5题：

    You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?（） (Choose two).

    • A、The backup as copy can only be taken to disk
    • B、The backup as copy can only be taken to tape
    • C、Backup can be performed only when the instance is shutdown
    • D、Backup will constitute all used and unused blocks in the database

    正确答案:A,D

  • 第6题：

    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

  • 第7题：

    You want to perform a backup of your database to tape. Which backup format can you use？（）

    • A、backup set only
    • B、image copy only
    • C、only user-managed backup
    • D、both image copy and backup set
    • E、only incremental image copy backup

    正确答案:A

  • 第8题：

    单选题
    You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）
    A

    RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE

    B

    RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE

    C

    RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE 

    D

    RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE


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

  • 第9题：

    单选题
    You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?（）
    A

    backup database plus archivelog

    B

    backup database plus archivlog until time ‘10:00‘

    C

    backup database plus archivelog timeout ‘10:00‘

    D

    backup database plus archivelog duration 10:00


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

  • 第10题：

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

  • 第11题：

    单选题
    How long will this backup be allowed to run？（）  Backup as compressed backupset duration 2：00 minimize load database
    A

     2 minutes

    B

     2 hours

    C

     2 days

    D

     The command will generate an error.

    E

     This backup is not constrained by any time limitation.


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

  • 第12题：

    单选题
    You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）
    A

     Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.

    B

     Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.

    C

     Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.

    D

     Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.


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

  • 第13题：

    You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）

    • A、 Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.
    • B、 Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.
    • C、 Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.
    • D、 Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.

    正确答案:B

  • 第14题：

    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

    • A、 Backup of offline tablespaces.
    • B、 Backup of read-only tablespaces.
    • C、 Backup of system-critical tablespaces.
    • D、 Backup of online， locally managed tablespaces.
    • E、 Backup of read/write dictionary-managed tablespaces.

    正确答案:A,B

  • 第15题：

    You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation？（）

    • A、 The backup as copy can only be taken to disk
    • B、 The backup as copy can only be taken to tape
    • C、 Backup can be performed only when the instance is shutdown
    • D、 Backup will constitute all used and unused blocks in the database

    正确答案:A,D

  • 第16题：

    What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ；  

    • A、 The entire backup will fail.It will not be usable for recovery.
    • B、 The entire backup will failbut any datafile successfully backed up will be usable for recovery.
    • C、 If this backup fails，subsequent backups will prioritize datafiles not backed up.
    • D、 If this backup fails，an error will be raised and any other commands will not be executed. 
    • E、 If this backup fails，no error will be raised and any other commands will be executed.

    正确答案:B

  • 第17题：

    You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

    • A、 UNTIL SEQUENCE
    • B、 UNTIL SCN
    • C、 UNTIL CHANGE
    • D、 UNTIL CANCEL

    正确答案:C,D

  • 第18题：

    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

    • A、 incomplete recovery
    • B、 complete recovery
    • C、 recovery using the Flashback Database feature
    • D、 recovery using the export/import utility

    正确答案:A

  • 第19题：

    单选题
    You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）
    A

     Start the database in the MOUNT stage.

    B

     Back up the control file to trace.

    C

     Set the DBID

    D

     Issue the RECOVER DATABASE command.


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

  • 第20题：

    单选题
    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）
    A

     incomplete recovery

    B

     complete recovery

    C

     recovery using the Flashback Database feature

    D

     recovery using the export/import utility


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

  • 第21题：

    单选题
    Your database operates in ARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8：30 a.m. With reference to this scenario， what would you do to recover the database？（）
    A

    restore all the data files from last Sunday’s backup， and then perform a time­based recovery

    B

    restore all the data files from last Sunday’s backup， and then perform a cancel­based recovery

    C

    restore all the data files from last Sunday’s backup， and then perform a change­based recovery

    D

    restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery


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

  • 第22题：

    单选题
    What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ；
    A

     The entire backup will fail.It will not be usable for recovery.

    B

     The entire backup will failbut any datafile successfully backed up will be usable for recovery.

    C

     If this backup fails，subsequent backups will prioritize datafiles not backed up.

    D

     If this backup fails，an error will be raised and any other commands will not be executed. 

    E

     If this backup fails，no error will be raised and any other commands will be executed.


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

  • 第23题：

    单选题
    You want to perform a backup of your database to tape. Which backup format can you use？（）
    A

    backup set only

    B

    image copy only

    C

    only user-managed backup

    D

    both image copy and backup set

    E

    only incremental image copy backup


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

  • 第24题：

    单选题
    Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）
    A

    recovery cannot be performed because a backup was not performed after the last incomplete recovery

    B

    restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday

    C

    restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday

    D

    restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday


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

相关内容