READ Free Dumps For Oracle- 1z0-146
| Question ID 2801 | Examine the settings for a user session given below: |
| Option A | A. All query results are stored in the result cache if possible. |
| Option B | B. Query results that are bigger than the available space in the result cache are not cached. |
| Option C | C. Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query. |
| Option D | D. Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in your query. |
| Correct Answer | A,B |
| Question ID 2802 | Which two statements are true about the query results stored in the query result cache? (Choose two.) |
| Option A | A. If any of the tables used to build a query is modified by an ongoing transaction in the current session, the query result is not cached. |
| Option B | B. A query result based on a read-consistent snapshot of data that is older than the latest committed version of the data is not cached. |
| Option C | C. Adding the RESULT_CACHE hint to inline views enables optimizations between the outer query and the inline view, and the query result is cached. |
| Option D | D. A query result for a query that has a bind variable is stored in the cache and is reused if the query is equivalent even when the bind variable has a different value. |
| Correct Answer | A,B |