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.
-
pg_config can be used to check the PostgreSQL GUC parameters.
-
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 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.
© EDUCO All Rights Reserved.