READ Free Dumps For Oracle- 1z0-020
| Question ID 7754 | A stored outline uses which database feature when creating an execution plan for a SQL statement? |
| Option A | SQL statement hints. |
| Option B | Statement pinning in the large pool. |
| Option C | Statement pinning in the shared pool. D. Automatic analysis of objects to collect |
| Option D | Automatic analysis of objects to collect current statistics. |
| Correct Answer | A |
| Question ID 7755 | Which action can be performed on a composite index partition? |
| Option A | Dropping the partition. |
| Option B | Splitting the partition |
| Option C | Modifying the partition of a global index. |
| Option D | Rebuilding the partition of a local index. |
| Correct Answer | C |