READ Free Dumps For Oracle- 1z0-117
| Question ID 2599 | You are working on a database that supports an OLTP workload. You see a large number of hard parses occurring and several almost identical SQL statements in the library cache that vary only in the literal values in the WHERE clause conditions. |
| Option A | A. Replace literals with bind variables and evolve a baseline for the statement. |
| Option B | B. Use the RESULT_CACHE hint in the queries. |
| Option C | C. Create baselines for the almost identical SQL statement by manually loading them from the cursor cache. |
| Option D | D. Set the CURSOR_SHARING parameter to SIMILAR. |
| Correct Answer | A,D |
| Question ID 2600 | You are administering a database that supports an OLTP workload. Automatic optimizer statistics collection is scheduled in the night maintenance window. Some of the tables get updated frequently during day time and you notice a performance degradation for queries using those tables due to stale statistics. |
| Option A | A. Set the global statistics preference STALE_PERCENT to 0. |
| Option B | B. Use dynamically sampling hint for the queries on frequently updated tables. |
| Option C | C. Create histogram for the columns used frequently in the WHERE clause. |
| Option D | D. Gather statistics with global statistics preference NO_VALIDATE to TRUE. |
| Option E | E. Set the OPTIMZER_USE_PENDING_STATISTICS parameter to TRUE. |
| Correct Answer | B,C |