PGCES-02 Exam Questions

Select two correct statements about the command shown below. Note: $ is the command prompt. $ pg_ctl reload

I would like to set the default character encoding for the client to Unicode. Select the most appropriate configuration parameter in postgresql.conf from those below.

Select two correct statements about the command shown below. Note: $ is the command prompt. $ dropdb -U foo foodb

I would like to copy a database cluster directory for backup. Select two incorrect statements from below.

The tables "t1" and "t2" are defined below. Tables "t1" and "t2" have columns "id" that are of INTEGER type, and columns "name" that are of TEXT type. t1 t2 The following SQL comma...

Select the SQL command that must be executed prior to executing the EXECUTE command.

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

What happens if an SQL statement syntax error occurs while a transaction is running? Select the correct action from below.

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

In the "customer" table, you want to change the "email" values which have an "id" value of 10000 or less, to NULL. Select the correct SQL statement to achieve this task.

Select one incorrect description regarding the following SQL statement defining a function. CREATE OR REPLACE FUNCTION get_file_list(TEXT, BOOLEAN) RETURNS SETOF TEXT LANGUAGE C ST...

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

The tables "s1" and "s2" are defined below. The column "id" for tables "s1" and "s2" is of INTEGER type. The column "enable" for table "s1" is Of BOOLEAN type, and the column "name...

A table is defined as below. Select the most suitable description about the foreign key constraint. CREATE TABLE master (id INTEGER PRIMARY KEY, name TEXT); CREATE TABLE record (id...

You want to create a cursor that will SELECT the "customer" table. The created cursor must be able to move in any direction and reference data even after the end of the transaction...

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

The "sample" table consists of the data below. The column "x" is of type INTEGER. How many PostgreSQL CE PGCES-02 Exam rows are returned by executing the following SQL statement? S...

Select the correct SQL statement to define a new data type.

Select two appropriate statements from below about the following SQL statements: CREATE FUNCTION myfunc(INTEGER) RETURNS text LANGUAGE plpgsql STRICT AS ' DECLARE x ALIAS FOR $1; r...

The table "t1" is defined by the following SQL statement: CREATE TABLE t1 (id integer, name varchar(20)); PostgreSQL CE PGCES-02 Exam You want to increase the execution speed of th...

The tables "t1" and "t2" are defined in the same way (they have the same data types and column names). You want to select rows in "t1" which are not in "t2". Select a correct keywo...

Select two suitable statements about the BSD license from below.

Which normal form has the constraint that there must be no tables with duplicate column values in the same row?

Select one incorrect statement concerning changes from PostgreSQL version 7.4 to 8.0.

Select one false statement about the benefits of using database management systems from below.

Select two incorrect statements about the Point-In-Time Recovery (PITR) from below.

Select one incorrect description about changing the settings of PostgreSQL during operation.

Which psql command do you need to execute to display the list of tables in the currently connected database?

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

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

PostgreSQL CE PGCES-02 Exam 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)

Select two incorrect statements concerning the system catalog.

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

What phenomenon occurs if PostgreSQL is used without performing VACUUM ? Select two appropriate descriptions from those below.

PostgreSQL CE PGCES-02 Exam Select the most appropriate statement about the initdb command.

Select the most suitable statement about the creation of a new database.

What does the following command do? Choose two incorrect statements from the selection below. Note: $ is the command prompt. $ pg_restore -U postgres -d database1 database1.dump

Select one incorrect statement about the command shown below. Note: $ is the command prompt. $ dropuser -U admin foo

Select an appropriate command to check the PostgreSQL version in psql.

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

What does the following command do? Choose the most appropriate statement from the selection below. Note: $ is the command prompt. $ pg_dump postgres > pgsql

Select two incorrect statements regarding large objects.

Select two incorrect descriptions regarding the following SQL statements. CREATE TABLE cities ( name text, population float ); CREATE TABLE capitals ( state char(2) ) INHERITS (cit...

Select two SQL statements which abort a transaction.

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 i FROM sample GROUP BY i HAVING count(*) = 2; How many rows are returned by executing the following SQL statement?

A table is defined as follows: CREATE TABLE t (id INT, val TEXT); Select two correct statements from below about the function "get_head" defined below. CREATE FUNCTION get_head(BOO...

A set of tables are defined as follows: t1 PostgreSQL CE PGCES-02 Exam t2 How many rows are returned by executing the following SQL statement? SELECT t1.name FROM t1 CROSS JOIN t2;

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 correct result value. SELECT sco...

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