Sample Exam Questions

From the objective of OSS-DB Exam Silver
S1.1 General features of OSS-DB (Major version / Minor version)

Sample Question


"Up to version 9, PostgreSQL's version numbering consisted of 3 numbers, such as 9.6.3. Starting with version 10, it consists of 2 numbers, such as 11.2.
Choose two appropriate explanations for this."

  1. The first number is the major version, the second is the minor version, and the third is the patch version. Starting with version 10, patch versions are no longer indicated.
  2. The first and second numbers together are the major version, and the third number is the minor version. Since version 10, minor versions are no longer indicated.
  3. Up to version 9, the first two numbers are the major version, and after version 10, the first number is the major version. The last number is the minor version for all versions.
  4. If the major versions are the same, the files that make up the database are compatible, but if they are different, they are incompatible and require database conversion during the upgrade.
  5. Regardless of the version, if the version numbers are different, the files that make up the database are incompatible, and conversion of the database is required during the upgrade. 

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

Answer and Explanation

PostgreSQL receives a major update once a year and a minor update every three months.
In terms of version notation, major updates increase the major version number and minor updates increase the minor version number. However, this notation changed with the release of version 10 in 2017. Previously, the major version was represented by the first two numbers; for example, versions 9.5 and 9.6 have different major versions. The third number, such as 3 in 9.6.3, represents the minor version, indicating the third minor update. Starting with version 10, only the first number represents the major version. For example, in versions 10.5 and 10.6, the major version is the same and the second number represents the minor version, indicating the fifth and sixth minor updates, respectively. Be careful not to get confused.

Major updates add a number of new features, which can change the structure of the database, among other things. Therefore, when upgrading, itis not only necessary to install new programs, but also to rebuild the database itself, which includes data migration.
Minor updates only involve bug fixes, and no new features are added. While you may be asked to modify existing data as part of a bug fix, the database structure itself remains compatible. Therefore, in most cases, simply updating the database program is enough to complete the upgrade.

So the correct answers are C and D.