Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Go to Exam

Question 32

Examine this query:

What information does this query provide?

total memory used across all connections associated with the user on connection number 10

total memory used by the first 10 connections

total memory used by thread number 10

total memory used across all connections associated with the user on thread number 10

total memory used by connection number 10

total memory used by the first 10 threads

Correct Answer: E

The query calculates the total memory used by the thread associated with connection number 10 by filtering the results with t.PROCESSLIST_ID = 10. This leads to the conclusion that the query is providing the total memory used by connection number 10.

Discussion

marklvOption: E

E. counts memory where processid = 10