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

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 3

You want to gracefully terminate a user's connection to the database. Which function should you use?

Options :

A : pg_kill_backend(pid)

B : pg_terminate_backend(pid)

C : pg_cancel_backend(pid)

D : pg_disconnect_backend(pid)

Answer: B

Question 4

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 5

Which psql meta-command is used to describe a table including its structure, columns, and constraints?

Options :

A : \dt tablename

B : \d tablename

C : \describe tablename

D : \show tablename

Answer: B

Free PostgreSQL-Essentials-v13 Mock Exam – Practice Online Confidently

Buying Options: