Oracle

1Z0-883 · Question #1

Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?

The correct answer is D. Using TRUNCATE statements, for example, E. Disabling and re-enabling all instruments. See the full explanation below for the reasoning.

Question

Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?

Options

AUsing DELETE statements, for example, DELETE FROM
BUsing the statement RESET PERFORMANCE CACHE;
CUsing the statement FLUSH PERFORMANCE CACHE;
DUsing TRUNCATE statements, for example,
EDisabling and re-enabling all instruments
FRestarting Mysql

How the community answered

(27 responses)

A
11% (3)
B
7% (2)
C
4% (1)
D
78% (21)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-883 Practice