PostgreSQL certification preparation

PGCES-02 Practice Questions

Practice exam-style questions, check your answers, and review explanations and source references where they are available.

Exam
PGCES-02
Provider
PostgreSQL
Full set
142 questions
Last Update Check
Browse PostgreSQL exams View exam questions

Our PGCES-02 practice quiz assesses your knowledge across all the core domains of the certification. It covers key concepts, technical configurations, and real-world troubleshooting scenarios. We provide detailed answer explanations for every single one of our PGCES-02 sample questions so you can truly understand the material. For complete preparation, be sure to check out our premium PGCES-02 exam simulator.

Get Full Access
Select a correct SQL command to change existing user "george"'s password to "foobar".
Answer options
A sequence has the following definition: CREATE SEQUENCE seq1 CACHE 10 CYCLE; Select the value that is returned by executing the following SQL. SELECT nextval('seq1');
Answer options
Select two suitable statements regarding the following SQL statement: CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();
Answer options
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';
Answer options
Select one incorrect statement regarding psql.
Answer options
Select two correct statements about the command shown below. Note: $ is the command prompt. $ dropdb -U foo foodb
Answer options
Select the correct SQL statement that records the space occupied by deleted or updated rows for later reuse, and also updates statistics.
Answer options
Select two transaction isolation levels supported in PostgreSQL.
Answer options
Select the SQL command that must be executed prior to executing the EXECUTE command.
Answer options
The table "tbl" is defined below such that it could only store non-negative integers in the column "nn". Select the keyword that is applicable for the underlined blank. CREATE _______ natural_number AS DECIMAL CHECK (VALUE >= 0); CREATE TABLE tbl(nn natural_number);
Answer options
Question 1 of 10

Source context

How this practice set is maintained

Maintained by the CertMage content team, this page loads questions from the exam dataset connected to its preparation resource. When an answer includes a supporting reference, it is shown with that answer so you can review the underlying vendor documentation.

Certification objectives, interfaces, and vendor services can change. Verify important details against the provider's current exam guide and documentation before your exam.

Scroll to Top