Multiple choice technology mainframe

For which of the following database objects can locks NOT be obtained?

  1. A row

  2. A table

  3. A column

  4. An index key
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Database locking mechanisms can be applied at row level, table level, and index key level, but NOT at individual column level. Column-level locking would be extremely granular and inefficient - most database systems lock at the row or page level instead. When you need to prevent concurrent access to specific columns, you use row-level locks which protect the entire row including all its columns. This is a fundamental design decision in database concurrency control.

Keep practicing — related questions