Oracle
1Z0-082 · Question #147
Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT Which two statements are true?
The correct answer is C. Queries and DML statements are allowed on ORDERS while the shrink is executing. D. The shrink operation causes rows to be moved to empty space starting from the beginning of the. See the full explanation below for the reasoning.
Manage Storage
Question
Examine this command:
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT Which two statements are true?
Options
- AThe high-water mark (HWM) of orders is adjusted.
- BOnly queries are allowed on ORDERS while the shrink is executing.
- CQueries and DML statements are allowed on ORDERS while the shrink is executing.
- DThe shrink operation causes rows to be moved to empty space starting from the beginning of the
- EDependent indexes become UNUSABLE.
- FThe shrink operation causes rows to be moved to empty space starting toward the end of the
How the community answered
(34 responses)- A3% (1)
- B15% (5)
- C74% (25)
- E6% (2)
- F3% (1)
Topics
#SHRINK SPACE COMPACT#high-water mark#segment management#row movement
Community Discussion
No community discussion yet for this question.