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

A. You can use the databases of the old major version.

B. To use the data from the old version, you only need to replace the program.

C. To use the data from the old version, you need to conduct a backup and restore.

D. There is a possibility of configuration parameter changes after major version upgrades.

E. Upgrade scripts can be executed while the old version of PostgreSQL is running.

Select one incorrect statement concerning the relational data model.

A. It expresses the real world in a collection of 2-dimensional tables called a relation.

B. It is a model based on set theory.

C. It has a logical structure independent of physical data structure.

D. It is made up of a multiple stage hierarchy where each of the set elements has parent child relationships.

E. It is a model that was proposed by E.F. Codd in 1970.

Select two correct statements that describe what occurs on the client side when the following command is executed.

pg_ctl -m smart stop

A. Clients will not be able to make new connections.

B. The running transaction for a connected client is rolled back and the connection is disconnected forcibly.

C. Connections are terminated after the currently running transactions have finished.

D. The processes of currently connected clients are processed normally.

E. Connected clients receive a message saying that the server will soon be shutdown.

What happens if an SQL statement syntax error occurs while a transaction is running? Select the correct action from below.

A. The transaction continues.

B. The transaction is aborted and a new transaction is started automatically.

C. The transaction is stopped and you cannot issue any SQL commands other than a command to end the transaction.

D. The connection is terminated.

E. The "postmaster" process is terminated.

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';

A. This function may be defined in 'myfuncs.so'.

B. This function can return multiple rows.

C. This SQL statement defines a function written in the C language.

D. If this function is called with a NULL parameter, it will return 0 when executed.

E. This function operates with the authority of the user who executed it.

Select one incorrect statement concerning changes from PostgreSQL version 7.4 to 8.0.

A. SAVEPOINT function was added.

B. Point-In-Time Recovery function was added.

C. The shared buffer control algorithm was improved.

D. Two-phase commit function was added.

E. CSV mode was added to the copy command.

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

A. SELECT * FROM pg_table_list;

B. SHOW tables;

C. \dT

D. \dt "database_name"

E. \dt

What does the following command do? Select the correct description from below. Note:

"text=#" is the command prompt for psql.

test=# ANALYZE foo;

A. Collects statistical information related to the content of the database foo.

B. Collects statistical information related to the content of the table foo.

C. Collects statistical information related to the content of the database test.

D. Outputs statistical information related to the content of the table foo.

E. The command does not generate an error; however, it does not do anything either.

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

A. If the company table is not readable, an error occurs.

B. The content of the company table is written into a file called 'stdout'.

C. The content of the company table is output in TAB delimited format.

D. An error occurs unless the user foo has administrator privileges.

E. Connects to the database bar.

Select two correct statements from below concerning the ANALYZE command.

A. It renews the statistical information of the table content.

B. It takes some time to execute, but it does not lock the table.

C. If the FULL option is used when executing, the size of the file can be reduced.

D. If ANALYZE is insufficient, the most efficient search plan will not be selected for queries.

E. If ANALYZE is not used at all, there are times when it becomes impossible to see any of the data.