Which activity is performed when the preceding command …

Examine the following command:
SQL> ALTER TABLE booking SHRINK SPACE COMPACT;
Which activity is performed when the preceding command is executed?

Examine the following command:
SQL> ALTER TABLE booking SHRINK SPACE COMPACT;
Which activity is performed when the preceding command is executed?

A.
The shrink operation touches every block in the BOOKING table

B.
The high-water mark (HWM) for the BOOKING table is shifted from its original position

C.
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

D.
The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink
operation is internally handled by the INSERT/DELETE operation



Leave a Reply 0

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