IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 7

Which database object can be locked explicitly?

Answer options

• A. Row
• B. View
• C. Index
• D. Table

Correct answer: D

Explanation

The correct answer is D, Table, because tables can be explicitly locked during transactions to prevent other operations until the lock is released. While rows, views, and indexes can have locks applied, they are typically managed by the database system itself and are not explicitly locked in the same way as tables.