You issue the following command to enable block change tracking: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; However, you receive an error message, and the tracking file is not created. What is a possible reason for the error message?
Answer: D
Explanation: Unless you explicitly specify a location for the block change tracking file using the USING FILE clause, the file is created using Oracle Managed Files (OMF), which requires a destination in the parameter DB_CREATE_FILE_DEST. A is incorrect because DB_RECOVERY_FILE_DEST specifies the location of the flash recovery area. B is incorrect because the tracking file is created at the database level, not the system level. C is incorrect because you can create the tracking file when the database is OPEN; however, to rename the tracking file, the database must be in the MOUNT state.