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
it should be ADR instead of AWR
BACKGROUND_DUMP_DEST is not deprecated in 11GR2.
CORE_DUMP_DEST is not deprecated in 11GR2.
Only USER_DUMP_DEST is deprecated.
Please check yourself in the 11gr2 documentation.
I made a mistake …. according to
http://oracle.su/docs/11g/install.112/e10813/whatsnew.htm
The initialization parameters BACKGROUND_DUMP_DEST and USER_DUMP_DEST are deprecated. They continue to be set, but you should not set these parameters manually.