PGCES-02 Exam Questions

Select two incorrect statements concerning PostgreSQL license.

Select the most suitable statement about PostgreSQL from below.

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

Select one incorrect statement regarding psql.

I would like to insert the contents of the text file users.dat into the table t1 using psql. Contents of text file users.dat: Definition of table t1: CREATE TABLE t1 (uname TEXT, p...

Select one correct statement about the createlang command.

What does the following command do? Select two correct descriptions regarding this SQL statement. SELECT * FROM information_schema.tables;

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

Select the correct command to collect and save the statistical information of a table.

Choose the most suitable statement about user management of PostgreSQL. Note: the version of PostgreSQL is 8.0.

I would like to enable all users to SELECT the "item" table. Select the most appropriate SQL statement from below.

Configuration file pg_hda.conf is set as below on a host currently running PostgreSQL. local all all trust host all all 192.168.1.0/24 reject host all all 192.168.0.0/16 trust Sele...

Select one correct command to shutdown the postmaster AFTER all the clients have disconnected. PostgreSQL CE PGCES-02 Exam

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

Select one option which cannot be specified using createdb.

You have just added an option "listen_addresses = 'localhost'" in postgresql.conf. When will this setting take effect?

Select two suitable statements regarding the pg_dump command.

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 us...

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

A sequence has the following definition: CREATE SEQUENCE seq1 CACHE 10 CYCLE; Select the value that is returned by executing the following SQL. SELECT nextval('seq1');

PostgreSQL CE PGCES-02 Exam A table and view are defined as follows: CREATE TABLE item (id INT, name TEXT, description TEXT); CREATE VIEW item_simple AS SELECT id, name FROM item;...

The present time is noon of July 7th, 2007, and the result of the following SQL sentence was '2007-07-17 12:00:00'. Select the correct expression to fill in the blank below. SELECT...

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 stat...

You want to delete rows in the "product" table which include the value '2004' in the "name" field. Select the correct statement to achieve this task.

There is a table "tb1" that has a column "c1" defined as type TEXT. The following SQL is executed while client "A" is connected. BEGIN; LOCK TABLE tb1 IN ACCESS EXCLUSIVE MODE; SEL...

The "sample" table consists of the following data. How many rows are returned by executing the following SQL statement? SELECT i FROM sample GROUP BY i; PostgreSQL CE PGCES-02 Exam

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

It is possible to backup a database cluster by copying the entire data directory. Select two suitable descriptions regarding this backup method.

Select two incorrect statements related to the command below. Note: $ is the command prompt. $ psql -U foo -c "COPY company TO stdout;" bar

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

Select the most suitable statement about PostgreSQL from below.

Based on the relationship of columns within a table, select the most suitable description that shows that column A is dependent on column B.

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

From the SQL commands below, select one that is generally classified as "DDL". PostgreSQL CE PGCES-02 Exam

The table "foo" is defined as follows: CREATE TABLE foo (bar TEXT); Next, four SQL statements were executed in the following order. INSERT INTO foo VALUES ('bar'); -------- (1) ALT...

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 =...

PostgreSQL CE PGCES-02 Exam SQL statements were executed in the following order. CREATE TABLE book ( id VARCHAR(21), title TEXT NOT NULL, price INT, UNIQUE (id), CHECK (price > 0)...

Select one incorrect statement concerning the following SQL statement. CREATE OR REPLACE VIEW sales_view AS SELECT * FROM sales_table ORDER BY sales_date DESC LIMIT 10;

A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 LEFT OUTER JOIN t2 USING (id);

Table t1 is defined as follows: CREATE TABLE t1 (value VARCHAR(5)); A set of SQL statements were executed in the following order. Select the number of rows that table "t1" has afte...

SQL statements were executed in the following order: CREATE TABLE fmaster (id INTEGER PRIMARY KEY, name TEXT); CREATE TABLE ftrans (id INTEGER REFERENCES fmaster (id), stat INTEGER...

The table "t1" is defined below. The column "id" for table "t1" is of INTEGER type. id | name ----+------------ 1 | mammoth 2 | tortoise 3 | coelacanth PostgreSQL CE PGCES-02 Exam...