Sample Exam Questions

From the objective of OSS-DB Exam Silver
- Operation management - How to use standard attached tool

Sample Question

1.43

Choose two that are incorrect, from below which describe how to use pg_ctl.

  1. By pg_ctl initdb, you can create a new database cluster
  2. By pg_ctl start, you can start the database server
  3. By pg_ctl shutdown, you can stop the database server
  4. By pg_ctl reset, you can restart the database server
  5. By pg_ctl status, it is possible to check the operating status of the database server

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

Answer and Explanation

The main option of the pg_ctl command is 

init (initdb): Create a new database cluster

start: Starting the database server

stop: Stopping the database server

restart: Restart the database server

reload: Reload configuration file

status: Check the operation status of the database server

 

There is no option of shutdown, reset.

 

Therefore, the correct answers are C and D.

For pg_hba.conf, refer to the following page of the manual.

https://www.postgresql.org/docs/9.5/static/app-psql.html