Get PostgreSQL PGCES-02 Exam Practice Questions - Real and Updated

The "sample" table consists of the following data: How many rows are returned by executing the following SQL statement? SELECT * FROM sample WHERE v ~ 'ab';

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

INSERT INTO log_01 VALUES (1, 'error', CURRENT_TIMESTAMP);

SELECT * FROM log;

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 keyword to fill in the blank below. SELECT * FROM t1 ______ SELECT * FROM t2;

The following SQL statements were executed using psql.

Select the appropriate statement about the result.

LISTEN sign_v; BEGIN; NOTIFY sign_v; COMMIT;

LISTEN sign_v;

A table named "sample" is defined as below. Select two statements which will generate a constraint error. CREATE TABLE sample ( i INTEGER PRIMARY KEY, j INTEGER,

CHECK ( i > 0 AND j < 0 ) );