Category: 1Z0-055

Exam 1Z0-055: Oracle Database 11g, New Features for 9i OCPs

The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis

You executed the following PL/SQL block successfully:

VARIABLE tname VARCHAR2(20)

BEGIN

dbms_addm.insert_finding_directive (NULL, DIR_NAME=>’Detail CPU Usage’, FINDING_NAME=>’CPU Usage’,

MIN_ACTIVE_SESSIONS=>0, MIN_PERC_IMPACT=>90);

:tname := ‘database ADDM task4’;

dbms_addm.analyze_db(:tname, 150, 162);

END;

/

Then you executed the following command:

SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;

The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis ____.

Which statement is true if the SQL query in exhibit1 is executed again…

View the Exhibit exhibit1 to examine the series of SQL commands. View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS. Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?


Page 1 of 2012345...1020...Last »