Sample Exam Questions

From the objective of OSS-DB Exam Gold
- Monitoring Performance - Access statistics

Sample Question

1.05

Select all the objects that can be targets of locks, which can be confirmed using the pg_locks view.

  1. Database

  2. Relation

  3. Tuple

  4. Column

  5. Parameter

※This sample exam is different from those that appear in the actual OSS-DB Exam.
2025/05/30

Answer and Explanation

The correct answers are B and C.

The locktype column indicates the type of object being locked, as follows:

relation, extend, page, tuple, transactionid, virtualxid, object, userlock, advisory

This information is useful in identifying the cause of lock conflicts.