Sample Exam Questions

From the objective of OSS-DB Exam Silver
S2.3 Configuration files (postgresql.conf)

Sample Question


Choose two correct ways to configure postgresql.conf.

  1. Boolean parameters can have values such as on, true, t, yes, or y for representing 'true'.

  2. Numeric parameter values are written with commas in every 3 digits for readability, such as 12,345.

  3. Units of time include ms (milliseconds), s (seconds), m (minutes), h (hours), and d (days), and they are case-insensitive.

  4. Units of memory include B, kB, MB, GB, and TB. Only k in kilobytes is written in lowercase and all others should be in uppercase.

  5. When writing time or memory parameter values, if you omit the unit and write only a numeric value, milliseconds and bytes are used as the defaults, respectively.

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

Answer and Explanation

Boolean parameter values can be on, off, true, false, yes, no, 1, or 0, which are all case-insensitive. In addition, the first few characters of these values can be used as abbreviations if they are not ambiguous. That is, in addition to on, true, yes, and 1, t, y, and so on also represent true. If it is only o, it is not acceptable because it is ambiguous whether it is on or off.
For numeric parameters, you can use numbers and decimal points (for floating-point parameters), but you cannot use commas as thousands separator.
Units of time and memory parameters are case-sensitive. Time units must be all in lowercases, and for the memory units, k in kilobytes is in lowercase and all others are in uppercases. Also, the unit for minutes is min, not m.
The default units are not uniform, but are determined for each parameter, and they are stored in pg_settings.unit. You can check them by connecting to the database with psql and executing:
select name, unit from pg_settings where unit is not null;
The default units may vary; however, for example, even if a parameter has a default unit of kB, you can still add units to the parameter value as in '1MB' to specify 1 megabyte.

So the correct answers are A and D.