PostgreSQL CE 8 Silver (PGCES-02) - PostSQL - Free Practice

1

Question

There is a table "tb1" that has a column "c1" defined as type TEXT. The following SQL is executed
while client "A" is connected. BEGIN; LOCK TABLE tb1 IN ACCESS EXCLUSIVE MODE; SELECT * FROM
tb1; While the above 'SELECT' statement is being executed, client "B" connects to the same database and executes the following SQL. Select two correct statements describing the behavior of PostgreSQL. INSERT INTO tb1 (c1) VALUES ('new line'); Note: the default transaction isolation level is set to "read committed".

Select 2

Options

A The process of client "B" will affect the SELECT result of client "A".

B The process of client "B" will not affect the SELECT result of client "A".

C The process for client "B" is blocked until the current connection for client "A" is finished.

D The process for client "B" is blocked until the current transaction for client "A" is finished.

E The process for client "B" will be deleted regardless of the condition of client "A".

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2

Question

What phenomenon occurs if PostgreSQL is used without performing VACUUM ?
Select two appropriate descriptions from those below.

Select 2

Options

A Only SELECT queries will be accepted.

B An e-mail prompting the administrator to perform VACUUM is sent from PostgreSQL.

C Performance is reduced.

D It gradually gets to the point where connections are denied.

E The physical size of the database increases considerably in size.

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3

Question

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

Options

A 3 rows

B 4 rows

C 0 rows

D 1 row

E 2 rows

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4

Question

I would like to copy a database cluster directory for backup.
Select two incorrect statements from below.

Select 2

Options

A A database cluster that has been restored can be used on a newer version of PostgreSQL.

B A database cluster that has been restored can be used on an older version of PostgreSQL.

C The directory must be copied after stopping the database server.

D When using the Tablespace function, it is necessary to back up the directory that stores the tablespace as well.

E A database cluster that has been restored can be used on a separate machine with the same structure.

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5

Question

A table is defined as follows: CREATE TABLE t (id INT, val TEXT); Select two correct statements from below about the function "get_head" defined below. CREATE FUNCTION get_head(BOOLEAN) RETURNS TEXT LANGUAGE sql CALLED ON
NULL INPUT AS 'SELECT val FROM t WHERE $1 OR id > 0 ORDER BY id LIMIT 1;';

Select 2

Options

A Even if this function is passed the same parameter value and executed multiple times, the returned values will not necessarily also be the same value.

B If a function with the same name and with type BOOLEAN as the parameter is already defined, an
error occurs.

C This function is defined using PL/pgSQL.

D There are cases where this function returns multiple lines.

E When NULL is passed for the argument and the function is executed, NULL is returned.

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

PostgreSQL CE 8 Silver (PGCES-02) - PostSQL Exam Questions

Delete Comment

Delete Comment

Delete Comment

Delete Comment

Delete Comment

Finish Practice?