Oracle
1Z0-082 · Question #22
Which two are true about shrinking a segment online? (Choose two.)
The correct answer is C. To shrink a table it must have a PRIMARY KEY constraint E. To shrink a table it must have row movement enabled. https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
New Features for Storage
Question
Which two are true about shrinking a segment online? (Choose two.)
Options
- AIt is not possible to shrink either indexes or Index Organized Tables (IOTs)
- BIt always eliminates all migrated rows if any exist in the table
- CTo shrink a table it must have a PRIMARY KEY constraint
- DTo shrink a table it must have a UNIQUE KEY constraint
- ETo shrink a table it must have row movement enabled
- FIt must be in a tablespace that uses Automatic Segment Space Management (ASSM)
How the community answered
(42 responses)- A7% (3)
- B2% (1)
- C71% (30)
- D17% (7)
- F2% (1)
Explanation
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
Topics
#online segment shrink#ASSM#row movement#segment space management
Community Discussion
No community discussion yet for this question.