Download PostgreSQL-CE : PGCES-02 Fragen & Antworten als PDF & Test Software

Von der kostenlosen Demo über 145 Übungsfragen bis zur 365-tägigen Aktualisierung: ZertSoft begleitet Ihre gesamte Vorbereitung auf die PostgreSQL-CE PostgreSQL CE 8 Silver. Konzentrieren Sie sich 2026 auf das Wesentliche – das Bestehen der PGCES-02 Prüfung.

PostgreSQL-CE PGCES-02 Prüfungsübersicht:

PostgreSQL-CE PGCES-02 Prüfungsthemen:

FAQ: Die wichtigsten Fragen zur PGCES-02 Prüfung

PostgreSQL-CE PostgreSQL CE 8 Silver PGCES-02 Prüfungsfragen mit Lösungen

Frage #1

In the "customer" table, you want to change the "email" values which have an "id" value of 10000 or less, to NULL. Select the correct SQL statement to achieve this task.

A. UPDATE customer SET email = NULL WHERE id <= 10000;
B. UPDATE customer SET email IS NULL WHERE id < 10001;
C. UPDATE FROM customer SET email = NULL WHERE id <= 10000;
D. UPDATE email = NULL FROM customer WHERE id <= 10000;
E. DELETE FROMcustomer.email WHERE id < 10001;

Frage #2

I would like to set the default character encoding for the client to Unicode.
Select the most appropriate configuration parameter in postgresql.conf from those below.

A. client_encoding = UNICODE
B. default_encoding = UTF8
C. encoding = UTF8
D. backend_encoding = UNICODE
E. frontend_encoding = UNICODE

Frage #3

The following question concerns the use of multibyte characters in PostgreSQL.
Select two correct items about character encoding in PostgreSQL.

A. Only a single character encoding can be specified for each database cluster.
B. "./configure --enable-multibyte" must be designated at time of build.
C. Character encoding can be set on a per database basis.
D. When the database cluster is initialized,the or --multibyte option must be specified.
E. Different character encodings can be specified for server and clients.

Frage #4

SQL statements were executed in the following order. CREATE TABLE book (id VARCHAR(21), title TEXT NOT NULL, price INT, UNIQUE (id), CHECK (price > 0) );
INSERT INTO book VALUES ('4-12345-678-9', 'SQL book', 2300); --(1) INSERT INTO book (title,
price) VALUES ('PostgreSQL', 3000); --(2) UPDATE book SET id = '4-12345-678-9' WHERE id IS NULL; --(3)
DELETE FROM book WHERE price < 0; --(4)
While executing, select the first location that generates an error.

A. (4)
B. (1)
C. (3)
D. No error is generated.
E. (2)

Frage #5

Select two suitable statements about sequences.

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

Fragen und Antworten: