IBM

C2010-571 · Question #5

How are long running SQL statements monitored?

The correct answer is C. Set the mxe.db.logSQLTimeLimit properties and review the output in the log file. See the full explanation below for the reasoning.

Question

How are long running SQL statements monitored?

Options

ASet the SQL logger to LOG and review the output in the log file
BSet the Root logger to DEBUG and review the output in the log file
CSet the mxe.db.logSQLTimeLimit properties and review the output in the log file
DSet the mxe.db.fetchResultLogLimit properties and review the output in the log file

How the community answered

(47 responses)

A
17% (8)
B
4% (2)
C
70% (33)
D
9% (4)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2010-571 Practice