READ Free Dumps For Oracle- 1z0-117
| Question ID 2597 | Which statement is true about an automatic SQL task? |
| Option A | A. It will attempt to tune the currently running SQL statements that are highly resource intensive. |
| Option B | B. It will automatically implement new SQL profiles for the statements that have existing SQL profiles. |
| Option C | C. It will attempt to tune all-long-running queries that have existing SQL profiles. |
| Option D | D. It will automatically implement SQL profiles if a three-fold benefit can be achieved and automatic profile implementation is enabled. |
| Option E | E. It will tune all the top SQL statements from AWR irrespective of the time it takes to complete the task in a maintenance window. |
| Correct Answer | D |
| Question ID 2598 | Examine the exhibit. |
| Option A | A. No partition-wise join is used |
| Option B | B. A full partition-wise join is used |
| Option C | C. A partial partition-wise join is used |
| Option D | D. The SALES table is composite partitioned |
| Correct Answer | B,D |
