PostgreSQL PGCES-02 PostgreSQL CE 8 Silver Exam Practice Test

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 When user foo connects to database bar from host IP address 172.16.1.2, I would like password verification to not be performed. Select one appropriate line for the new pg_hba.conf file.

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 after execution. BEGIN; INSERT INTO t1 VALUES ('A'); SAVEPOINT sp; INSERT INTO t1 VALUES ('B'); ROLLBACK TO sp; INSERT INTO t1 VALUES ('C'); COMMIT;

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)

ALTER TABLE foo ADD COLUMN c1 TEXT; ---- (2) ALTER

TABLE foo ADD UNIQUE (c1); ------- (3) ALTER TABLE foo

DROP COLUMN bar; ------- (4) Select the correct statement from those below.

From the SQL commands below, select one that is generally classified as "DDL".

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

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

Select two incorrect statements related to the command below.

Note: $ is the command prompt. $ psql -U foo -c "COPY company TO stdout;" bar