※This sample exam is different from those that appear in the actual OSS-DB Exam.
The newly created database cluster created by initdb contains two template databases, template0 and template1.
If you create a new database with the CREATE DATABASE statement (or the createdb command), a copy of the template database will be internally created, but if you do not specify a template database to use at this time, template1 will be used.
The template database does not differ greatly from other databases in the database cluster except that the datistemplate of the database catalog pg_database is true. But if this attribute is set, all users with CREATEDB authority can create a database by referring to the template database. Also, if this attribute is set, you can not delete it with DROP DATABASE. Conversely, if the datistemplate is false, it is restricted to the owner of the database and the superuser that can create the database with it as a template, and it is also possible to delete the database.
There is no limit to the number of template databases that can be created in a database cluster.
Because it is a matter of choosing what is wrong, the correct answer is D.