Free EnterpriseDB PostgreSQL-Essentials-v13 Exam Questions

Question 1

You need to restore a database from a compressed format backup file created with pg_dump -Fc option. Which utility should you use?

A : psql

B : pg_restore

C : pg_dump

D : pg_basebackup

Answer: B

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?

A : \time on

B : \timing

C : \time off

D : \t

Answer: B

Question 3

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?

A : -U

B : -authenticate

C : -A

D : -db-auth

Answer: C

Question 4

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?

A : -U

B : -authenticate

C : -A

D : -db-auth

Answer: C

Question 5

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

A : \a

B : \t

C : \align

D : \format

Answer: A