This preview shows page 1. Sign up to view the full content.
Unformatted text preview: : Managing the Physical Database Structure
Which statement about organizing tablespaces and segments is true?
A. You should mix segments with short and long life spans in the same tablespace.
B. You should keep good control over space allocation and define storage limits for users.
C. You should use the autoextend feature on tablespaces that have a high update, delete, and
D. Data that is accesses by multiple users should be stored in tablespaces that reside on the same
disk for easier management.
Answer B is correct. You can control space allocation and define storage limits for users by
A: You should not mix segments with short and long spans in the same tablespace.
C: You need to avoid AUTOEXTEND feature for tablespaces with high level activity, like
inserts, updates and deletes.
D: You should reside datafiles of tablespaces on different disks for better database performance.
Oracle 8, DBA Certification Ex...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09