Oracle Database Administration I — Question 46

Which two are true about shrinking a segment online? (Choose two.)

Answer options

• A. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
• B. It always eliminates all migrated rows if any exist in the table
• C. To shrink a table it must have a PRIMARY KEY constraint
• D. To shrink a table it must have a UNIQUE KEY constraint
• E. To shrink a table it must have row movement enabled
• F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

Correct answer: E, F

Explanation

The correct answers E and F are essential because row movement must be enabled for the shrink operation to function, and the tablespace needs to be using ASSM for effective management. Options A, B, C, and D are incorrect as they either misstate requirements or make incorrect claims about the shrinking process.