nerdexam
IBM

C2090-619 · Question #112

The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

The correct answer is C. More memory is allocated for additional lock structures in the VIRTUAL section of. See the full explanation below for the reasoning.

Question

The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

Options

  • AThe user encounters a lock request error.
  • BMore memory is allocated for additional lock structures from DS_TOTAL_MEMORY.
  • CMore memory is allocated for additional lock structures in the VIRTUAL section of
  • DMore memory is allocated for additional lock structures in the RESIDENT section of

How the community answered

(30 responses)
  • A
    10% (3)
  • B
    3% (1)
  • C
    73% (22)
  • D
    13% (4)

Community Discussion

No community discussion yet for this question.

Full C2090-619 Practice