Exhibit 1-5:
View the exhibit and examine the sparsely populated EMP table segment.
You execute the following SQL command:
ALERT TABLE emp SHRINK SPACE
Identify how the data in the segment will be reorganized as a result of the above statement.
A.
Exhibit 1.
B.
Exhibit 2.
C.
Exhibit 3
D.
Exhibit 4
E.
Exhibit 5
Explanation:
Segment shrink reclaims unused space both above and below the high water mark. In contrast, space deallocation reclaims unused space only above the high water mark. In shrink operations, by default, the database compacts the segment, adjusts the high water mark, and releases the reclaimed space.
REF.: Oracle(r) Database Administration Guide,14-28