Online Access Free PGCES-02 Exam Questions

Select two suitable statements about major version upgrades of PostgreSQL from below.

• A.You can use the databases of the old major version.
• B.There is a possibility of configuration parameter changes after major version upgrades.
• C.To use the data from the old version, you only need to replace the program.
• D.To use the data from the old version, you need to conduct a backup and restore.
• E.Upgrade scripts can be executed while the old version ofPostgreSQL is running.

Select two correct statements from below concerning the ANALYZE command.

• A.If ANALYZE is not used atall, there are times when it becomes impossible to see any of the data.
• B.It renews the statistical information of the table content.
• C.If the FULL option is used when executing, the size of the file can be reduced.
• D.If ANALYZE isinsufficient, the most efficient search plan will not be selected for queries.
• E.It takes some time to execute, but it does not lock the table.

Select the correct result generated by execution of the following SQL statements: CREATE
TABLE log (id int, message TEXT, logtime TIMESTAMP);
CREATE TABLE log_01 () INHERITS (log);
INSERT INTO log_01 VALUES (1, 'error', CURRENT_TIMESTAMP); SELECT * FROM log;

• A.'INSERT' statement generates an error stating that the number of columns and values do not match".
• B.'SELECT' statement returns 1 row, and exits successfully.
• C.'SELECT' statement returns 0 rows, and exits successfully.
• D.First 'CREATE TABLE' generates a syntax error.
• E.Second 'CREATE TABLE' generates a syntax error.

The "sample" table consists of the following data:
How many rows are returned by executing the following SQL statement? SELECT * FROM
sample WHERE v ~ 'ab';

• A.0 rows
• B.2 rows
• C.4 rows
• D.3 rows
• E.1 row

Select two correct statements about the command shown below. Note: $ is the command prompt. $ dropdb -U foo foodb

• A.Iffoo doesn't have the OS superuser privilege, an error will occur.
• B.This command removes all of the objects inside the databasefoodb.
• C.If any table definition remains in databasefoodb, an error will occur.
• D.The same process can be performed using the SQL command "DROP DATABASE".
• E.This command removes databasefoodb.