Oracle Global Human Resources Cloud 2016 Implementation Specialist — Question 1

Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?

Answer options

• A. The customer has Enterprise Manager installed on a separate server and regularly accesses the Database home page of some of its Enterprise Edition databases from its console.
• B. A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer routinely executes awrrpt.sql from the SQLPlus prompt.
• C. A customer has the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter set to DIAGNOSTIC+TUNING.
• D. A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer has SQL scripts that access the database view. DBA_HIST_ACTIVE_SESS_HISTORY
• E. A customer says that he or she doesn't use the Enterprise Manager, but you learn that the customer uses customized SQL scripts that access V$SESSION

Correct answer: C, D

Explanation

The correct answer is C and D because having the CONTROL_MANAGEMENT_PACK_ACCESS set to DIAGNOSTIC+TUNING indicates the use of Oracle Diagnostics Pack. Additionally, accessing DBA_HIST_ACTIVE_SESS_HISTORY suggests the customer is leveraging features within the Diagnostics Pack. Options A, B, and E do not provide sufficient evidence of using the Diagnostics Pack, as they involve either unrelated functionalities or lack direct correlation to the pack's features.