Question 1

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

Options :

A : \a

B : \t

C : \align

D : \format

Answer: A

Question 2

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 3

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 4

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