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

Select the correct SQL statement that records the space occupied by deleted or updated rows for later reuse, and also updates statistics.

A. VACUUM

B. VACUUM ANALYZE

C. EXPLAIN

D. EXPLAIN ANALYZE

E. NOTIFY

The "sample" table consists of the following data. How many rows are returned by executing the following SQL statement?

SELECT i FROM sample GROUP BY i;

A. 1 row

B. 2 rows

C. 3 rows

D. 4 rows

E. 5 rows

Select the most suitable statement about the creation of a new database.

A. Only a PostgreSQL superuser is authorized to create a new database.

B. The target directory is specified by the environment variable PGDATA or the -D parameter when creating a database.

C. Only one database can be used at the same time even if two or more databases are created.

D. Only the OS superuser (root) can create databases.

E. You can set the character encoding when creating a new database.

I would like to check the privileges on the "items" table in psql. Select the most appropriate command.

A. \a items

B. \d items

C. \t items

D. \p items

E. \z items

Select two statements that the command below DOES NOT do. Note: $ is the command prompt. $ pg_dump -b -F c b > d

A. Backs up the "b" database to the "c" file, and stores error messages to the "d" file.

B. Backs up the "b" database to the "d" file.

C. Backs up large objects.

D. Backs up the "c" database to the "d" file as the "c" user.

E. Creates a backup, which is restorable with the pg_restore command.