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

質問 1

Select one correct statement about the createlang command.

（A）It is a command thathas been discarded for version 8 and later.

（B）It is a command for setting the locale for a database.

（C）It is a command for adding message catalogs.

（D）It is a command for registering a procedural language into a database.

（E）It is a command for creating a user defined function.

正解：D 解答を投票する

質問 2

Select two incorrect statements about the function of the information schema.

（A）It consists of a group of views included in a schema called "information_schema".

（B）Administrator privileges are needed to reference the information schema.

（C）The number of tables defined in a database can be confirmed.

（D）In order to enable the information schema, "information_schema = true" must be set in postgresql.conf

（E）Information on objects defined in a database can be referenced.

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

質問 3

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 解答を投票する

質問 4

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）When executing 'UPDATE user_view', data is updated in the table that is the origin of the view.

（B）Executing 'UPDATE user_view' will no longer output errors.

（C）'DROP RULE rule_1 ON user_view' deletes the above definition.

（D）It will replace "rule_1" if it already exists.

（E）It is defining a rule "rule_1".

正解：A 解答を投票する

質問 5

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 解答を投票する

質問 6

Select two suitable statements regarding the pg_dump command.

（A）pg_dump can create a backup while postmaster is stopped.

（B）Only the user who executedinitdb can execute pg_dump.

（C）pg_dump can create a backup while postmaster is running.

（D）pg_dump can create a backup of a specified table.

（E）pg_dump is an SQL command.

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

質問 7

Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.

（A）You can use the TRUE or FALSE keywords as a value for the BOOLEAN type.

（B）You can use thecharacters 't' or 'f' as a value for the BOOLEAN type.

（C）If the INTEGER value of '0' is inserted into a BOOLEAN column, it will be treated as FALS

（D）BOOLEAN only takeseither NULL, TRUE, or FALSE.

（E）BOOLEAN is an alias of the INTEGER type inPostgreSQL.

正解：C、E 解答を投票する

質問 8

Select the correct result generated by execution of the following SQL statements: CREATE
TABLE log (id int, message TEXT, logtime TIMESTAMP);
CREATE TABLE log_01 () INHERITS (log);
INSERT INTO log_01 VALUES (1, 'error', CURRENT_TIMESTAMP); SELECT * FROM log;

（A）Second 'CREATE TABLE' generates a syntax error.

（B）'SELECT' statement returns 0 rows, and exits successfully.

（C）'INSERT' statement generates an error stating that the number of columns and values do not match".

（D）'SELECT' statement returns 1 row, and exits successfully.

（E）First 'CREATE TABLE' generates a syntax error.

正解：D 解答を投票する

質問 9

Select two correct statements about the command shown below. Note: $ is the command prompt. $ vacuumdb -az

（A）Collects statistical information related to the table content for all of the databases.

（B）Recovers unused areas from all of the databases.

（C）Processes the job equivalent of the VACUUM FULL command for all of the databases.

（D）The database can not be accessed until this command is finished.

（E）Processes the job equivalent of the VACUUM VERBOSE command for all of the databases.

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

質問 10

Select one option which cannot be specified using createdb.

（A）Database locale

（B）Host name

（C）Character encoding

（D）Database owner

（E）Template database

正解：A 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験