Multiple choice technology mainframe

What is a lock in DB2?

  1. A lock is the mechanism that controls access to rows and coloumns

  2. A lock is the mechanism that controls access to table views

  3. A lock is the mechanism that controls access to data pages and table spaces.

  4. None of the Above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DB2 locks control access to physical and logical data resources like table spaces, tables, and data pages to ensure concurrency. They do not lock individual columns (making the first option incorrect) or views directly (making the second option incorrect), making the third option the most accurate.

Keep practicing — related questions