Get PostgreSQL PGCES-02 Exam Dumps

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: connection authorized: user=postgres database=test

Select two incorrect statements about the function of the information schema.

Select one incorrect statement about the SQL COPY command.

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;

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(BOOLEAN) RETURNS TEXT LANGUAGE sql CALLED ON

NULL INPUT AS 'SELECT val FROM t WHERE $1 OR id > 0 ORDER BY id LIMIT 1;';