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 SpentWaiting(%) 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.
A is wrong. observation period is by min, not sec
B is wrong.
C is wrong. not in sec
D is right