Oracle Global Human Resources Cloud 2016 Implementation Specialist — Question 11

Which is a true statement about the difference in the functionality of Active Session History (ASH) and SQL Trace/TKPROF?

Answer options

• A. ASH provides time based data, SQL Trace/TKPROF does not
• B. ASH provides detailed session level data, SQL Trace/TKPROF does not
• C. ASH is always on, SQL Trace/TKPROF is not
• D. ASH identifies Bind variables that are available, SQL Trace/TKPROF does not
• E. ASH counts and has occurrence data, SQL Trace/TKPROF does not

Correct answer: B

Explanation

The correct answer is B because ASH specifically captures detailed session-level data, allowing for better analysis of user sessions. The other options are incorrect because ASH does provide time-based data (A), it is not always on as SQL Trace can be configured to run (C), both can identify Bind variables under certain conditions (D), and SQL Trace/TKPROF can also provide occurrence data (E).