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.

相关问题推荐

• Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）

  A、 Disable SQL tracing for the APPS tablespace.

  B、 Disable logging attributes for the APPS tablespace.

  C、 Modify the tablespace to be a dictionary-managed tablespace.

  D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.

  E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.

  查看答案

• You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）

  A、 DB_RECOVERY_FILE_DEST only

  B、 DB_FLASHBACK_RETENTION_TARGET only

  C、 DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only

  D、 DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only

  E、 DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST and

  F、 DB_FLASHBACK_RETENTION_TARGET

  查看答案

• In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

  A、 when all the online redo log groups are multiplexed and one of the members of a group is missing

  B、 when all the online redo log groups are not multiplexed and one log group is missing

  C、 when all the control files are missing

  D、 when some important tables are deleted from the database and purged from the Recycle Bin

  查看答案

• 下列程序的运行结果为 #include＜iostream.h＞ template＜class TT＞ class FF {TT a1，a2，a3； public： FF(TT b1，TT b2，TT b3){a1＝b1；a2=b2；a3＝b3；} TT Sum(){return a1+a2+a3；}}； void main() { FF＜int＞x(int(1.1)，2，3)，y(int(4.2)，5，6)； cout＜＜x.Sum()＜＜‘‘＜

  A．6.1 15.2

  B．6 15

  C．6 15.2

  D．6.1 15

  查看答案

• You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

  A、 Memory Advisor

  B、 Segment Advisor

  C、 SQL Access Advisor

  D、 Automatic Workload Repository （AWR）

  E、 Automatic Database Diagnostic Monitor （ADDM）

  查看答案