From the objective of OSS-DB Exam Silver
- Operation and Management - Installation Method (Concept and Structure of Database Cluster)
Sample Question
1.06
Choose two appropriate statements about the PostgreSQL database cluster.
- log_destination specifies the file name to which the log will be output.
-
By default, there are two databases, template 0 and template 1.
- By default, there are three databases, template 0, template 1, and postgres.
- Database template 0 can not be deleted.
- Database postgres can not be deleted.
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2018/06/20
Answer and Explanation
When you create a database cluster with the initdb command, it creates three databases, a template database called template0 and template1, and a regular database called postgres.
By default, when creating a database with the createdb command or the SQL CREATE DATABASE statement, a copy of template1 is created by default, but you can specify other databases such as template0 by option.
Template0 is a read-only database that contains only system standard objects and can not be deleted. Database template1 can be written if necessary, and it is also possible to delete (DROP DATABASE) the database itself.
Postgres is an ordinary database that exists by default, and there are some third party products that assume its existence, but after all, even if you delete it, it is not a problem as a system.
Therefore, the correct answers are C and D.