- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
81.
Which of the following initialization parameters have been deprecated in Oracle 12c
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 & Explanation
- Report
Answer : [A, C, D]
Explanation :
Explanation :
| FOREGROUND_DUMP_DEST is not a valid initialization parameter, so option B is incorrect. DIAGNOSTIC_DEST is the new parameter that replaces the parameters in options A, C, and D, so E is incorrect. |
82.
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 .
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| When $ORACLE_BASE is set, it is the default value for DIAGNOSTIC_DEST . |
83.
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
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Option A is incorrect because the correct order is diag/rdbms . Option B is incorrect because the correct order is <dbname>/<instname> . |
84.
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.TheGather additional diagnostic information.
- D.Create a service request
- E.Clean up incident data after upload to Oracle Support.
- Answer & Explanation
- Report
Answer : [A, E]
Explanation :
Explanation :
| Options B, C, and D are each fundamental tasks of the Support Workbench problem-resolution process. |
85.
Which of the following tasks does the tool Incident Packaging Service (IPS) perform?
- A.Clean up the ADR by deleting files not associated with an incident uploaded to Oracle Support.
- B.Identify all files associated with a critical error and add them to a zip file to be sent to Oracle Support.
- C.Automatically open a service request with Oracle Support for each critical error and send all relevant files
- D.Display a high-level view of critical errors on the database home page.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Option A is incorrect because IPS does not delete files not associated with a package that will be sent to Oracle Support. Option C is incorrect because IPS does not open an Oracle service request for each critical error. D is incorrect because IPS does not dis- play critical errors on the database home page. |
|
|
||||||||||||||||||||||||||||
