nerdexam
Oracle

1Z0-062 · Question #161

Examine the structure of the sales table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled. You want to perform online segment shrink to reclaim f

The correct answer is A. Row movement is enabled.. Online segment shrink requires row movement to be enabled on the table so Oracle can relocate rows to compact the segment below the high water mark.

Managing Database Storage Structures

Question

Examine the structure of the sales table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled. You want to perform online segment shrink to reclaim fragmented free space below the high water mark. What should you ensure before the start of the operation?

Exhibit

1Z0-062 question #161 exhibit

Options

  • ARow movement is enabled.
  • BReferential integrity constraints for the table are disabled.
  • CNo queries are running on this table.
  • DExtra disk space equivalent to the size of the segment is available in the tablespace.
  • ENo pending transaction exists on the table.

How the community answered

(36 responses)
  • A
    86% (31)
  • C
    6% (2)
  • D
    6% (2)
  • E
    3% (1)

Why each option

Online segment shrink requires row movement to be enabled on the table so Oracle can relocate rows to compact the segment below the high water mark.

ARow movement is enabled.Correct

Online segment shrink physically moves rows toward the beginning of the segment and then resets the high water mark; because row addresses (rowids) change during this process, Oracle requires row movement to be explicitly enabled via ALTER TABLE ... ENABLE ROW MOVEMENT before the operation can proceed.

BReferential integrity constraints for the table are disabled.

Referential integrity constraints do not need to be disabled because segment shrink moves rows within the same table without altering the data values that foreign keys reference.

CNo queries are running on this table.

Online segment shrink is specifically designed to run concurrently with queries and DML; the table does not need to be idle.

DExtra disk space equivalent to the size of the segment is available in the tablespace.

Segment shrink reclaims and reuses space within the existing segment rather than creating a copy, so no additional free space equal to the segment size is required.

ENo pending transaction exists on the table.

Pending transactions are not a blocking prerequisite; the online shrink operation handles row-level concurrency internally and does not require a transaction-free table.

Concept tested: Oracle online segment shrink row movement prerequisite

Source: https://docs.oracle.com/database/121/ADMIN/schema.htm#ADMIN13357

Topics

#Segment shrink#Online operations#ASSM#Row movement

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice