Free PostgreSQL CE 8 Silver PGCES-02 Exam Practice Test

Select the SQL command that must be executed prior to executing the EXECUTE command.

• CREATE FUNCTION
• PREPARE
• DECLARE
• LOAD
• ALLOCATE

The tables "t1" and "t2" are defined in the same way (they have the same data types and column names). You want to select rows in "t1" which are not in "t2". Select a correct keyword to fill in the blank below. SELECT * FROM t1 SELECT * FROM t2;

• EXCEPT
• UNION
• NAND
• INTERSECT
• INTERSECT ALL

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

• It consists of a group of views included in a schema called "information_schema".
• Information on objects defined in a database can be referenced.
• The number of tables defined in a database can be confirmed.
• Administrator privileges are needed to reference the information schema.
• In order to enable the information schema, "information_schema = true" must be set in postgresql.conf

Select two correct statements about the command shown below. Note: $ is the command prompt. $ pg_ctl reload

• The command forces the content of pg_hba.conf to be re-read into PostgreSQL server process.
• The command temporarily stops the PostgreSQL server process and restart it.
• The command re-reads the postgresql.conf details into the PostgreSQL server process and changes the values of any configuration parameters that can be changed.
• The command forces the content of the database cluster to be re-read into PostgreSQL server process.
• The command causes a recovery to be performed from a standard backup file in the PostgreSQL server process.

Select one false statement about the benefits of using database management systems from below.

• You can separate the data storage method from the application.
• You can separate the data search method from the application.
• You can separate the data display method from the application.
• You can reduce the programming workload of programming for managing data.
• You can share data more easily on systems consisting of multiple computers.

Select two suitable statements about sequences.

• A sequence always returns a 4-byte INTEGER type value, so the maximum value is 2147483647.
• A sequence is defined by 'CREATE SEQUENCE', and deleted by 'DROP SEQUENCE'.
• Although the "nextval" function is called during a transaction, it will have no effect if that transaction is rolled back.
• A sequence always generates 0 or consecutive positive numbers.
• A sequence number can be set by calling the "setval" function.

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.

Select one incorrect statement concerning the relational data model.

• It expresses the real world in a collection of 2-dimensional tables called a relation.
• It is a model based on set theory.
• It has a logical structure independent of physical data structure.
• It is made up of a multiple stage hierarchy where each of the set elements has parent child relationships.
• It is a model that was proposed by E.F . Codd in 1970.

Select one incorrect description regarding the following SQL statement defining a function.CREATE OR REPLACE FUNCTION get_file_list(TEXT, BOOLEAN) RETURNS SETOF TEXT LANGUAGE C STRICT SECURITY DEFINER AS 'myfuncs.so';

• This function may be defined in 'myfuncs.so'.
• This function can return multiple rows.
• This SQL statement defines a function written in the C language.
• If this function is called with a NULL parameter, it will return 0 when executed.
• This function operates with the authority of the user who executed it.

Select two commands below from which privileges cannot be changed by the GRANT and REVOKEstatements.

• SELECT
• VACUUM
• DELETE
• TRIGGER
• DROP