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

質問 1：
You want to create a cursor that will SELECT the "customer" table. The created cursor must be able to move in any direction and reference data even after the end of the transaction.
Select one answer containing the correct keyword(s) to fill in the underlined blank below.
DECLARE cursor1 __________ FOR SELECT * FROM customer;
A. SCROLL CURSOR WITH HOLD
B. CURSOR WITHOUT HOLD
C. CURSOR
D. INSENSITIVE CURSOR
E. NO SCROLL CURSOR WITH HOLD
正解：A

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

質問 3：
You have just added an option "listen_addresses = 'localhost'" in postgresql.conf. When will this setting take effect?
A. This setting is invalid unless the change is made while postmaster is stopped.
B. This change will take effect after rebooting the OS, because the new option is recorded as an OS parameter.
C. This change will take effect by executing "pg_ctl restart".
D. This change will take effect by executing "pg_ctl reload".
E. This change will take effect as soon as postgresql.conf is saved.
正解：C

質問 4：
Select two incorrect statements regarding 'DOMAIN'.
A. When defining a domain, you can add a default value and constraints to the original data.
B. A domain can be used as a column type when defining a table.
C. A domain is created by 'CREATE DOMAIN'.
D. Domain is a namespace existing between databases and objects such as tables.
E. To define a domain, both input and output functions are required.
正解：D,E

質問 5：
Based on the relationship of columns within a table, select the most suitable description that
shows that column A is dependent on column B.
A. When the value in column B is changed, the corresponding value of column A also must be changed.
B. The value in column B is uniquely determined when a value in column A is selected.
C. The value in column A is uniquely determined when a value in column B is selected.
D. When the value in column A is changed, the corresponding value in column B also must be changed.
E. As long as column B exists, the amount of information will not decrease even if column A is deleted.
正解：C

質問 6：
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. psql -U postgres -f db1.dump db1
B. pg_dump --restore db1 < db1.dump
C. pg_dump -U postgres --restore db1 < db1.dump
D. pg_restore -U postgres -f db1.dump db1
E. pg_resetxlog -U postgres db1 < db1.dump
正解：A

質問 7：
What does the following command do? Choose the most appropriate statement from the selection
below.
Note: $ is the command prompt.
$ pg_dump postgres > pgsql
A. Outputs all of the content of the database postgres to the screen using the user pgsql.
B. Backs up the database postgres and writes an error message to the file pgsql.
C. Writes a backup of the database postgres to the file pgsql.
D. Writes a backup of the entire database cluster using user postgres to the file pgsql.
E. Writes a backup of the entire database cluster to the file postgres and writes an error message to the file pgsql.
正解：C

質問 8：
The following SQL defines an INSERT with respect to item_view.
Select the keyword that is applicable in the underlined blank.
CREATE _______ foo AS ON INSERT TO item_view
DO INSTEAD INSERT INTO item_table VALUES (NEW.id, NEW.itemname);
A. CONSTRAINT
B. FUNCTION
C. TRIGGER
D. VIEW
E. RULE
正解：E