最新なPostgreSQL-CE PGCES-02問題集（145題）、真実試験の問題を全部にカバー！

質問 1：
The tables "t1" and "t2" are defined below.
Tables "t1" and "t2" have columns "id" that are of INTEGER type, and columns "name" that are of
TEXT type.
t1
t2
The following SQL command was executed. Select the number of rows in the result. SELECT *
FROM t1 RIGHT OUTER JOIN t2 ON t1.id = t2.id;
A. 6 rows
B. 4 rows
C. 5 rows
D. 2 rows
E. 3 rows
正解：E

質問 2：
The "sample" table consists of the following data:
How many rows are returned by executing the following SQL statement? SELECT i FROM sample
GROUP BY i HAVING count(*) = 2;
A. 0 rows
B. 1 row
C. 4 rows
D. 2 rows
E. 3 rows
正解：D

質問 3：
Select two suitable statements about major version upgrades of PostgreSQL from below.
A. To use the data from the old version, you only need to replace the program.
B. You can use the databases of the old major version.
C. Upgrade scripts can be executed while the old version ofPostgreSQL is running.
D. There is a possibility of configuration parameter changes after major version upgrades.
E. To use the data from the old version, you need to conduct a backup and restore.
正解：D,E

質問 4：
Select one false statement about the benefits of using database management systems from below.
A. You can separate the data display method from the application.
B. You can share data more easily on systems consisting of multiple computers.
C. You can separate the data storage method from the application.
D. You can reduce the programming workload of programming for managing data.
E. You can separate the data search method from the application.
正解：A

質問 5：
It is possible to backup a database cluster by copying the entire data directory. Select two
suitable descriptions regarding this backup method.
A. The database servermust be stopped prior to the backup.
B. You can use standard tools like "tar" and "rsync" to backup files and directories.
C. "psql" is used to restore the database.
D. The "pg_restore" command is used to restore the database.
E. The backup data willbe a text file consisting of SQL statements.
正解：A,B

質問 6：
I would like to set the default character encoding for the client to Unicode.
Select the most appropriate configuration parameter in postgresql.conf from those below.
A. backend_encoding = UNICODE
B. default_encoding = UTF8
C. encoding = UTF8
D. client_encoding = UNICODE
E. frontend_encoding = UNICODE
正解：D