Oracle
1Z0-062 · Question #352
1Z0-062 Question #352: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #352. The question stem and answer options stay visible for context.
Managing Schema Objects
Question
Examine the details of the uncompressed, non-partitioned heap table CITIES. Examine the command: SQL> ALTER TABLE cities SHRINK SPACE COMPACT; What must you do before executing it?
Exhibit
Options
- AEnsure free space that is approximately equal to the space used by the table should be
- BEnsure there are no pending transactions on the table.
- CEnable row movement is enabled.
- DDisable all indexes 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.
Topics
#table management#SHRINK SPACE#row movement