Question 1

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 2

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 3

You are writing an initialization script to help your team in creating a new database cluster. You want to

ensure that a new database cluster is initialized with md5 as the default authentication method. Which of the

following options of the initdb command can be used to specify the default authentication method?

Options :

A : -U

B : -authenticate

C : -A

D : -db-auth

Answer: C

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

You want to set temporary memory to 8MB. Which parameter should you configure?

Options :

A : temp_memory = 8MB

B : work_mem = 8MB

C : temp_buffers = 8MB

D : temporary_memory = 8MB

Answer: C

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

Buying Options: