Oracle
1Z0-054 · Question #92
View the Exhibit and examine the content. ALLOCATED_SPACE and FREE_SPACE are not matching with the TABLESPACE_SIZE value. What would you conclude from this?
The correct answer is C. The temporary space allocated to large sort operations is not deallocated. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the content. ALLOCATED_SPACE and FREE_SPACE are not matching with the TABLESPACE_SIZE value. What would you conclude from this?
Exhibit
Options
- AA new temporary file is added to the tablespace.
- BThe temporary space was not sufficient for sort operations.
- CThe temporary space allocated to large sort operations is not deallocated.
- DTEMP_L is a default temporary tablespace because the numbers show some overhead on this
How the community answered
(41 responses)- A17% (7)
- B7% (3)
- C73% (30)
- D2% (1)
Community Discussion
No community discussion yet for this question.
