nerdexam
Oracle

1Z0-063 · Question #173

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the space usage has reached…

The correct answer is D. The statistics_level parameter is set to basic. See the full explanation below for the reasoning.

Question

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?

Options

  • AThe event parameter was not set.
  • BThe sql_trace parameter is set to false.
  • CEnterprise Manager was not used.
  • DThe statistics_level parameter is set to basic.
  • EThe t:kid_statistics parameter is set to false.

How the community answered

(28 responses)
  • B
    4% (1)
  • C
    7% (2)
  • D
    79% (22)
  • E
    11% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice