PostgreSQL-CE PGCES-02 問題集

質問 1：
The table "t1" is defined by the following SQL statement: CREATE TABLE t1 (id integer, name
varchar(20));
You want to increase the execution speed of the SQL statement below:
SELECT id, name FROM t1 WHERE id < 123 AND upper(name) = 'MAMMOTH'; Select the most
suitable SQL statement to create an index.
A. CREATE INDEX t1_idx ON t1 USING HASH (id);
B. ALTER TABLE ADD INDEX ON t1 (id,upper(name));
C. ALTER TABLE ADD INDEX ON t1 (id, name);
D. CREATE INDEX t1_idx ON t1 (id,upper(name));
E. CREATE INDEX t1_idx ON t1 (name);
正解：D

質問 2：
I would like to restore the database cluster from the "db1.dump" backup file.
Select the correct command from below. (Note: "postgres" is the superuser)
A. pg_dump --restore db1 < db1.dump
B. pg_restore -U postgres -f db1.dump db1
C. psql -U postgres -f db1.dump db1
D. pg_dump -U postgres --restore db1 < db1.dump
E. pg_resetxlog -U postgres db1 < db1.dump
正解：C

質問 3：
Select two correct statements about the command shown below. Note: $ is the command prompt. $ pg_ctl reload
A. The command temporarily stops the PostgreSQL server process and restart it.
B. The command causes a recovery to be performed from a standard backup file in the PostgreSQLserver process.
C. The command forces the content of pg_hba.conf to be re-read into PostgreSQL server process.
D. The command forces the content of the database cluster to be re-read into PostgreSQL server process.
E. The command re-reads the postgresql.conf details into the PostgreSQL server process and changes the values of any configuration parameters that can be changed.
正解：C,E

質問 4：
Select one incorrect statement regarding psql.
A. For system security, only thePostgreSQL administrator account is allowed to use psql.
B. "psql -U jan" will connect to the database called jan.
C. psql is an interactive SQL interpreter that enables a user to enter queries.
D. Commands that begin with a backslash are processed internally inpsql.
E. "psql -l" displays a database list.
正解：A

質問 5：
Select the correct SQL statement that records the space occupied by deleted or updated rows for
later reuse, and also updates statistics.
A. NOTIFY
B. EXPLAIN ANALYZE
C. VACUUM ANALYZE
D. VACUUM
E. EXPLAIN
正解：C

質問 6：
Select two incorrect statements about the function of the information schema.
A. Information on objects defined in a database can be referenced.
B. The number of tables defined in a database can be confirmed.
C. In order to enable the information schema, "information_schema = true" must be set in postgresql.conf
D. It consists of a group of views included in a schema called "information_schema".
E. Administrator privileges are needed to reference the information schema.
正解：C,E