PostgreSQL PGCES-02 PostgreSQL CE 8 Silver Exam Practice Test

Select two suitable statements regarding a postmaster process.

The table "custom" is defined below. The "id" column and "introducer" column are of

INTEGER type, and the "email" column is of TEXT type.

id | email | introducer ----+-- ---------------+-----------2 |

aaa@example.com | 1 3 |

bbb@example.com | 2 4 |

ccc@example.com | 2

Three SQL statements were executed in the following order:

UPDATE custom SET email = '' FROM custom c WHERE

custom.introducer = c.id; UPDATE custom SET introducer = NULL

WHERE introducer NOT IN (SELECT id FROM custom); DELETE

FROM custom WHERE id = 2 OR introducer = 2; Select the number of rows in the "custom" table after the execution.

Select two SQL statements which abort a transaction.

Select two incorrect descriptions regarding the following SQL statements.

CREATE TABLE cities ( name text,

population float ); CREATE

TABLE capitals ( state

char(2) ) INHERITS

(cities);

Select two incorrect statements regarding large objects.

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 the two SQL statements that will generate an error when executed next.

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;