1Z0-082 practice question 12 of 25
Which two are true about shrinking a segment online? (Choose two.)
Full set: 142 questionsOnline segment shrinking is a feature used to reclaim fragmented free space below the high water mark of a segment. For this operation to be possible, two main prerequisites must be met. First, the segment must reside in a tablespace that is managed with Automatic Segment Space Management (ASSM). Second, because the shrink operation compacts data by moving rows to new locations, row movement must be explicitly enabled on the target table using the ALTER TABLE ... ENABLE ROW MOVEMENT command.
A. It is possible to shrink indexes and Index-Organized Tables (IOTs), not just heap-organized tables.
B. While shrinking is effective at eliminating migrated rows by moving them, using the word "always" is too strong; its primary goal is space reclamation.
C. A PRIMARY KEY constraint is not a prerequisite for shrinking a table segment.
D. A UNIQUE KEY constraint is not a prerequisite for shrinking a table segment.
1. Oracle Database Administrator's Guide, 19c. Chapter 21, "Managing Space for Schema Objects". Section: "Reclaiming Wasted Space". It states, "You can shrink space in a table, index-organized table, index, partition, subpartition, materialized view, or materialized view log" and "Segment shrink is not supported for segments in tablespaces that are not locally managed, or for segments in locally managed tablespaces that do not use automatic segment space management (ASSM)."
2. Oracle Database SQL Language Reference, 19c. ALTER TABLE command, shrinkclause. The documentation notes: "This clause is valid only for segments in tablespaces with automatic segment management." and "Before you issue this statement...you must enable row movement in the table you want to shrink."
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 2Which three statements are true about advanced connection options supported by Oracle Net…
- Question 3Which statement is true about the INTERSECT operator used in compound queries?
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 7In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespace…
