READ Free Dumps For Oracle- 1z0-020
| Question ID 8215 | What does using the package DBMS_RESOURCE_MANAGER enable you to do? |
| Option A | Dynamically change profiles assigned to sets of users. |
| Option B | Limit the degree of parallelism on a given set of tables. |
| Option C | Guarantee a minimum degree of parallelism to a set of users. |
| Option D | Distribute available processing resources among sets of users. |
| Option E | Guarantee certain sets of users a minimum amount of disk space. |
| Correct Answer | C |
| Question ID 8216 | Which two statements are true? (Choose two) |
| Option A | Composite partitioning supports partition-wise dumps. |
| Option B | Composite partitioning improves performance for parallel DML. |
| Option C | Composite partitioning is used primarily in OLTP environments. |
| Option D | Composite partitioning allows more granular partition elimination. |
| Correct Answer | A,B |