nerdexam
Oracle

1Z0-054 · Question #194

Which type of lock is held by SQL statements and PL/SQL objects in the Library Cache?

The correct answer is A. breakable parse locks. See the full explanation below for the reasoning.

Question

Which type of lock is held by SQL statements and PL/SQL objects in the Library Cache?

Options

  • Abreakable parse locks
  • Brow-level (TX type) lock
  • Ctable-level manual locks
  • Dtable-level (TM type) locks

How the community answered

(26 responses)
  • A
    81% (21)
  • C
    12% (3)
  • D
    8% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice