Oracle
1Z0-043 · Question #137
1Z0-043 Question #137: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-043 to reveal the answer and full explanation for question #137. The question stem and answer options stay visible for context.
Question
In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?
Options
- AREBUILD
- BCASCADE
- CTRUNCATE
- DROW MOVEMENT
- ESHRINK SPACE COMPACT
- FSHRINK SPACE CASCADE
Unlock 1Z0-043 to see the answer
You've previewed enough free 1Z0-043 questions. Unlock 1Z0-043 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.