READ Free Dumps For Oracle- 1z0-117
| Question ID 2516 | When would bind peeking be done for queries that vary only in values used in the WHERE clause? |
| Option A | A. When the column used in the WHERE clause has evenly distributed data and histogram exists on that column. |
| Option B | B. When the column used in the WHERE clause has evenly distributed data and index exists on that column. |
| Option C | C. When the column used in the WHERE clause has non uniform distribution of data, uses a bind variable, and no histogram exists for the column. |
| Option D | D. When the column used in the WHERE clause has non uniform distribution of data and histogram exists for the column. |
| Correct Answer | A,D |
| Question ID 2517 | Which type of SQL statement would be selected for tuning by the automatic SQL framework? |
| Option A | A. Serial queries that are among the costliest in any or all of the four categories: the past week, any day in the past week, any hour in the past week, or single response, and have the potential for improvement |
| Option B | B. Serial queries that have been tuned within the last 30days and have been SQL profiled by the SQL tuning Advisor. |
| Option C | C. Serial and parallel queries that top the AWR Top SQL in the past week only and have been SQL profiled by the SQL Tuning Advisor. |
| Option D | D. Serial queries that top the AWR Top SQL in the past week only and whose poor performance can be traced to concurrency issues. |
| Option E | E. Serial and parallel queries that are among the costliest in any or all of the four categories: the past week, and day in the past week, any hour in the past week, or a single response, and that can benefit from access method changes. |
| Correct Answer | A |