DS0-001 Data Systems Management Practice Question
In an Oracle Database environment, a DBA identifies that specific queries are performing poorly due to fragmented tables. Which command should the DBA execute to reclaim unused space and defragment the table without dropping the table structure?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
ALTER TABLE ... SHRINK SPACE
The ALTER TABLE ... SHRINK SPACE command is the standard way to defragment and reclaim space in an Oracle table while maintaining the table's structure and indexes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
ALTER TABLE ... SHRINK SPACE
Why this is correct
This command compacts the table segments and lowers the high water mark to reclaim space.
- ✗
TRUNCATE TABLE
Why it's wrong here
Truncate removes all rows and resets the high water mark but deletes all data.
- ✗
ANALYZE TABLE ... COMPUTE STATISTICS
Why it's wrong here
This updates statistics for the optimizer but does not reclaim physical space.
- ✗
DROP AND RECREATE
Why it's wrong here
This is a destructive operation that requires complex downtime for data migration.
Visual reference
About these practice questions
One of 216 original DS0-001 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official CompTIA exam blueprint
This DS0-001 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DS0-001 exam.