READ Free Dumps For Oracle- 1z0-117
| Question ID 2568 | You ran a high load SQL statement that used an index through the SQL Tuning Advisor and accepted its recommendation for SQL profile creation. Subsequently you noticed that there has been a 2% growth in number of rows in the tables used by the SQL statement and database statistics have also been refreshed. |
| Option A | A. It becomes invalid and no longer used the optimizer. |
| Option B | B. It remains valid and ensures that the optimizer always use the execution plan that was created before the changes happened. |
| Option C | C. It remains and allows the optimizer to pick a different plan required. |
| Option D | D. It becomes invalid and a new SQL profile is created for the statement by the auto tuning task. |
| Correct Answer | C |
| Question ID 2569 | Auto DOP is enabled for your instance. You execute the following statements: |
| Option A | A. Dictionary DOP is used to calculate statements DOP. |
| Option B | B. Hinted DOP is used to calculate statement DOP. |
| Option C | C. The EMPLOYEES table is accessed in parallel. |
| Option D | D. The DEPARTMENTS table is accessed in parallel. |
| Option E | E. The hint operates at the level of each table accessed by the statement. |
| Correct Answer | B,C,E |
