View the exhibit and examine the TRANS table’s storage information. After a massive delete operation, you
executed the following statement to shrink the TRANS table:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?
Exhibit:
A.
An error is produced.
B.
The table and all related objects are compacted and the position of the high-water mark (HWM) for the table
is adjusted
C.
The table and related indexes are compacted but the position of the high-water mark (HWM) for the table
remains unchanged
D.
The unused space in the table is reclaimed and returned to the tablespace and the data manipulation
language (DML) triggers on the table are fired during the shrinking process