Logo ExamsQA
Exit
Official Bank 0/142

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

Last updated on June 20, 2026

97% Exam Compliance
142 Total Questions
1
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!

2
Question
Based on the following request, select the most appropriate command for creating a database cluster. ?Character encoding of the template database needs to be EUC_JP ?Locale is not used
Options
A initdb --encoding=EUC_JP --no-locale
B pg_ctl init --encoding=EUC_JP
C initdb --locale=EUC_JP --no-encoding
D initdb --default-encoding=EUC_JP
E pg_ctl init --locale=EUC_JP
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
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!

4
Question
Select two incorrect statements regarding 'TRIGGER'.
Select 2
Options
A A trigger can be set up to call a specified function before or after the event occurs.
B A corresponding rule is automatically created when a trigger is created.
C When UPDATE is executed to the table, the specified function can be called.
D When INSERT is executed to the table, the specified function can be called.
E When SELECT is executed to the table, the specified function can be called.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
psql generated the following error message: psql: could not connect to server: Connection was refused Is the server running on host "server.example.com" and accepting TCP/IP connections on port 5432? Select two reasons that are NOT the cause of this error.
Select 2
Options
A The PostgreSQL server is running on a port other than 5432 on "server.example.com".
B The username and/or password are incorrect.
C Host "server.example.com" does not exist.
D The PostgreSQL server is not running on "server.example.com".
E The PostgreSQL server is not accepting TCP/IP connections on "server.example.com".
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.