PostgreSQL-CE PGCES-02 問題集

質問 1：
Select an incorrect statement regarding the following SQL statement. Note that "user_view" is a
view.
CREATE OR REPLACE RULE rule_1 AS ON UPDATE TO user_view DO INSTEAD NOTHING;
A. It is defining a rule "rule_1".
B. When executing 'UPDATE user_view', data is updated in the table that is the origin of the view.
C. It will replace "rule_1" if it already exists.
D. 'DROP RULE rule_1 ON user_view' deletes the above definition.
E. Executing 'UPDATE user_view' will no longer output errors.
正解：B

質問 2：
Given the following two table definitions, select one SQL statement which will cause an error.
CREATE TABLE sample1 (id INTEGER, data TEXT);
CREATE TABLE sample2 (id INTEGER);
A. SELECT id, data FROM sample1 AS s1, sample2 AS s2 WHERE s1.id = s2.id;
B. SELECT s1.id FROM sample1 s1;
C. SELECT s1.id, s1.data FROM sample1 AS s1, sample2 AS s2 WHERE s1.id = s2.id;
D. SELECT data FROM sample1 AS s1, sample2 AS s2 WHERE s1.id = 1 AND s2.id = 2;
E. SELECT s1.id FROM sample1 AS s1;
正解：A

質問 3：
Select two incorrect statements concerning PostgreSQL license.
A. Developers are only responsible for handling its crucial faults.
B. It can be freely redistributed.
C. Developers are responsible for its maintenance support.
D. It can be used freely.
E. It can be duplicated freely.
正解：A,C

質問 4：
I would like to be able to save log entries as shown below. Select a correct configuration setting
from statements below.
LOG: connection received: host=[local] port=
LOG: connection authorized: user=postgres database=test
A. log_connections = true
B. log_authorization = true
C. log_hostname = true
D. log_min_level = log
E. syslog = true
正解：A

質問 5：
A table is defined as below. Select the most suitable description about the foreign key constraint.
CREATE TABLE master (id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE record (id INTEGER REFERENCES master (id), count INTEGER);
A. The "record" table cannot have duplicate "id"s.
B. If the "record" table contains a row with an "id", no change can be made at all to the corresponding "id" row in the "master" table.
C. If any row exists in the "record" table, no change can be made to the "master" table.
D. If the "record" table contains a row with an "id", the corresponding "id" row in the "master" table cannot be deleted.
E. These SQL statements are invalid; no constraints are created.
正解：D

質問 6：
I would like to check the privileges on the "items" table in psql. Select the most appropriate command.
A. \p items
B. \z items
C. \a items
D. \t items
E. \d items
正解：B