PostgreSQL CE 8 Silver: PGCES-02

Select two transaction isolation levels supported in PostgreSQL.

A. DIRTY READ

B. READ COMMITTED

C. REPEATABLE READ

D. PHANTOM READ

E. SERIALIZABLE

Select two incorrect statements about the Point-In-Time Recovery (PITR) from below.

A. This is a backup method integrating a physical backup and a transaction log (WAL).

B. It is necessary to stop the database server to perform a backup for the first time.

C. Updated data is continuously saved.

D. A restore can be performed to any arbitrary point in time since the starting point of PITR.

E. A backup can only be performed on a per-database basis.

Select two incorrect statements concerning the system catalog.

A. It stores the object definition information for tables and columns.

B. There may be changes to specification by major version upgrades.

C. It is accessible as a table; however, it is output in binary format so it can not be read as is.

D. It stores the internal information of the database management system.

E. It is defined based on the standard SQL specification.