Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?

A. Dependent indexes become UNUSABLE.False. SHRINK SPACE COMPACT does not affect index usability; only SHRINK SPACE without COMPACT may require index maintenance if CASCADE is omitted.

B. ... starting toward the end of the ORDERS segment.False. Rows are compacted toward the beginning of the segment, not the end.

C. Only queries are allowed ...False. Both queries and DML are allowed during SHRINK SPACE COMPACT as it’s an online operation.

D. The high-water mark (HWM) of ORDERS is adjusted.False. COMPACT moves rows but doesn’t adjust the HWM; the full SHRINK SPACE command is needed for HWM adjustment.

E. Queries and DML statements are allowed ...True. This is an online operation in 23ai, allowing concurrent access.

F. ... starting from the beginning of the ORDERS segment.True. Rows are moved to fill free space from the segment’s start.