Question 1

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 2

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 3

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 4

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

Higher Test Marks with Free Online PostgreSQL-Essentials-v13 Exam Practice