PostgreSQL CE 8 Silver: PGCES-02

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, date

DATE); INSERT INTO fmaster VALUES (1, 'itemA');

INSERT INTO ftrans VALUES (1, 1, CURRENT_DATE);

Select two SQL statements that will generate an error when executed next.

A. INSERT INTO ftrans VALUES (1, 1, CURRENT_DATE);

B. INSERT INTO ftrans VALUES (2, 1, '2007-07-07');

C. UPDATE fmaster SET name = 'itemAX' WHERE id = 1;

D. UPDATE fmaster SET id = 100 WHERE id = 1;

E. UPDATE ftrans SET id = 200 WHERE id = 1;

The present time is noon of July 7th, 2007, and the result of the following SQL sentence was '2007-07-17

12:00:00'.

Select the correct expression to fill in the blank below.

SELECT CURRENT_TIMESTAMP::timestamp + ;

A. '10 day'::timestamp

B. '10 day'::interval

C. 10::day

D. 8640000::time

E. age(8640000)

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.

A. Add "host foo bar 172.16.1.2/32 trust" to the first row.

B. Add "host bar foo 172.16.1.2/32 trust" to the first row.

C. Add "host foo bar 172.16.1.2/32 trust" to the last row.

D. Add "host bar foo 172.16.1.2/32 trust" to the last row.

E. The settings are fine as is.