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

You need to reload the PostgreSQL configuration without restarting the server. Which function should you use?

Options :

A : pg_restart_conf()

B : pg_reload_conf()

C : reload_configuration()

D : refresh_config()

Answer: B

Question 3

Which command in psql toggles between aligned and unaligned output mode?

Options :

A : \a

B : \t

C : \align

D : \format

Answer: A

Question 4

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

Question 5

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

Higher Test Marks with Free Online PostgreSQL-Essentials-v13 Exam Practice