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

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

Options :

A : \a

B : \t

C : \align

D : \format

Answer: A

Question 3

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 4

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