nerdexam
IBM

C2090-312 · Question #129

In order to properly monitor locks on a continual basis, which action should be performed but will avoid using excessive CPU resources to gather the information?

The correct answer is D. Always have statistics classes 1,,3, and 4 and accounting classes 1 and 3 running. See the full explanation below for the reasoning.

Question

In order to properly monitor locks on a continual basis, which action should be performed but will avoid using excessive CPU resources to gather the information?

Options

  • ATurn on a monitor trace.
  • BAlways have a performance trace running.
  • CPerform a DISPLAY DATABASE (LOCKS ) command often.
  • DAlways have statistics classes 1,,3, and 4 and accounting classes 1 and 3 running.

How the community answered

(50 responses)
  • A
    12% (6)
  • B
    2% (1)
  • C
    4% (2)
  • D
    82% (41)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice