Free Oracle 1z0-064 Exam Dumps Questions & Answers

You are administrating a database that supports an OLTP workload. A new application module is deployed that is shipped along with the SQL plan baselines for the SQL statements executed by the application. You load the SQL plan baselines to the SQL Management Base.
Examine the parameters:

Which two statements are true in this scenario?

• A.  The SQL plan baselines are used by the SQL statements and ensure that the best plan is used.
• B.  The SQL plan baselines are loaded but are not used until SQL profiles are generated for the SQL statements.
• C.  The SQL plan baselines are not used by the SQL statements if the optimizer statistics are stale.
• D.  The SQL plan baselines are used but better execution plans may be found and can be evolved manually for the SQL statements.

Which three statements are true about the interpretation of an execution plan? (Choose three.)

• A.  A TABLE ACCESS FULL in the Operation column for a query with a WHERE clause occurs only if no index exists for the filter column.
• B.  The ROWS column indicates the cardinality of each operation and is always calculated by dividing the total number of rows in the table by the number of distinct values in the column used in the WHERE clause predicate.
• C.  A HASH JOIN in the Operation column always implies that two tables are joined by using an equijoin.
• D.  The cost of the entire plan is indicated by the line with Id 0 and always includes both I/O and CPU resources.
• E.  An INDEX UNIQUE SCAN in the Operation column always implies that only one row will be returned.

Examine the partial PLAN_TABLE output:

Which is the correct sequence of execution? (Choose the best answer.)

• A.  3, 2, 4, 1, 0, 2
• B.  3, 2, 1, 4, 0
• C.  0, 4, 1, 3, 2, 1
• D.  0, 1, 2, 3, 4, 1
• E.  3, 2, 4, 1, 0

You are administering a database that supports a mixed workload. The CURSOR_SHARING parameter is set to the default value. While analyzing the latest Automatic Workload Repository (AWR) report, you find a large number of cursor: pin S wait on X, cursor: pin X wait on S, and library cache mutex waits in the Top 10 foreground events section. Examine the Instance Efficiency Percentages section in the AWR report:

Which three statements are true in this scenario? (Choose three.)

• A.  The CPU is spending more time in finding cursors in the library cache.
• B.  Sessions are waiting for mutexes in share mode on cursors but other sessions are holding the mutexes in exclusive mode.
• C.  Sessions are waiting for mutexes in exclusive mode on cursors but other sessions are holding the mutexes in share mode.
• D.  Cursors are not getting shared, resulting in a large number of hard parses.
• E.  The buffers required by queries are not found in the buffer cache, thereby increasing expensive disk I/O.

Examine the Load Profile and partial Top 10 Foreground Events by Total Wait Time sections from an AWR report.


Which two areas should you examine next to identify possible bottlenecks?

• A.  the "SQL ordered by Gets" section of the AWR report to check for excessive logical I/O
• B.  the application code because user calls are performing several queries that require sorting
• C.  the "SQL ordered by Reads" section of the AWR report to check for excessive physical reads
• D.  the application code because of CPU-intensive activities