393.Which of the following initialization parameters have been deprecated in Oracle 11g because of the
introduction of the Automatic Workload Repository? (Choose all that apply.)
A. BACKGROUND_DUMP_DEST
B. FOREGROUND_DUMP_DEST
C. CORE_DUMP_DEST
D. USER_DUMP_DEST
E. DIAGNOSTIC_DEST
F. All of the above
Answer: ACD
答案解析：
Beginning with Release 11g of Oracle Database, because all diagnostic data, including the alert log, are stored in the ADR, the initialization
parameters BACKGROUND_DUMP_DEST and USER_DUMP_DEST are
deprecated. They are replaced by the initialization parameter DIAGNOSTIC_DEST, which identifies the location of the ADR.
sys@TEST1107> select * from v$diag_info;
INST_ID NAME VALUE
---------- ------------------------------ ------------------------------------------------------------
1 Diag Enabled TRUE
1 ADR Base /u01/app/oracle
1 ADR Home /u01/app/oracle/diag/rdbms/test1107/test1107
1 Diag Trace /u01/app/oracle/diag/rdbms/test1107/test1107/trace
1 Diag Alert /u01/app/oracle/diag/rdbms/test1107/test1107/alert
1 Diag Incident /u01/app/oracle/diag/rdbms/test1107/test1107/incident
1 Diag Cdump /u01/app/oracle/diag/rdbms/test1107/test1107/cdump
1 Health Monitor /u01/app/oracle/diag/rdbms/test1107/test1107/hm
1 Default Trace File /u01/app/oracle/diag/rdbms/test1107/test1107/trace/test1107_ora_30633.trc
1 Active Problem Count 0
1 Active Incident Count 0
11 rows selected.