CMS专题
单选题You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature wh
题目
You need to mention it with every BACKUP command.
The block change tracking feature is used automatically by RMAN.
You need to configure it using the CONFIGURE command.
You need to set the necessary initialization parameters to direct RMAN to use the feature.
相似问题和答案
第1题：
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）
- A、 RBAL
- B、 CKPT
- C、 SMON
- D、 PMON
- E、 MMON
- F、 CTWR
- G、 DBWR
正确答案:F
第2题：
Which two statements are true regarding the database in ARCHIVELOG mode？（）
- A、You have to shut down the database to perform the backups.
- B、Archiving information is written to the data files and redo log files.
- C、You can perform complete database backups without closing the database.
- D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
- E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
正确答案:C,E
第3题：
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
第4题：
You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）
- A、The backups would be consistent.
- B、The backups would be inconsistent.
- C、The backups would be possible only if the database is running in ARCHIVELOG mode.
- D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
- E、The backups need to be restored and the database has to be recovered in case of a media failure
正确答案:B,C,E
第5题：
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
第6题：
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
正确答案:C
第7题：
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）
- A、You must shut down the database instance to perform the backups.
- B、You must configure the Flash Recovery Area （FRA） for the database.
- C、You can perform complete database backups without closing the database.
- D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
正确答案:C,D
第8题：
You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?（）
A. The source database should be open
B. The target database should be in ARCHIVELOG mode if it is open
C. RMAN should be connected to both the instances as SYSDBA
D. The target database backups should be copied to the source database backup directories
E. The password file must exist for the source database and have the same SYS user password as the target
第9题：
You are managing an Oracle Database 11g database with this backup strategy： - Every Sunday night， level 0 backup is performed. - On Monday night and subsequent days， level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday’s backup is true（）
- A、The backup contains all the used blocks.
- B、The backup contains all the used and unused blocks.
- C、The backup contains blocks that have changed since the last level 0 backup.
- D、The backup contains blocks that have changed since the last level 1 backup taken last week.
正确答案:C
第10题：
You are managing an Oracle Database 11g database with the following backup strategy：1） On Sunday， an incremental level 0 tape backup is performed.2） Monday through Saturday， a cumulative incremental level 1 tape backup is performed. Which twostatements are true regarding the backups performed（）
- A、The backup performed in step 1 backs up all blocks that have ever been in use in the database.
- B、The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
- C、The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
- D、The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1
正确答案:A,B