nerdexam
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

1Z0-054 question #92 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)
  • A
    17% (7)
  • B
    7% (3)
  • C
    73% (30)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice