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 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

Question 3

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 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

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