单选题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?()ARMAN BACKUP DURATION 2:00 MINIMIZE LOAD DATABASEBRMAN BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASECRMAN BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE DRMAN BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD 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 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


参考解析

解析: 暂无解析

相关考题:

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

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

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.

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 DATABASEB、RMAN BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASEC、RMAN BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE D、RMAN BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

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.

How long will this backup be allowed to run?()  Backup as compressed backupset duration 2:00 minimize load databaseA、 2 minutesB、 2 hoursC、 2 daysD、 The command will generate an error.E、 This backup is not constrained by any time limitation.

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.

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 tablespacesB、backup of read­only tablespacesC、backup of system­critical tablespacesD、backup of online, locally managed tablespacesE、backup of read/write dictionary­managed tablespaces

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

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 datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

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.

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 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 SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL

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 cataloglD、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).

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 recoveryB、 complete recoveryC、 recovery using the Flashback Database featureD、 recovery using the export/import utility

You want to perform a backup of your database to tape. Which backup format can you use?()A、backup set onlyB、image copy onlyC、only user-managed backupD、both image copy and backup setE、only incremental image copy backup

单选题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:       RMANBACKUP 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 DBIDD Issue the RECOVER DATABASE command.

单选题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?()ARMAN BACKUP DURATION 2:00 MINIMIZE LOAD DATABASEBRMAN BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASECRMAN BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE DRMAN BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

单选题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 recoveryB complete recoveryC recovery using the Flashback Database featureD recovery using the export/import utility

单选题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?()Abackup database plus archivelogBbackup database plus archivlog until time ‘10:00‘Cbackup database plus archivelog timeout ‘10:00‘Dbackup database plus archivelog duration 10:00

单选题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?()Arestore all the data files from last Sunday’s backup, and then perform a time­based recoveryBrestore all the data files from last Sunday’s backup, and then perform a cancel­based recoveryCrestore all the data files from last Sunday’s backup, and then perform a change­based recoveryDrestore only data files that belong to the SYSTEM tablespace from last Sunday’s backup, and then perform a complete recovery

单选题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?()AThe backup status will be marked expired in RMAN recovery catalog.BThe backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.CThe backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglDThe backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).EThe 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).

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

单选题How long will this backup be allowed to run?()  Backup as compressed backupset duration 2:00 minimize load databaseA 2 minutesB 2 hoursC 2 daysD The command will generate an error.E This backup is not constrained by any time limitation.

单选题You want to perform a backup of your database to tape. Which backup format can you use?()Abackup set onlyBimage copy onlyConly user-managed backupDboth image copy and backup setEonly incremental image copy backup

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

单选题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?()Arecovery cannot be performed because a backup was not performed after the last incomplete recoveryBrestore 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 ThursdayCrestore all the files from Sunday’s backup, and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayDrestore 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