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

質問 1

Select one incorrect statement concerning the relational data model.

（A）It is a model based on set theory.

（B）It expresses the real world in a collection of 2-dimensional tables called a relation.

（C）It is a model that was proposed by F. Codd in 1970.

（D）It has a logical structure independent of physical data structure.

（E）It is made up of a multiple stage hierarchy where each of the set elements has parent child relationships.

正解：E 解答を投票する

質問 2

The "animal" table consists of the following data:
Select the correct result returned by executing the following SQL statement:
SELECT name FROM animal ORDER BY weight DESC LIMIT 2 OFFSET 1;

（A）A syntax error will occur.

正解：A 解答を投票する

質問 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）There is a possibility of configuration parameter changes after major version upgrades.

（C）Upgrade scripts can be executed while the old version ofPostgreSQL is running.

（D）To use the data from the old version, you need to conduct a backup and restore.

（E）You can use the databases of the old major version.

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

質問 4

The following table called 'company' is defined as follows:
id | name
----+------------------
1 | Pgsql,inc.
2 | Postgres Co.,Ltd
3 | SQL Company.
Select the most appropriate psql command for generating a text file company.txt on the client side
with the following content:
1,"Pgsql,inc."
2,"Postgres Co.,Ltd"
3,SQL Company.

（A）\copy company TO 'company.txt' DELIMITER ','

（B）\copycompany TO company.txt CSV

（C）\copycompany TO "company.txt"

（D）\copycompany TO 'company.txt' WITH DELIMITER AS ','

（E）\copycompany TO 'company.txt' WITH ','

正解：B 解答を投票する

質問 5

A set of tables are defined as follows:
t1
t2
How many rows are returned by executing the following SQL statement?
SELECT * FROM t1
WHERE EXISTS (SELECT name FROM t2 WHERE t1.id = t2.id);

（A）3 rows

（B）5 rows

（C）0 rows

（D）6 rows

（E）2 rows

正解：E 解答を投票する

質問 6

The following are statements related to the postmaster. Select one statement that is incorrect.

（A）The "pg_ctl start" command boots up postmaster.

（B）It is not possible to boot up the postmaster process by directly executing the postmaster command.

（C）The "pg_ctl stop" command stops postmaster.

（D）postmaster is a server process that receives connections from clients.

（E）One postmaster process controls one database cluster.

正解：B 解答を投票する

質問 7

A table named "sample" is defined as below. Select two statements which will generate a
constraint error.
CREATE TABLE sample (
i INTEGER PRIMARY KEY,
j INTEGER,
CHECK ( i > 0 AND j < 0 )
);

（A）INSERT INTO sample VALUES (NULL, -4);

（B）INSERT INTO sample VALUES (1, 0);

（C）INSERT INTO sample VALUES (3, NULL);

（D）INSERT INTO sample VALUES (2, -2);

（E）INSERT INTO sample VALUES (5, -5);

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

質問 8

A pg_hba.conf file is set up as follows.
local all all md5
host all all 127.0.0.1/32 md5
host all all 172.16.1.0/24 md5
When user foo connects to database bar from host IP address 172.16.1.2, I would like password
verification to not be performed.
Select one appropriate line for the new pg_hba.conf file.

（A）Add "host barfoo 172.16.1.2/32 trust" to the first row.

（B）Add "hostfoo bar 172.16.1.2/32 trust" to the first row.

（C）The settings are fine as is.

（D）Add "hostfoo bar 172.16.1.2/32 trust" to the last row.

（E）Add "host barfoo 172.16.1.2/32 trust" to the last row.

正解：A 解答を投票する

質問 9

Select two correct statements that describe what occurs on the client side when the following command is executed. pg_ctl -m smart stop

（A）Clients will not be able to make new connections.

（B）Connected clients receive a message saying that the server will soon be shutdown.

（C）The running transaction for a connected client is rolled back and the connection is disconnected forcibly.

（D）The processes of currently connected clients are processed normally.

（E）Connections are terminated after the currently running transactions have finished.

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

質問 10

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）3 rows

（B）5 rows

（C）4 rows

（D）6 rows

（E）2 rows

正解：A 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験