Oracle Database Administration I — Question 110

Examine this command:

SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT

Which two statements are true? (Choose two.)

Answer options

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

Correct answer: A, B

Explanation

Option A is correct because the SHRINK operation does indeed move rows to empty space starting from the beginning of the segment. Option B is also correct as DML statements and queries can be executed while the SHRINK operation is in progress. Options C and D are incorrect because dependent indexes do not necessarily become UNUSABLE and both DML and queries are allowed during the operation. Options E and F are incorrect as the high-water mark is adjusted, but rows are not moved towards the end of the segment.