PostgreSQL-CE PGCES-02 dumps - 100% Pass Guarantee!

Select two correct descriptions about views.

A. A view is created by 'DECLARE VIEW', and deleted by 'DROP VIEW'.

B. A view is a virtual table which does not exist.

C. A view is created to simplify complicated queries.

D. You can create a view with the same name as already existing tables.

E. A view only exists while the postmaster is running, and is deleted when the postmaster stops.

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 tables "t1" and "t2" are defined below. Tables "t1" and "t2" have columns "id" that are of INTEGER type, and columns "name" that are of TEXT type. t1 t2 The following SQL command was executed. Select the number of rows in the result. SELECT

*

FROM t1 RIGHT OUTER JOIN t2 ON t1.id = t2.id;

A.

2 rows

B.

3 rows

C.

4 rows

D.

5 rows

E.

6 rows

What does the following command do? Choose the most appropriate statement from the selection below.

Note: $ is the command prompt.

$ pg_dump postgres > pgsql

A. Writes a backup of the database postgres to the file pgsql.

B. Writes a backup of the entire database cluster using user postgres to the file pgsql.

C. Backs up the database postgres and writes an error message to the file pgsql.

D. Writes a backup of the entire database cluster to the file postgres and writes an error message to the file pgsql.

E. Outputs all of the content of the database postgres to the screen using the user pgsql.

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

A. It consists of a group of views included in a schema called "information_schema".

B. Information on objects defined in a database can be referenced.

C. The number of tables defined in a database can be confirmed.

D. Administrator privileges are needed to reference the information schema.

E. In order to enable the information schema, "information_schema = true" must be set in postgresql.conf