PGCES-02 Exam Questions

A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 UNION ALL SELECT * FROM t2;

Select one incorrect statement about schemas.

Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.

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

Select one statement which will cause a syntax error.

Select two incorrect statements regarding 'TRIGGER'.

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

What does the following command do? Choose one incorrect statement from the selection below. $ pg_dumpall -U postgres > 20060601.bak

Select one incorrect statement about the SQL COPY command.

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

I would like to be able to save log entries as shown below. Select a correct configuration setting from statements below. LOG: connection received: host=[local] port= LOG: connecti...

Select two suitable statements about postgresql.conf configuration.

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

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

Select two commands used to check the syntax of the ALTER TABLE statement in psql.

Select one incorrect statement from the below about a database cluster.

Select one SQL statement that will cause an error.

Select two statements that the command below DOES NOT do. Note: $ is the command prompt. $ pg_dump -b -F c b > d

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 PostgreSQL CE PGCES-02 Exam When user foo connects to databa...

Select two suitable statements regarding a postmaster process.

Select a correct SQL command to change existing user "george"'s password to "foobar".

psql generated the following error message: psql: could not connect to server: Connection was refused Is the server running on host "server.example.com" and accepting TCP/IP connec...

Select two correct statements from below concerning the ANALYZE command.

Select two suitable statements regarding the following SQL statement: CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();

Select two transaction isolation levels supported in PostgreSQL.

PostgreSQL can use an index to access a table. Select two incorrect statements about indexes.

Select two incorrect statements regarding 'DOMAIN'.

Select two suitable statements regarding the data types of PostgreSQL.

The table "score" is defined as follows: gid | score -----+------- 1 | 70 1 | 60 2 | 100 3 | 80 3 | 50 The following query was executed. Select the number of rows in the result. SE...

Table "t1" is defined as follows: PostgreSQL CE PGCES-02 Exam CREATE TABLE t1 (value VARCHAR(5)); A set of SQL statements were executed in the following order.Select thenumber of r...

Select two suitable statements about sequences.

The "sample" table consists of the following data: SELECT DISTINCT ON (data) * FROM sample; How many rows are returned by executing the following SQL statement?

PostgreSQL CE PGCES-02 Exam The following SQL statements were executed using psql. Select the appropriate statement about the result. LISTEN sign_v; BEGIN; NOTIFY sign_v; COMMIT; L...

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

Select two correct descriptions about views.

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

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

Select three SQL statements which return NULL.

The table "custom" is defined below. The "id" column and "introducer" column are of INTEGER type, and the "email" column is of TEXT type. id | email | introducer ----+-------------...

The "sample" table consists of the following data: SELECT * FROM sample WHERE v ~ 'ab'; How many rows are returned by executing the following SQL statement?

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;

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

Four SQL statements were executed in the following order. CREATE TABLE foo (bar INT); ALTER TABLE foo ALTER bar TYPE BIGINT; ALTER TABLE foo ADD baz VARCHAR(5); ALTER TABLE foo DRO...

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

The following is the result of executing the createlang command which is installed with PostgreSQL. $ createlang -U postgres --list mydb Procedural Languages Name | Trusted? ------...

Given the following two table definitions, select one SQL statement which will cause an error. CREATE TABLE sample1 (id INTEGER, data TEXT); CREATE TABLE sample2 (id INTEGER);

Select two suitable statements regarding creating a new table.

The tables "t1" and "t2" are defined below. The tables "t1" and "t2" have columns "id" which are type of INTEGER and column "name"s which PostgreSQL CE PGCES-02 Exam are type of TE...

Select two suitable statements about major version upgrades of PostgreSQL from below.

Select one incorrect statement concerning the relational data model.