PGCES-02 무료 덤프문제 온라인 액세스

Select two suitable statements about postgresql.conf configuration.

• A.All options have no default values. Therefore, all of them must be set specifically and thoroughly.
• B.The timing of when a change in any value is reflected is different depending on the configuration parameter.
• C.A line that starts with ! (exclamation mark) is interpreted as a comment.
• D.As a boolean value, any of the following can be used: TRUE, FALSE, ON, OFF, YES, NO, 1, 0.
• E.You can have different parameters for the same option to configure each database differently.

Table "t1" is defined below.
Table "t1" has a column "id" of type INTEGER, and a column "name" of type TEXT.
t1:
The following SQL is executed while client "A" is connected. BEGIN;
SELECT * FROM t1 WHERE id = 2 FOR UPDATE;
SELECT * FROM t1 WHERE id = 1 FOR UPDATE; -- (*)
While the second 'SELECT' statement, shown with (*), is being executed, a separate client "B"
connects and executes the following SQL.
Select the correct statement about the execution results.
UPDATE t1 SET name = 'turtle' WHERE id = 2;
Note: the default transaction isolation level is set to "read committed".

• A.The update process for client "B" is blocked until the current transaction for client "A" is finished.
• B.The 'UPDATE' process for client "B" proceeds regardless of the condition of client "A".
• C.The processes for both clients are blocked, and an error stating that a deadlock has been detected is generated.
• D.The update process for client "B" is blocked until the current connection for client "A" is finished.
• E.The process of client "B" immediately generates an error.

Select two correct statements about the command shown below. Note: $ is the command prompt. $ vacuumdb -az

• A.Processes the job equivalent of the VACUUM VERBOSE command for all of the databases.
• B.The database can not be accessed until this command is finished.
• 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 FULL command for all of the databases.

Select two incorrect statements related to the command below. Note: $ is the command prompt. $ psql -U foo -c "COPY company TO stdout;" bar

• A.The content of the company table is written into a file called 'stdout'.
• B.Connects to the database bar.
• C.An error occurs unless the userfoo has administrator privileges.
• D.The content of the company table is output in TAB delimited format.
• E.If the company table is not readable, an error occurs.

Which psql command do you need to execute to display the list of tables in the currently connected database?

• A.\dt "database_name"
• B.SELECT * FROMpg_table_list;
• C.\dt
• D.\dT
• E.SHOW tables;