网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）
- A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；
- B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；
- C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
； - D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
；
参考答案
更多 “You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；” 相关考题
考题
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE path;C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE path;D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
考题
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）A、 Open the database in read-only mode.B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.C、 Enable the block change tracking feature.D、 Execute the ALTER DATABASE FLASHBACK ON statement.
考题
You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）A、You must have change tracking enabled in your databaseB、Your database must be running in NOARCHIVELOG modeC、To back up a tablespace, it must be in backup modeD、To back up a tablespace, it must first be taken offline
考题
While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）A、 Block Media Recovery must be used with RMAN.B、 You must perform complete recovery of individual blocks.C、 You must have a full RMAN backup， not an incremental backup.D、 You must use the DBVERIFY utility before using the Block Media Recovery feature.
考题
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）A、 You must enable the block change tracking feature.B、 You must have enable the flashback feature.C、 You must use the OMF in your database.D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
考题
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 want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically， and not have to do it manually. What should you do？（）A、Use the DROP DATAFILE command.B、Use the DROP TABLESPACE command.C、Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.D、Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
考题
Examine the following command used to perform incremental level 0 backup： RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE； To enable the block change tracking， after the incremental level 0 backup you issued the following command： SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command： RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE； Which two statements are true in the above situation？（）A、 The block change tracking data will be used only from the next incremental 0 backup.B、 The incremental backup will use change tracking data for accomplishing the backup.C、 The incremental backup will not use change tracking data for accomplishing the backup.D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
考题
You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）A、 redo log filesB、 password fileC、 control fileD、 change tracking file
考题
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A、 the system change numberB、 the locations of the redo log filesC、 the locations of the datafilesD、 the physical location of all the database changes
考题
To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（） A、 Multiple change tracking files can be created for a database.B、 The change tracking file must be created after the first level 0 backup.C、 RMAN does not support backup and recovery of the change tracking file.D、 The database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.
考题
You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
考题
You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）A、RMAN reads the block change tracking file only when it performs the incremental level 0 backup.B、RMAN reads the block change tracking file when it performs both incremental backups.C、RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D、RMAN does not read the block change tracking file when it performs either incremental backup.
考题
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 when performing incremental backups？（）A、 You need to mention it with every BACKUP command.B、 The block change tracking feature is used automatically by RMAN.C、 You need to configure it using the CONFIGURE command.D、 You need to set the necessary initialization parameters to direct RMAN to use the feature.
考题
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）A、ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C、ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
考题
You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQL FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）A、 You must configure OMF in your database.B、 You must enable block change tracking feature in your database.C、 You must enable ROW MOVEMENT feature on the ORDERS table.D、 You must use the Flashback Version Query before using the Flashback Table feature.
考题
单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）A
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;B
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE path;C
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE path;D
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
考题
单选题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 when performing incremental backups？（）A
You need to mention it with every BACKUP command.B
The block change tracking feature is used automatically by RMAN.C
You need to configure it using the CONFIGURE command.D
You need to set the necessary initialization parameters to direct RMAN to use the feature.
考题
单选题You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A
the system change numberB
the locations of the redo log filesC
the locations of the datafilesD
the physical location of all the database changes
考题
多选题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.
考题
单选题You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQL FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）A
You must configure OMF in your database.B
You must enable block change tracking feature in your database.C
You must enable ROW MOVEMENT feature on the ORDERS table.D
You must use the Flashback Version Query before using the Flashback Table feature.
考题
多选题You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）AOpen the database in read-only mode.BSet the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.CEnable the block change tracking feature.DExecute the ALTER DATABASE FLASHBACK ON statement.
考题
单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）A
You must have change tracking enabled in your databaseB
Your database must be running in NOARCHIVELOG modeC
To back up a tablespace, it must be in backup modeD
To back up a tablespace, it must first be taken offline
考题
单选题You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）A
You must enable the block change tracking feature.B
You must have enable the flashback feature.C
You must use the OMF in your database.D
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
考题
单选题You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）A
redo log filesB
password fileC
control fileD
change tracking file
考题
多选题To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（）AMultiple change tracking files can be created for a database.BThe change tracking file must be created after the first level 0 backup.CRMAN does not support backup and recovery of the change tracking file.DThe database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.
考题
单选题You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature？（）A
ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
热门标签
最新试卷
