nerdexam
IBM

C2090-610 · Question #93

The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the following?

The correct answer is A. Concurrent application processes from performing any operations on the table. See the full explanation below for the reasoning.

Question

The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the following?

Options

  • AConcurrent application processes from performing any operations on the table.
  • BConcurrent application processes from performing any read-only operations on the table.
  • CConcurrent applications processes that are running under the cursor stability (CS) isolation level
  • DConcurrent applications processes that are running under the uncommitted read (UR) isolation

How the community answered

(28 responses)
  • A
    75% (21)
  • B
    14% (4)
  • C
    4% (1)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice