READ Free Dumps For Oracle- 1z0-117
| Question ID 2623 | You want to run SQL Tuning Advisor statements that are not captured by ADDM, AWR, and are not in the library cache. |
| Option A | A. Enable SQL plan management |
| Option B | B. Create a SQL plan baseline for each query |
| Option C | C. Create a SQL Tuning Set (STS) containing the SQL statements |
| Option D | D. Gather statistics for objects used in the application |
| Correct Answer | C |
| Question ID 2624 | While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for a statement that has stale statistics. Automatic optimizer statistics is enabled for the database. |
| Option A | A. Updates the existing SQL profiles for which the statistics are stale. |
| Option B | B. Makes the statistics information available to GATHER_DATABASE_STATS_JOB_PROC |
| Option C | C. Starts the statistics collection process by running GATHER_STATS_JOB |
| Option D | D. Writes a warning message in the alert log file |
| Correct Answer | B |