View the Exhibit and examine the query based on the DBA_THRESHOLDS view and its partial output :
Which observation about the output is correct?
A.
Logons Per Sec triggers an alert when the number of users logging on in an interval of one second is equal to or greater than 100.
B.
Blocked User Session Count triggers an alert based on the ELAPSED_TIME_PER_CALL and DB_TIME_WAITING metrics collection per minute.
C.
Database Time Spent Waiting(%) triggers an alert when more than 30% of the DB time per second for three consecutive seconds is spent on lock waits.
D.
Average Users Waiting Counts triggers an alert when the count is more than 30 for 3 consecutive 1 minute intervals and is related to the log file sync wait event.
wrong for sure AC as they say ‘per second’. But Observation period length (in minutes) see: https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_5057.htm
D is a little bit unclear as ‘log file sync’ is not the same as ‘commit’.
But D is more precise than B as in B it is not mentioned that the event has to occur 15 times before an alert is issued.