Free PGCES-02 Exam Dumps PDF Preview

Question 1

Multiple choice

The following question concerns the use of multibyte characters in PostgreSQL. Select two correct items about character encoding in PostgreSQL.

A
"./configure --enable-multibyte" must be designated at time of build.
B
When the database cluster is initialized, the or --multibyte option must be specified.
C
Character encoding can be set on a per database basis.
D
Only a single character encoding can be specified for each database cluster.
E
Different character encodings can be specified for server and clients.

Reveal answer details Close answer details

Correct answersC, E

Question 2

Single choice

What does the following command do? Select the correct description from below. Note: "text=#" is the command prompt for psql.
test=# ANALYZE foo;

A
Collects statistical information related to the content of the database foo.
B
Collects statistical information related to the content of the table foo.
C
Collects statistical information related to the content of the database test.
D
Outputs statistical information related to the content of the table foo.
E
The command does not generate an error; however, it does not do anything either.

Reveal answer details Close answer details

Correct answerB

Question 3

Multiple choice

Select two correct descriptions about views.

A
A view is created by 'DECLARE VIEW', and deleted by 'DROP VIEW'.
B
A view is a virtual table which does not exist.
C
A view is created to simplify complicated queries.
D
You can create a view with the same name as already existing tables.
E
A view only exists while the postmaster is running, and is deleted when the postmaster stops.

Reveal answer details Close answer details

Correct answersB, C

Question 4

Single choice

Select the most suitable statement regarding PostgreSQL's pg_hba.conf configuration file.

A
You can use any number of authentication types on a single line.
B
You cannot set different authentications per user.
C
You can set different authentications per table.
D
The authentication settings in the file are evaluated from the top line to the bottom line.
E
krb5 authentication can only be used for local connections.

Reveal answer details Close answer details

Correct answerD

Question 5

Single choice

The "sample" table consists of the data below. The column "x" is of type INTEGER. How many rows are returned by executing the following SQL statement? SELECT 6 / x FROM sample WHERE CASE WHEN x = 0 THEN FALSE ELSE TRUE END;

A
"ERROR division by zero" and no rows are returned.
B
0 rows with no errors.
C
1 row
D
2 rows
E
3 rows

Reveal answer details Close answer details

Correct answerD

Question 6

Multiple choice

Select two incorrect statements concerning PostgreSQL license.

A
It can be used freely.
B
It can be duplicated freely.
C
It can be freely redistributed.
D
Developers are responsible for its maintenance support.
E
Developers are only responsible for handling its crucial faults.

Reveal answer details Close answer details

Correct answersD, E

Question 7

Multiple choice

Select two SQL statements which abort a transaction.

A
END
B
ROLLBACK
C
TRUNCATE
D
ABORT
E
DROP TRANSTACTION

Reveal answer details Close answer details

Correct answersB, D

Question 8

Single choice

Table "t1" is defined below.
Table "t1" has a column "id" of type INTEGER, and a column "name" of type TEXT. t1:
The following SQL is executed while client "A" is connected. BEGIN; SELECT * FROM t1 WHERE id = 2
FOR UPDATE; SELECT * FROM t1 WHERE id = 1 FOR UPDATE; -- (*)
While the second 'SELECT' statement, shown with (*), is being executed, a separate client "B" connects and executes the following SQL.
Select the correct statement about the execution results. UPDATE t1 SET name = 'turtle' WHERE id = 2;

Note: the default transaction isolation level is set to "read committed".

A
The update process for client "B" is blocked until the current connection for client "A" is finished.
B
The update process for client "B" is blocked until the current transaction for client "A" is finished.
C
The 'UPDATE' process for client "B" proceeds regardless of the condition of client "A".
D
The process of client "B" immediately generates an error.
E
The processes for both clients are blocked, and an error stating that a deadlock has been detected is generated.

Reveal answer details Close answer details

Correct answerB

Question 9

Multiple choice

Select two suitable statements about postgresql.conf configuration.

A
A line that starts with ! (exclamation mark) is interpreted as a comment.
B
You can have different parameters for the same option to configure each database differently.
C
The timing of when a change in any value is reflected is different depending on the configuration parameter.
D
All options have no default values. Therefore, all of them must be set specifically and thoroughly.
E
As a boolean value, any of the following can be used: TRUE, FALSE, ON, OFF, YES, NO, 0.1

Reveal answer details Close answer details

Correct answersC, E

Question 10

Single choice

The table "tbl" is defined below such that it could only store non-negative integers in the column "nn".
Select the keyword that is applicable for the underlined blank. CREATE natural_number AS DECIMAL CHECK (VALUE >= 0); CREATE TABLE tbl(nn natural_number);

A
VIEW
B
SCHEMA
C
RULE
D
TYPE
E
DOMAIN

Reveal answer details Close answer details

Correct answerE

Question 11

Single choice

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
RULE
B
VIEW
C
TRIGGER
D
FUNCTION
E
CONSTRAINT

Reveal answer details Close answer details

Correct answerA

Question 12

Single choice

I would like to check the privileges on the "items" table in psql. Select the most appropriate command.

A
\a items
B
\d items
C
\t items
D
\p items
E
\z items

Reveal answer details Close answer details

Correct answerE

Question 13

Multiple choice

Select two suitable statements regarding a postmaster process.

A
A postmaster process waits for client connection requests.
B
A postmaster process receives and processes database queries.
C
A postmaster process creates a child process which processes the given queries.
D
A postmaster process collects statistical information.
E
A postmaster process is created for each client connection.

Reveal answer details Close answer details

Correct answersA, C

Question 14

Single choice

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_restore -U postgres -f db1.dump db1
B
pg_dump --restore db1 < db1.dump
C
pg_dump -U postgres --restore db1 < db1.dump
D
psql -U postgres -f db1.dump db1
E
pg_resetxlog -U postgres db1 < db1.dump

Reveal answer details Close answer details

Correct answerD

Question 15

Single choice

Select the correct SQL statement which concatenates strings 'ABC' and 'abc' to form 'ABCabc'.

A
SELECT 'ABC' . 'abc';
B
SELECT cat('ABC', 'abc') FROM pg_operator;
C
SELECT 'ABC' + 'abc';
D
SELECT 'ABC' + 'abc' FROM pg_operator;
E
SELECT 'ABC' || 'abc';

Reveal answer details Close answer details

Correct answerE

Question 16

Single choice

I want to restore data from a text format backup file foo.dump. Select an appropriate command.

A
pg_dump -R foo < foo.dump
B
pg_restore -d foo foo.dump
C
pg_restore -f foo.dump foo
D
psql -f foo.dump foo
E
createdb foo < foo.dump

Reveal answer details Close answer details

Correct answerD

Question 17

Multiple choice

Select two suitable statements regarding the pg_dump command.

A
pg_dump is an SQL command.
B
Only the user who executed initdb can execute pg_dump.
C
pg_dump can create a backup while postmaster is running.
D
pg_dump can create a backup while postmaster is stopped.
E
pg_dump can create a backup of a specified table.

Reveal answer details Close answer details

Correct answersC, E

Question 18

Single choice

Select the most appropriate setting to output the log messages of the database to syslog.

A
"syslog = true" in postgresql.conf.
B
"log_destination = 0" in postgresql.conf.
C
"log_destination = 1" in postgresql.conf.
D
"log_destination = 2" in postgresql.conf.
E
"log_destination = syslog" in postgresql.conf.

Reveal answer details Close answer details

Correct answerE

Question 19

Multiple choice

Select two incorrect statements regarding 'DOMAIN'.

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

Reveal answer details Close answer details

Correct answersB, E

Question 20

Single choice

Select an incorrect statement regarding prepared statements, and 'PREPARE' / 'EXECUTE' commands.

A
'PREPARE'/'EXECUTE' is mainly used to optimize performance.
B
'PREPARE' creates a plan for the prepared statement.
C
'PREPARE' can only specify 'SELECT' as a prepared statement.
D
'EXECUTE' executes the plan defined by 'PREPARE'.
E
'DEALLOCATE' deallocates prepared statements.

Reveal answer details Close answer details

Correct answerC

Question 21

Single choice

Select one incorrect statement concerning the relational data model.

A
It expresses the real world in a collection of 2-dimensional tables called a relation.
B
It is a model based on set theory.
C
It has a logical structure independent of physical data structure.
D
It is made up of a multiple stage hierarchy where each of the set elements has parent child relationships.
E
It is a model that was proposed by E.
F
Codd in 1970.

Reveal answer details Close answer details

Correct answerD

Question 22

Single choice

Select the correct SQL statement that records the space occupied by deleted or updated rows for later reuse, and also updates statistics.

A
VACUUM
B
VACUUM ANALYZE
C
EXPLAIN
D
EXPLAIN ANALYZE
E
NOTIFY

Reveal answer details Close answer details

Correct answerB

Free PGCES-02 Exam Dumps Preview

PostgreSQL CE 8 Silver

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15

QUESTION 16

QUESTION 17

QUESTION 18

QUESTION 19

QUESTION 20

QUESTION 21

QUESTION 22

VOL	TYPE	QUESTIONS
1	Single choice	14
2	Multiple choice	8