Question 1

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 2

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

Options :

A : \a

B : \t

C : \align

D : \format

Answer: A

Question 3

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 4

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 5

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