Online Access Free PGCES-02 Exam Questions

Select one option which cannot be specified using createdb.

• A.Template database
• B.Database locale
• C.Character encoding
• D.Host name
• E.Database owner

A table named "sample" is defined as below. Select two statements which will generate a
constraint error.
CREATE TABLE sample (
i INTEGER PRIMARY KEY,
j INTEGER,
CHECK ( i > 0 AND j < 0 )
);

• A.INSERT INTO sample VALUES (5, -5);
• B.INSERT INTO sample VALUES (1, 0);
• C.INSERT INTO sample VALUES (2, -2);
• D.INSERT INTO sample VALUES (3, NULL);
• E.INSERT INTO sample VALUES (NULL, -4);

Based on the relationship of columns within a table, select the most suitable description that
shows that column A is dependent on column B.

• A.The value in column A is uniquely determined when a value in column B is selected.
• B.When the value in column A is changed, the corresponding value in column B also must be changed.
• C.The value in column B is uniquely determined when a value in column A is selected.
• D.As long as column B exists, the amount of information will not decrease even if column A is deleted.
• E.When the value in column B is changed, the corresponding value of column A also must be changed.

A set of tables are defined as follows:
t1 t2 How many rows are returned by executing the following SQL statement?
SELECT t1.name FROM t1 CROSS JOIN t2;

• A.2 rows
• B.0 rows
• C.6 rows
• D.3 rows
• E.5 rows

Select two incorrect statements about the Point-In-Time Recovery (PITR) from below.

• A.A backup can only beperformed on a per-database basis.
• B.This is a backup method integrating a physical backup and a transaction log (WAL).
• C.Updated data iscontinuously saved.
• D.A restore can be performed to any arbitrary point in time since the starting point of PITR.
• E.It is necessary to stop the database server to perform a backup for the first time.