Sample Exam Questions

From the objective of OSS-DB Exam Silver
S2.5 Basic server administration

Sample Question

2.47

Answer all the correct statements about the system catalog description.

 
  1. System catalogs are defined in a schema named pg_catalog.

  2. The system catalog is updated whenever a record is updated.

  3. The system catalog is updated through the ANALYZE command.

  4. The system catalog is referenced by the PostgreSQL planner and cannot be accessed by the user.

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

Answer and Explanation

The system catalogs are defined in a schema named pg_catalog and are updated whenever operations such as ANALYZE or VACUUM are performed.
The updating of a record does not trigger an update in the system catalog. Views such as pg_class are provided in the system catalogs for users to examine.

Therefore, the correct answers are A and C.