This preview shows page 1. Sign up to view the full content.
Unformatted text preview: t. Nobody owns a role in Oracle.
A: SYS user does not own any role in Oracle.
C: SYSTEM user does not own any role in Oracle.
D: The creator does not own a role he/she created.
E: The grantee does not own a role he/she have been granted.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 490-495
Chapter 10: Managing Database Use
Which class of segments is most likely to cause the fragmentation in permanent tablespace?
A. Index segments.
B. Rollback segments.
C. User data segments.
D. Temporary segments.
E. Data dictionary segments.
Answer D is correct. Temporary segments are used to handle sort operations that manipulate too
much data to be sorted in memory. Oracle automatically allocates the space when needed. Once
the sort operation is finished, Oracle again automatically deallocates the space. The lifespan of
segments and extents in the TEMPORARY tablespace is incredibly short. Thus, by definition of
usage and lifespan, the TEMPORARY tablespace will have the highest amount of fragmentation
of any tablespace on your databas...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09