Q98 Examine this command Which two statements are true?

Q98 Examine this command:

SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT

Which two statements are true?

• (A). The high-water mark (HWM) of orders is adjusted.
• (B). Only queries are allowed on ORDERS while the shrink is executing.
• (C). Queries and DML statements are allowed on ORDERS while the shrink is executing.
• (D). The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.
• (E). Dependent indexes become UNUSABLE.
• (F). The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.