Free PostgreSQL CE 8 Silver PGCES-02 Exam Practice Test

Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.

• BOOLEAN is an alias of the INTEGER type in PostgreSQL.
• BOOLEAN only takes either NULL, TRUE, or FALSE.
• You can use the characters 't' or 'f' as a value for the BOOLEAN type.
• You can use the TRUE or FALSE keywords as a value for the BOOLEAN type.
• If the INTEGER value of '0' is inserted into a BOOLEAN column, it will be treated as FALSE.

Select two suitable statements regarding the pg_dump command.

• pg_dump is an SQL command.
• Only the user who executed initdb can execute pg_dump.
• pg_dump can create a backup while postmaster is running.
• pg_dump can create a backup while postmaster is stopped.
• pg_dump can create a backup of a specified table.

I would like to enable all users to SELECT the "item" table. Select the most appropriate SQL statement from below.

• GRANT public SELECT ON item;
• GRANT SELECT ON item TO public;
• REVOKE 'r' ON item TO public;
• REVOKE READ ON item TO public;
• REVOKE public SELECT ON item;

The following SQL defines an INSERT with respect to item_view. Select the keyword that is applicable in the underlined blank. CREATE foo AS ON INSERT TO item_view DO INSTEAD INSERT INTO item_table VALUES (NEW.id, NEW.itemname);

• RULE
• VIEW
• TRIGGER
• FUNCTION
• CONSTRAINT

Select two incorrect statements regarding large objects.

• A large object is generated by 'CREATE LARGE OBJECT'.
• A large object is added by 'INSERT'.
• One large object is able to handle up to 2GB of data.
• Binary data cannot be used unless declared as a large object.
• An OID is used to identify a large object.

Select three SQL statements which return NULL.

• SELECT 0 = NULL;
• SELECT NULL != NULL;
• SELECT NULL IS NULL;
• SELECT NULL;
• SELECT 'null'::TEXT;

PostgreSQL can use an index to access a table. Select two incorrect statements about indexes.

• An index is created by 'CREATE INDEX', and deleted by 'DROP INDEX'.
• By using an index effectively, searching and sorting performs faster.
• There are B-tree, Hash, R-tree and GiST index types.
• By creating an index, performance always improves.
• Creating an unused index does not affect the performance of a database at all.

From the SQL commands below, select one that is generally classified as "DDL".

• START TRANSACTION
• CREATE TABLE
• SELECT
• INSERT
• DELETE

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

• Backs up the "b" database to the "c" file, and stores error messages to the "d" file.
• Backs up the "b" database to the "d" file.
• Backs up large objects.
• Backs up the "c" database to the "d" file as the "c" user.
• Creates a backup, which is restorable with the pg_restore command.

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

• Only a PostgreSQL superuser is authorized to create a new database.
• The target directory is specified by the environment variable PGDATA or the -D parameter when creating a database.
• Only one database can be used at the same time even if two or more databases are created.
• Only the OS superuser (root) can create databases.
• You can set the character encoding when creating a new database.