Sample Exam Questions

From the objective of OSS-DB Exam Silver
- Operation and Management - Basic Operation Management Work (Information Schema and System Catalog)

Sample Question


Choose the two most accurate descriptions of the information schema.

  1. Available for all relational databases, including PostgreSQL.
  2. The specification is part of the ANSI SQL standards.
  3. Holds various information about objects in the database.
  4. It is defined as a view in the schema named information.
  5. Content is equivalent to system catalog. 

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

Answer and Explanation

The information schema is organized as a collection of views in a schema called information_schema that provides various information about the objects in the database.

Since it is defined in the SQL standard, it is portable, and other RDBMS can acquire information with the same SQL, but it is not available in all RDBMS.

Because it conforms to the standard, information on proprietary extensions of PostgreSQL are not included in the information schema. For extended functions, you can inquire by using the system catalog.

Therefore the correct answers are B and C.