|
QUESTION
NO: 8
Which query would
you use to find connections that are in the same state for longer than 180
seconds?
A. SHOW FULL PROCESSLIST WHEER Time > 180;
B. SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB
(NOW ( ), INTERVAL 180 SECOND) );
C.
SELECT * FROM
INFORMATION_SCHEMA.SESSION_STATUS WHERE STATE < (DATE_SUB (NOW ( ), INTERVAL
180 SECOND) );
D.
SELECT * FROM
INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 180;
|
|