Sample Exam Questions

From the objective of OSS-DB Exam Gold
- Advanced Server Administration - Database architecture

Sample Question

1.10

Choose the one statement that is NOT an accurate description of the data stored in each subdirectory under the database cluster.

  1. The "global" directory contains tables that are shared across the entire database cluster.

  2. The "pg_tblspc" directory contains tables managed by tablespaces.

  3. The "pg_xact" directory contains data related to transaction commit statuses.

  4. The "pg_wal" directory contains WAL files.

  5. The "pg_stat_tmp" directory contains temporary files used by the statistics collector to exchange information with backend processes.

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

Answer and Explanation

pg_tblspc does not directly contain data such as tables or indexes; instead, it contains symbolic links to tablespaces.

Tablespaces defined by users using the CREATE TABLESPACE command will have a symbolic link to the physical tablespace directory within pg_tblspc. The use of tablespaces allows data to be stored in a directory separate from the database cluster, enabling distribution of tables across multiple disk devices to improve I/O performance.

Other statements are correct.

Therefore, the correct answer is B.