Exam information

Exam 1Z0-054: Oracle Database 11g, Performance Tuning

Other exams

Which two statements are true about the execution plan?


Examine the SQL statement given below:SQL> EXPLAIN PLAN forSELECT department_name,count(*)FROM hr.employees e, hr.departments dWHERE e.department_id=d.department_idGROUP BY d.department_name;To view the execution plan for the statement, you queried plan_table. View the Exhibit and examine […]

What would this command accomplish?

You identified a SQL statement with SQL ID 9g485acn2n30m, which is expensive on the resources. To view the execution plan for the statement, you executed the following command:SQL> SELECT * FROM TABLE(dbms_xplan.display_cursor(‘9g485acn2n30m’,1)); What would this command accomplish?

Which two conclusions can you draw from the statistics?

View the Exhibit and examine the statistics of a SQL statement.Which two conclusions can you draw from the statistics? (Choose two.)Exhibit:

What do you infer from the results?

You noticed a high number of SQL statements with the same PLAN_HASH_VALUES.View Exhibit1 to see the details.View Exhibit2 to see the details of the SQL text for the statements.What do you infer from the results?Exhibit 1 (exhibit):Exhibit 2 (exhibit):

Why is the sample count reduced in the second report?

View the Exhibit and examine portions of two ASH reports generated for the same time period. The second report was generated after the ASH data is flushed to disk.Why is the sample count reduced in the second report?Exhibit:


Which action would you suggest after analyzing the output?

View Exhibit1 and examine a portion of Active Session History(ASH) report.View Exhibit2 to examine the tablespaces.Which action would you suggest after analyzing the output?Exhibit 1 (exhibit):Exhibit 2 (exhibit):

Which statement describes the result after finishing this quick configuration process?

View the Exhibit and note the workload type selected to quickly configure the metric threshold.Which statement describes the result after finishing this quick configuration process?Exhibit:

Which two can be inferred from the output?

View the Exhibit and analyze a portion of the Active Session History (ASH) report marked with a red rectangle.Which two can be inferred from the output? (Choose two.)Exhibit:

Which statement is true about the report?

View the Exhibit and examine the sample Automatic Database Diagnostic Monitor (ADDM) report.Which statement is true about the report?Exhibit:

What is the significance of the Benefit(%) column in the Exhibit?

After an Automatic Database Diagnostic Monitor (ADDM) run, you receive a recommendation for buffer busy wait issue. View the Exhibit.What is the significance of the Benefit(%) column in the Exhibit?Exhibit:

Page 1 of 1912345...10...Last »