Question 1

You are writing an initialization script to help your team in creating a new database cluster. You want toensure that a new database cluster is initialized with md5 as the default authentication method. Which of thefollowing 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 2

In PostgreSQL, what does VACUUM do?

Options :

A : Compresses the database

B : Reclaims storage occupied by dead tuples

C : Creates database backups

D : Optimizes query execution plans

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

Which command in psql toggles between aligned and unaligned output mode?

Options :

A : \a

B : \t

C : \align

D : \format

Answer: A

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