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

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
I want to restore data from a text format backup file foo.dump. Select an appropriate command.
Options
A psql -f foo.dump foo
B createdb foo < foo.dump
C pg_dump -R foo < foo.dump
D pg_restore -d foo foo.dump
E pg_restore -f foo.dump foo
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
Select two suitable statements regarding creating a new table.
Select 2
Options
A The row name must be within 16 characters.
B The SQL 'CREATE TABLE' statement is used to create a new table.
C There is no upper limit to the number of columns in a table.
D A newly created table is empty and has 0 rows.
E You can only use alphabetic characters for a table name.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

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

Finish Practice?

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