多选题You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup?()AThe backup contains data files, the server parameter file,and the control file even if the control file autobackup is disabled.BThe KEEP option overrides the configured retention policy.CThe backup contains only data files and archived redo log files.DThe KEEP option is an attribute of an individual backup piece.

多选题
You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup?()
A

The backup contains data files, the server parameter file,and the control file even if the control file  autobackup is disabled.

B

The KEEP option overrides the configured retention policy.

C

The backup contains only data files and archived redo log files.

D

The KEEP option is an attribute of an individual backup piece.


参考解析

解析: 暂无解析

相关考题:

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 performed an incremental level 0 backup of a database:RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable block change tracking after the incremental level 0 backup, you issued this command:SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’;To perform an incremental level 1 cumulative backup, you issued this command:RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which three statements are true?()A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.B. The change tracking file must always be backed up when you perform a full database backup.C. Block change tracking will always reduce I/O performed during cumulative incremental backups.D. More than one database block may be read by an incremental backup for a change made to a single block.E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN >BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?()A. Corrupted blocks, if any, are repaired.B. Checks are performed for physical corruptions.C. Checks are performed for logical corruptions.D. Checks are performed to confirm whether all database files exist in correct locationsE. Backup sets containing both data files and archive logs are created.

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMANCHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?()A、The backup is deleted.B、The backup is marked unavailable.C、The backup overrides the backup retention policy.D、the backup becomes eligible for deletion according to the existing retention policy

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.()A、To store the backup information of multiple databaseB、To restrict the amount of space that is used by the backupsC、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

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.

Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.

You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?()A、Corrupted blocks, if any, are repaired.B、Checks are performed for physical corruptions.C、Checks are performed for logical corruptions.D、Checks are performed to confirm whether all database files exist in correct locationsE、Backup sets containing both data files and archive logs are created.

You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup?()A、 The backup contains data files, the server parameter file,and the control file even if the control file autobackup is disabled.B、 The KEEP option overrides the configured retention policy.C、 The backup contains only data files and archived redo log files.D、 The KEEP option is an attribute of an individual backup piece.

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 timesC、 four timesD、 six times

It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()A、cannot be used in RMANB、by starting up the database againC、by using the CATALOG command of RMAND、by using the RECOVER CATALOG command in RMANE、by re-creating the target control file to rebuild the RMAN repository

You issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A、 When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B、 When a structural change is made to the database, then a backup of the current control file is performed.C、 When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D、 When a structural change is made to the database, then a backup of the alert log file will be performed.

You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)A、The KEEP option overrides the configured retention policyB、The KEEP option is an attribute of an individual backup pieceC、The backup contains only data files and archived redo log filesD、The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

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 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 while performing the backup operation?()AThe backup as copy can only be taken to diskBThe backup as copy can only be taken to tapeCBackup can be performed only when the instance is shutdownDBackup will constitute all used and unused blocks in the database

多选题You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)AThe KEEP option overrides the configured retention policyBThe KEEP option is an attribute of an individual backup pieceCThe backup contains only data files and archived redo log filesDThe backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

单选题You issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B When a structural change is made to the database, then a backup of the current control file is performed.C When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D When a structural change is made to the database, then a backup of the alert log file will be performed.

多选题You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).AThe backup as copy can only be taken to diskBThe backup as copy can only be taken to tapeCBackup can be performed only when the instance is shutdownDBackup will constitute all used and unused blocks in the database

多选题You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?()ACorrupted blocks, if any, are repaired.BChecks are performed for physical corruptions.CChecks are performed for logical corruptions.DChecks are performed to confirm whether all database files exist in correct locationsEBackup sets containing both data files and archive logs are created.

多选题You performed an incremental level 0 backup of a database: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?()ABackup change tracking will sometimes reduce I/O performed during cumulative incremental backups.BThe change tracking file must always be backed up when you perform a full database backup.CBlock change tracking will always reduce I/O performed during cumulative incremental backups.DMore than one database block may be read by an incremental backup for a change made to a single block.EThe incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

单选题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 recoveryB restore all the files from Sunday’s backup, and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayC 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 SundayD 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

多选题You work as a database administrator for Certkiller .com. You are using Recovery Manager (RMAN) to perform backups in your databases.  Which four backup operations can be performed using RMAN?()AA backup of the target database when it is mountedBA backup of online redo log files when the database is openCA backup of only used data blocks in the file beingbeingbackup upDA backup of online, read/write data files when the database is openEA backup of only those data blocks that have changed since a previous backupFA backup of online, read/write data files when the database is in the NOMOUNT state.

单选题You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.  After some days, you want to change the status of the database backup and you issued the following command:   RMANCHANGE BACKUPSET 231 NOKEEP;   What is the implication of this command?()A The backup is deleted.B The backup is marked unavailable.C The backup overrides the backup retention policy.D the backup becomes eligible for deletion according to the existing retention policy.

单选题Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()AYou need to perform the restore and recover operations manually, because the backup was made manually. BFirst you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. CFirst you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. DYou can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.

单选题It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()Acannot be used in RMANBby starting up the database againCby using the CATALOG command of RMANDby using the RECOVER CATALOG command in RMANEby re-creating the target control file to rebuild the RMAN repository