PostgreSQL-CE PostgreSQL CE 8 Silver - PGCES-02 Free Exam Questions

A. A postmaster process is created for each client connection.

B. A postmaster process receives and processes database queries.

C. A postmaster process creates a child process which processes the given queries.

D. A postmaster process collects statistical information.

E. A postmaster process waits for client connection requests.

A. SELECT * FROM item
WHERE cid IN (SELECT cid FROM customer);

B. SELECT * FROM sale
WHERE cid = ANY (SELECT cid FROM customer);

C. SELECT (SELECT item FROM sale WHERE id = 1);

D. SELECT * FROM (SELECT * FROM customer);

E. SELECT * FROM sale
WHERE name IN (SELECT name FROM names);

A. A sequence number can be set by calling the "setval" function.

B. A sequence always returns a 4-byte INTEGER type value, so the maximum value is 2147483647.

C. A sequence is defined by 'CREATE SEQUENCE', and deleted by 'DROP SEQUENCE'.

D. A sequence always generates 0 or consecutive positive numbers.

E. Although the "nextval" function is called during a transaction, it will have no effect if that transaction is rolled back.

A. The database can not be accessed until this command is finished.

B. Processes the job equivalent of the VACUUM FULL command for all of the databases.

C. Collects statistical information related to the table content for all of the databases.

D. Recovers unused areas from all of the databases.

E. Processes the job equivalent of the VACUUM VERBOSE command for all of the databases.

A. A corresponding rule is automatically created when a trigger is created.

B. When INSERT is executed to thetable, the specified function can be called.

C. When SELECT is executed to thetable, the specified function can be called.

D. When UPDATE is executed to thetable, the specified function can be called.

E. A trigger can be set up to call a specified function before or after the event occurs.

A. DELETE FROMcustomer.email WHERE id < 10001;

B. UPDATE customer SET email = NULL WHERE id <= 10000;

C. UPDATE email = NULL FROM customer WHERE id <= 10000;

D. UPDATE FROM customer SET email = NULL WHERE id <= 10000;

E. UPDATE customer SET email IS NULL WHERE id < 10001;