PGCES-02 Exam Questions
142 real PGCES-02 exam questions with expert-verified answers and explanations. Page 2 of 3.
- Question #51
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;
- Question #52
Select one incorrect statement about schemas.
- Question #53
Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.
- Question #54
Select an incorrect statement regarding prepared statements, and 'PREPARE' / 'EXECUTE' commands.
- Question #55
Select one statement which will cause a syntax error.
- Question #56
Select two incorrect statements regarding 'TRIGGER'.
- Question #57
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...
- Question #58
What does the following command do? Choose one incorrect statement from the selection below. $ pg_dumpall -U postgres > 20060601.bak
- Question #59
Select one incorrect statement about the SQL COPY command.
- Question #60
Select two incorrect statements about the function of the information schema.
- Question #61
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...
- Question #62
Select two suitable statements about postgresql.conf configuration.
- Question #63
Select two commands below from which privileges cannot be changed by the GRANT and REVOKE statements.
- Question #64
Select two correct statements about the command shown below. Note: $ is the command prompt. $ vacuumdb -az
- Question #65
Select two commands used to check the syntax of the ALTER TABLE statement in psql.
- Question #66
Select one incorrect statement from the below about a database cluster.
- Question #67
Select one SQL statement that will cause an error.
- Question #68
Select two statements that the command below DOES NOT do. Note: $ is the command prompt. $ pg_dump -b -F c b > d
- Question #69
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...
- Question #70
Select two suitable statements regarding a postmaster process.
- Question #71
Select a correct SQL command to change existing user "george"'s password to "foobar".
- Question #72
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...
- Question #73
Select two correct statements from below concerning the ANALYZE command.
- Question #74
Select two suitable statements regarding the following SQL statement: CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();
- Question #75
Select two transaction isolation levels supported in PostgreSQL.
- Question #76
PostgreSQL can use an index to access a table. Select two incorrect statements about indexes.
- Question #77
Select two incorrect statements regarding 'DOMAIN'.
- Question #78
Select two suitable statements regarding the data types of PostgreSQL.
- Question #79
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...
- Question #80
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...
- Question #81
Select two suitable statements about sequences.
- Question #82
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?
- Question #83
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...
- Question #84
Select the correct SQL statement which concatenates strings 'ABC' and 'abc' to form 'ABCabc'.
- Question #85
Select two correct descriptions about views.
- Question #86
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;...
- Question #87
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...
- Question #88
Select three SQL statements which return NULL.
- Question #89
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 ----+-------------...
- Question #90
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?
- Question #91
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;
- Question #92
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...
- Question #93
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...
- Question #94
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...
- Question #95
The following is the result of executing the createlang command which is installed with PostgreSQL. $ createlang -U postgres --list mydb Procedural Languages Name | Trusted? ------...
- Question #96
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);
- Question #97
Select two suitable statements regarding creating a new table.
- Question #98
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...
- Question #99
Select two suitable statements about major version upgrades of PostgreSQL from below.
- Question #100
Select one incorrect statement concerning the relational data model.