Oracle Exam 1Z0-888 Topic 5 Question 44 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 44
Topic #: 5

You are investigating the performance of a query which selects data from an InnoDB table.

Consider this Performance Schema diagnostics output for the query:

Which statement is true about the output?

AThe time the query took is the sum of all timer_wait values.

BThe query did not find its table in the table definition cache.

CThe query read data from the data file rather than directly from the buffer pool.

DThe event with event_id = 8945 is a child of the event with event_id=8944.

Show Suggested Answer

Suggested Answer: B

by Rodolfo at May 08, 2022, 01:45 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!