Question 1

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 2

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

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

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

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

Buying Options: