OCP-1Z0-053-200题-147题-59

QUESTION 147

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;

Answer: C

同59题：http://blog.csdn.net/rlhua/article/details/11822293

Explanation/Reference:

Section: Backup, Recovery & Recovery Manager (RMAN)

You should use the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

statement. If OMF is configured in your database, then you need not specify the name of the block change

tracking file in the ALTER DATABASEstatement. The file is automatically located in the directory specified by

the DB_CREATE_FILE_DESTparameter. In this scenario, OMF is not configured. Therefore, you must specify

the location of the block change tracking file in the statement. After you enable block change tracking, RMAN

uses the block change tracking file to determine the blocks the blocks that have changed and should bebacked

up in an incremental backup. This improves the performance because RMAN does not have to scan the entire

datafiles during backup. RMAN backs up only the changed blocks and skips the unchanged blocks.

The options stating that you should issue the ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;or the

ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;statements are incorrect.

Each of these statements will generate an error because the block change tracking feature is enabled atthe

database level, not at the system level.

The option stating that you should issue the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

statement is incorrect because OMF is not configured in the database. If OMF is not configured, then you must

specify the location of the block change tracking file in the ALTER DATABASE ENABLE BLOCK CHANGE

TRACKING;statement.