PostgreSQL PGCES-02 Exam Questions Instant Access

Question 1

Select two suitable statements regarding creating a new table.

AThere is no upper limit to the number of columns in a table.

BA newly created table is empty and has 0 rows.

CYou can only use alphabetic characters for a table name.

DThe row name must be within 16 characters.

EThe SQL 'CREATE TABLE' statement is used to create a new table.

Answer : B, E

Question 2

Select two suitable statements regarding the following SQL statement:

CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();

AIt is defining a trigger 'trigger_1'.

BEvery time 'UPDATE' is executed on the 'sales' table, the 'write_log' function is called once.

CThe 'write_log' function is called before 'UPDATE' takes place.

D'UPDATE' is not executed if 'write_log' returns NULL.

E'DROP TRIGGER trigger_1 ON sales;' deletes the defined trigger.

Answer : A, E

Question 3

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

AThe current value of a parameter can be confirmed using the SHOW command.

BAll of the current settings can be displayed using the SHOW ALL command.

CChanges that can be made using the SET command have higher priority than ones in postgresql.conf.

DValues set by a superuser using the SET command are valid for different connections made later.

EThere are parameters that can not be set using the SET command

Answer : D

Question 4

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

Apg_dump -R foo < foo.dump

Bpg_restore -d foo foo.dump

Cpg_restore -f foo.dump foo

Dpsql -f foo.dump foo

Ecreatedb foo < foo.dump

Answer : D

Question 5

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

AAn index is created by 'CREATE INDEX', and deleted by 'DROP INDEX'.

BBy using an index effectively, searching and sorting performs faster.

CThere are B-tree, Hash, R-tree and GiST index types.

DBy creating an index, performance always improves.

ECreating an unused index does not affect the performance of a database at all.

Answer : D, E

Question 6

Select two incorrect statements concerning PostgreSQL license.

AIt can be used freely.

BIt can be duplicated freely.

CIt can be freely redistributed.

DDevelopers are responsible for its maintenance support.

EDevelopers are only responsible for handling its crucial faults.

Answer : D, E

Question 7

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 command was executed. Select the number of rows in the result. SELECT * FROM t1 RIGHT OUTER JOIN t2 ON t1.id = t2.id;

A2 rows

B3 rows

C4 rows

D5 rows

E6 rows

Answer : B

PostgreSQL CE 8 Silver PGCES-02 Exam Questions