Which two statements are true?

In your database, the locally managed tablespace,USERS, has the default space usage alert
set to 85% for the warning level and 97% for the critical level. Which two statements are
true? (Choose two.)

In your database, the locally managed tablespace,USERS, has the default space usage alert
set to 85% for the warning level and 97% for the critical level. Which two statements are
true? (Choose two.)

A.
Alerts are recorded in both Oracle Enterprise Manager Cloud Control
andDBA_OUTSTANDING_ALERTSonly when the critical threshold is exceeded.

B.
Alert settings for the warning and critical levels must be disabled before taking
theUSERStablespace offline.

C.
Alerts that are triggered are automatically recorded inDBA_ALERT_HISTORYafter they
are cleared.

D.
Alerts are triggered when the space usage reaches the warning level, again when it
reaches the critical level, and yet again when the space usage falls below the critical level.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Dave

Dave

imo it’ll be C and D
B says – you must disable the warning and critical and actually you don’t have to. In the documentation it says:
“When you take a tablespace offline or put it in read-only mode, you should disable the alerts for the tablespace by setting the thresholds to zero”
so should does not equal to must

with regards to D – you will be notified for the third time when the space usage will fall below the critical threshold to let you know that critial has been cleared

srks

srks

imo BD
B-setting to 0 is nothing but disable

Fonx

Fonx

A and C are simply true.

D I have a doubt… when is alert clearance sent ? Alert is sent when only warning thres is over ??

B Should is not must