Oracle
1Z0-062 · Question #161
1Z0-062 Question #161: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #161. The question stem and answer options stay visible for context.
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
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.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.