※This sample exam is different from those that appear in the actual OSS-DB Exam.
2019/03/01
In many RDBMSs including PostgreSQL, different character sets (encoding, encoding method) can be defined between the server and the client, and the database server appropriately converts the character code according to the character set desired by the client.
The types of character sets supported by PostgreSQL are described in the manual, but the character sets available on the server and the character set available on the client are different, and some character sets (even though they can be used on the client) can not be used on the server.
There are EUC, shift JIS, UTF 8 in the character set commonly used in Japanese. EUC and UTF 8 can be used by either server or client, but shift JIS can only be used by clients.
The default character set used in the database cluster is specified with the option of the initdb command, but the character set used in each database in the cluster can be specified with the option of the createdb command or the CREATE DATABASE statement, it does not have to be the same as the cluster's default character set.
The character set used in each table in the database is the character set of the database and can not be changed for each table.
Therefore, the correct answers are C and D