Database Reference
In-Depth Information
Review Questions
1.
Which of the following initialization parameters have been deprecated in Oracle 12
c
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
2.
Which of the following statements is true regarding the initialization parameter
DIAGNOSTIC_DEST
?
A.
The default value is the value of the environment variable
$ORACLE_HOME
; if
$ORACLE_HOME
isn't set, then the default is set to
$ORACLE_BASE
.
B.
The default value is the value of the environment variable
$ORACLE_BASE
; if
$ORACLE_BASE
isn't set, then it is set to
$ORACLE_HOME
.
C.
DIAGNOSTIC_DEST
is always equal to
$ORACLE_HOME
.
D.
DIAGNOSTIC_DEST
is always equal to
$ORACLE_BASE
.
3.
Which of these formats represents the correct hierarchy for the ADR?
A.
<diagnostic_dest>/rdbms/diag/<dbname>/<instname>
B.
<diagnostic_dest>/diag/rdbms/<instname>/<dbname>
C.
<diagnostic_dest>/diag/rdbms/<dbname>/<instname>
D.
None of the above
4.
Which of the following are not fundamental tasks of the Support Workbench?
(Choose all that apply.)
A.
View long-running SQL workloads.
B.
View problem details.
C.
Gather additional diagnostic information.
D.
Create a service request.
E.
Clean up incident data after upload to Oracle Support.
Search WWH ::
Custom Search