Which four statements represent features of the segment shrink operation?

Prev Question
Next Question

Which four statements represent features of the segment shrink operation? (Choose four.)

A.
The shrink operation decreases the size of the tablespace.

B.
The shrink operation reclaims wasted space in a tablespace.

C.
In a shrink operation, data is compacted to the end of the table.

D.
In a shrink operation, data is compacted to the front of the table.

E.
Data Manipulation Language (DML) operations can be performed on a table while a shrink operation is in progress.

F.
DML operations cannot be performed on a specified table while a shrink operation is in progress.

G.
The shrink operation returns free space to the tablespace or retains it in the table for future inserts.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *