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.

Reference:Oracle Database SQL Language Reference 23ai, "ALTER TABLE ... SHRINK SPACE."