Sample Exam Questions

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

Sample Question

2.37

Choose the three most appropriate instructions for using the standard PostgreSQL tools.

 
  1. pg_config can change the values of configuration parameters in a PostgreSQL database.

  2. pg_controldata can be used to limit the size of data sent and received over the network.

  3. pg_ctl can start or stop a PostgreSQL database.

  4. pg_isready can check whether a PostgreSQL database is ready for connection.

  5. pg_resetwal can be used as a last resort when the database server cannot be started due to corruption of database files.

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

Answer and Explanation

pg_config is a command that displays a variety of information about PostgreSQL that is installed, including the parameters used to build the server.
pg_controldata is a command that displays information initialized by initdb, such as the catalog version.
pg_ctl can start, stop, and restart the database server, display the status of a running server, and reload configuration files.
pg_isready is a command that checks the status of the PostgreSQL server, returning an exit status indicating whether it is ready for connection.
pg_resetwal is a command that can remove PostgreSQL's WAL (write-ahead log) and also initialize some of the control information stored in the pg_control file, and can be used as a last resort when the server cannot be started, for example due to corruption of files.

So the correct answers are C, D, and E.