PGCES-02問題集、PostgreSQL-CE実際の試験問題

質問 1

Select two incorrect statements regarding 'TRIGGER'.

A. A trigger can be set up to call a specified function before or after the event occurs.

B. When INSERT is executed to thetable, the specified function can be called.

C. A corresponding rule is automatically created when a trigger is created.

D. When SELECT is executed to thetable, the specified function can be called.

E. When UPDATE is executed to thetable, the specified function can be called.

正解: C,D

質問 2

Select the most suitable statement about the PostgreSQL license from below.

A. PostgreSQL is distributed under the BSD license.

B. PostgreSQL is distributed under the X11(MIT) license.

C. PostgreSQL is distributed under the GPL license.

D. PostgreSQL is distributed under the LGPL license.

E. PostgreSQL is distributed under the PostgreSQL license.

正解: A

質問 3

Select one incorrect statement concerning the relational data model.

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

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

C. It is a model based on set theory.

D. It is a model that was proposed by F. Codd in 1970.

E. It has a logical structure independent of physical data structure.

正解: A

質問 4

Select two incorrect statements regarding large objects.

A. A large object is generated by 'CREATE LARGE OBJECT'.

B. A large object is added by 'INSERT'.

C. An OID is used to identify a large object.

D. One large object is able to handle up to 2GB of data.

E. Binary data cannot be used unless declared as a large object.

正解: C,D

質問 5

Select two commands below from which privileges cannot be changed by the GRANT and
REVOKE statements.

A. DROP

B. DELETE

C. VACUUM

D. SELECT

E. TRIGGER

正解: A,C

質問 6

The following SQL statements were executed using psql.
Select the appropriate statement about the result.
LISTEN sign_v; BEGIN; NOTIFY sign_v;
COMMIT; LISTEN sign_v;

A. When 'LISTEN sign_v' is executed for the second time, a message that starts with "Asynchronous notification 'sign_v' received" is output.

B. The message "Asynchronous notification 'sign_v' received" is not received while in this connection.

C. At the point that 'COMMIT' is executed, a message that starts with "Asynchronous notification 'sign_v' received" is output.

D. At the point that 'NOTIFY sign_v' is executed, a message that starts with "Asynchronous notification 'sign_v' received" is output.

E. At the point that 'SELECT * FROM pg_user;" is executed, a message that starts with "Asynchronous notification 'sign_v' received" is output.

正解: C

質問 7

Which psql command do you need to execute to display the list of tables in the currently connected database?

A. SELECT * FROMpg_table_list;

B. \dt "database_name"

C. \dT

D. \dt

E. SHOW tables;

正解: D

質問 8

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. 2 rows

B. 3 rows

C. 0 rows

D. 5 rows

E. 6 rows

正解: A

PostgreSQL-CE PostgreSQL CE 8 Silver - PGCES-02 模擬練習