MySQL 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第24题
最新学讯:近期OCP认证正在报名中,因考试人员较多请尽快报名获取最近考试时间,报名费用请联系在线老师,甲骨文官方认证,报名从速!
我要咨询MySQL 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第24题
本套题库是MySQL 8.0 OCP考试试题,由CUUG整理,如有报考OCP认证意向,可以联系cuug咨询老师。
24、
Choose the best answer.
Examine this partial report:
MySQL> SHOW FULL PROCESSLIST;
Examine this query:
SELECT SUM (m.CURRENT_NUMBER_OF_BYTES_USED) AS TOTAL
FROM performance_schema.memory_summary_by_thread by_event_name m
INNER JOIN performance_schema.threads t
ON m.THREAD_ID = t.THREAD_ID
WHERE t.PROCESSLIST_ID = 10;
What information does this query provide?
A) total memory used by connection number 10
B) total memory used across all connections associated with the user on connection number 10
C) total memory used by the first 10 threads
D) total memory used by thread number 10
E) total memory used across all connections associated with the user on thread number 10
F) total memory used by the first 10 connections