READ Free Dumps For Oracle- 1z0-117
| Question ID 2603 | You are administering a database that supports an OLTP workload in which one of the applications inserts rows in a table until 12 noon every, after which multiple years perform frequent queries on the table. You want the statistics to be more representative of the table population. |
| Option A | A. Set the STALE_PERCENT preference to 0. |
| Option B | B. Set the OPTIMIZER_MODE parameter to ALL_ROWS. |
| Option C | C. Set the OPTIMIZER_DYNAMIC_SAMPLING parameter to 0. |
| Option D | D. Use the FIRST_ROWS_n hint in the queries. |
| Option E | E. Unlock and gather statistics for the table after inserts are done and lock them again. |
| Correct Answer | E |
| Question ID 2604 | Examine the query: |
| Option A | A. The SQL runtime environment checks whether the query result is cached in the result cache; if the result exists, the optimizer fetches the result from it. |
| Option B | B. The SQL runtime environment does check for the query result in the result cache because the RESULT_CACHE_MODE parameter is set to MANUAL. |
| Option C | C. The SQL runtime environment checks for the query result in the result cache only when the query is executed for the second time. |
| Option D | D. If the query result does not exist in the cache and the query is executed, the result is generated as output, and also sorted in the result cache. |
| Correct Answer | A,D |
