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.
C,D
B,C
yes, B,C
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
imo BD
B-setting to 0 is nothing but disable
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
A,C