READ Free Dumps For Oracle- 1z0-117
| Question ID 2615 | Identify two situations in which full table scans will be faster than index range scans. |
| Option A | A. A query with a highly selective filter fetching less than 5 percent of the rows from a table. |
| Option B | B. A highly selective query on a table having high clustering factor for an index. |
| Option C | C. A query fetching less number of blocks than value specified by DB_FILE_MULTIBLOCK_READ_COUNT. |
| Option D | D. A query executing in parallel on a partitioned table with partitioned indexes. |
| Option E | E. A query on a table with sparsely populated table blocks. |
| Correct Answer | C,D |
| Question ID 2616 | You are administering a database, where an application frequently executes identical SQL statements with the same syntax. |
| Option A | A. By setting the CURSOR_SHARING parameter to FORCE. |
| Option B | B. By using the bind variables and setting the CURSOR_SHARING parameter to EXACT. |
| Option C | C. By using the CACHE hint to pin the queries in the library cache |
| Option D | D. By ensuring that RESULT_CACHE_MODE parameter is set to MANUAL and using the RESULT_CACHE hint in the queries. |
| Option E | E. By creating a SQL plan baseline for the identical statements. |
| Correct Answer | D |