Oracle Exam 1Z0-062 Topic 7 Question 44 Discussion

Actual exam question for Oracle's 1Z0-062 exam

Question #: 44
Topic #: 7

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?

AEnsure free space that is approximately equal to the space used by the table should be available.

BEnsure there are no pending transactions on the table.

CEnable row movement is enabled.

DDisable all indexes on the table.

Show Suggested Answer

Suggested Answer: C

by Alease at May 06, 2022, 09:46 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!