Oracle
1Z0-054 · Question #200
You observed a lot of unused space below the high-water mark for a table. Which three methods could you use to deallocate the unused space? (Choose three.)
The correct answer is A. follow the EXPORT, DROP, and IMPORT method C. follow the EXPORT, TRUNCATE, and IMPORT method D. use MOVE with the ALTER TABLE command to move the table. See the full explanation below for the reasoning.
Question
You observed a lot of unused space below the high-water mark for a table. Which three methods could you use to deallocate the unused space? (Choose three.)
Options
- Afollow the EXPORT, DROP, and IMPORT method
- Buse the DBMS_SPACE.FREE_BLOCKS procedure
- Cfollow the EXPORT, TRUNCATE, and IMPORT method
- Duse MOVE with the ALTER TABLE command to move the table
- Euse DEALLOCATE UNUSED with the ALTER TABLE command
How the community answered
(37 responses)- A78% (29)
- B5% (2)
- E16% (6)
Community Discussion
No community discussion yet for this question.