Which alter TABLE option would you recommend?

You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following: i.Long-running queries are not affected. ii.No extra space is used. iii.Data manipulation language (DML) operations on the table succeed at all times throughout the process. iv.Unused space is reclaimed both above and below the high water mark.Which alter TABLE option would you recommend?

Question:

Which alter TABLE option would you recommend?

Options:

DEALLOCATE UNUSED

SHRINK SPACE CASCADE

SHRINK SPACE COMPACT

ROW STORE COMPRESS BASIC

Correct Answer

The Correct Answer for this Question is

DEALLOCATE UNUSED

You may also like...

Leave a Reply

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