Question 1

You want to set the maximum time to complete client authentication to 10 seconds. Which parameter should you configure?

Options :

A : authentication_timeout = 10s

B : auth_timeout = 10s

C : client_timeout = 10s

D : connection_timeout = 10s

Answer: A

Question 2

In PostgreSQL, what does VACUUM do?

Options :

A : Compresses the database

B : Reclaims storage occupied by dead tuples

C : Creates database backups

D : Optimizes query execution plans

Answer: B

Question 3

You need to restore a database from a compressed format backup file created with pg_dump -Fc option. Which utility should you use?

Options :

A : psql

B : pg_restore

C : pg_dump

D : pg_basebackup

Answer: B

Question 4

While connected to a PostgreSQL database using psql, you want to toggle the timing information of some queries. Which of the following options can be used to achieve this?

Options :

A : \time on

B : \timing

C : \time off

D : \t

Answer: B

Question 5

Which utility is used to take a backup of all databases in a PostgreSQL cluster including roles and tablespaces?

Options :

A : pg_dump

B : pg_dumpall

C : pg_backup

D : pg_clusterbackup

Answer: B