Posts

Showing posts with the label 1z0-020 Oracle8i: New Features for Administrators Part 3

1z0-020 Oracle8i: New Features for Administrators Part 3

Oracle8i: New Features for Administrators Part 3 Get Full version on: http://www.getfreedumps.com/ QUESTION 21 What does using the package DBMS_RESOURCE_MANAGER enable you to do? A. Dynamically change profiles assigned to sets of users. B. Limit the degree of parallelism on a given set of tables. C. Guarantee a minimum degree of parallelism to a set of users. D. Distribute available processing resources among sets of users. E. Guarantee certain sets of users a minimum amount of disk space. Correct Answer: C Section: (none) Explanation Explanation/Reference: QUESTION 22 Which two statements are true? (Choose two) A. Composite partitioning supports partition-wise dumps. B. Composite partitioning improves performance for parallel DML. C. Composite partitioning is used primarily in OLTP environments. D. Composite partitioning allows more granular partition elimination. Correct Answer: AB Section: (none) Explanation Explanation/Referenc...