Why would you choose this method?

You observed that some of the queries are performing poorly on the SALES_RECORDS table in
your database.
On further investigation, you find that at the end of each day the contents of the
SALES_RECORDS table are transferred to the SALES table and deleted from the
SALES_RECORDS table. The deleted operations cause the table to be sparsely populated. You
decided to use the ALTER TABLE…SHRINK SPACE COMPACT command to shrink the table.
Why would you choose this method? (Choose all that apply.)

A.
because it can be used during peak hours

B.
because it avoids unnecessary cursor invalidation

C.
because it adjusts the high-water mark (HWM) immediately

D.
because you have long-running queries that might span the shrink operation

E.
because it does not allow any data manipulation language (DML) operations, thereby making
the shrink operation faster