Which four statements represent features of the segment shrink operation?

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

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.



Leave a Reply 1

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


networkmanagers

networkmanagers

I have the same idea. BDEG