Using a bitmap structure to manage database object space has several benefits over using freelist structures.
Which three are benefits of managing space using automatic segment-space managed objects? (Choose three)
A. It readily responds to dynamic changes for concurrent access.
B. It improves performance and space utilization in a multi-instance environment.
C. It requires fewer space related options than freelist managed structures.
D. It improves performance for SYSTEM tablespaces where a high degree of concurrency is required
Answer: A, C, D
Explanation:
Managing space with automatic segment-space managed objects can respond to dynamic changes for concurrent access, improves performance and space utilization in a multiinstance environment and improves performance for SYSTEM tablespaces where a high degree of concurrency is required.
Incorrect Answers
B: It requires more space related options than freelist managed structures.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 138-140
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 53-54
Chapter 2: Oracle9i Architecture Changes
No comments:
Post a Comment