Sample Exam Questions

From the objective of OSS-DB Exam Silver
S2.2 Usage of server management tools

Sample Question

2.45

Answer all the correct statements about the standard PostgreSQL tools.

 
  1. pg_config can be used to check the PostgreSQL GUC parameters.

  2. pg_controldata can be used to check control information about WAL and timelines in a PostgreSQL database cluster.

  3. pg_isready can be used to check the startup status of the PostgreSQL server.

  4. pg_resetwal can be used to clean up WAL files.

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

Answer and Explanation

pg_config can be used to check the PostgreSQL installation information, such as the installation location and version.
pg_controldata can be used to check control information about WAL and timelines in a PostgreSQL database cluster.
pg_isready can be used to check the startup status of the PostgreSQL server.
pg_resetwal is a useful command that can be used to remove WAL files, for example, in case they become corrupted.

Therefore, the correct answers are B, C, and D.