nerdexam
IBM

C2090-610 · Question #134

Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1?

The correct answer is B. LOCK TABLE tab1 IN SHARE MODE. See the full explanation below for the reasoning.

Question

Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1?

Options

  • ALOCK TABLE tab1 IN READ MODE
  • BLOCK TABLE tab1 IN SHARE MODE
  • CLOCK TABLE tab1 IN EXCLUSIVE MODE
  • DLOCK TABLE tab1 IN READ-ONLY MODE

How the community answered

(27 responses)
  • A
    7% (2)
  • B
    74% (20)
  • C
    4% (1)
  • D
    15% (4)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice