PGCES-02無料問題集「PostgreSQL-CE PostgreSQL CE 8 Silver」

質問 1

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 -U postgres --restore db1 < db1.dump

（B）psql -U postgres -f db1.dump db1

（C）pg_dump --restore db1 < db1.dump

（D）pg_restore -U postgres -f db1.dump db1

（E）pg_resetxlog -U postgres db1 < db1.dump

正解：B 解答を投票する

質問 2

Based on the following request, select the most appropriate command for creating a database cluster. ?Character encoding of the template database needs to be EUC_JP ?Locale is not used

（A）initdb --default-encoding=EUC_JP

（B）pg_ctl init --encoding=EUC_JP

（C）initdb --locale=EUC_JP --no-encoding

（D）initdb --encoding=EUC_JP --no-locale

（E）pg_ctl init --locale=EUC_JP

正解：D 解答を投票する

質問 3

Which normal form has the constraint that there must be no tables with duplicate column values in the same row?

（A）Boyce/Codd normal form

（B）Fourth normal form

（C）Third normal form

（D）Second normal form

（E）First normal form

正解：E 解答を投票する

質問 4

Select one incorrect statement regarding psql.

（A）Commands that begin with a backslash are processed internally inpsql.

（B）For system security, only thePostgreSQL administrator account is allowed to use psql.

（C）"psql -U jan" will connect to the database called jan.

（D）"psql -l" displays a database list.

（E）psql is an interactive SQL interpreter that enables a user to enter queries.

正解：B 解答を投票する

質問 5

Select two transaction isolation levels supported in PostgreSQL.

（A）DIRTY READ

（B）SERIALIZABLE

（C）PHANTOM READ

（D）READ COMMITTED

（E）REPEATABLE READ

正解：B、D 解答を投票する

質問 6

Select one incorrect statement about schemas.

（A）'SELECTcurrent_schema();' returns the current schema.

（B）A new schema is created by 'CREATE SCHEMA'.

（C）One user cannot own multiple schemas.

（D）A schema is the name space for a database object.

（E）'DROP SCHEMA' deletes a schema.

正解：C 解答を投票する

質問 7

You want to set a constraint so that the "item_id" in the "sales" table will always have a value that
already exists as "id" in the "item_master" table. Select the correct SQL statement to fill in the
underlined blank of the "sales" table. Definitions:
CREATE TABLE item_master (
id INTEGER PRIMARY KEY,
name TEXT
);
CREATE TABLE sales (
sales_id INTEGER,
item_id INTEGER,
num INTEGER,
);

（A）REFERENCESitem_master (id)

（B）FOREIGN KEY (id) REFERENCESitem_master (item_id)

（C）REFERENCESitem_master (id) TO item_id

（D）REFERENCESitem_master (item_id)

（E）FOREIGN KEY (item_id) REFERENCES item_master (id)

正解：E 解答を投票する

PGCES-02 無料問題集「PostgreSQL-CE PostgreSQL CE 8 Silver」

弊社を連絡する

関連リンク

トップ試験