EnterpriseDB PostgreSQL-Essentials Exam Questions Instant Access

Question 1

You have created a database user named edbuser with password 'password'. Which command grants connection rights to the edbstore database for user edbuser?

AGRANT ALL ON DATABASE edbstore TO edbuser;

BGRANT CONNECT ON DATABASE edbstore TO edbuser;

CGRANT ACCESS ON DATABASE edbstore TO edbuser;

DGRANT LOGIN ON DATABASE edbstore TO edbuser;

Answer : B

Question 2

You are working as a Postgres DBA. Due to an increase in transactional load on your Postgres instance, the server is experiencing frequent checkpoints. You have decided to increase the WAL area size. You have also decided to upgrade your database instance to PostgreSQL 13. While initializing your database cluster in PostgreSQL 13, you have decided to increase the WAL segment size. Which of the following options can be used with the initdb command to set a custom WAL segment size?

A=- waldir

B--wal-segsize

C-x

DNo such option is available in PostgreSQL

Answer : B

Question 3

Which psql command toggles the display of tuples only (without column headers)?

A\a

B\t

C\x

D\h

Answer : B

Question 4

Which directory in the PostgreSQL data directory contains the Write-Ahead Log files?

Apg_log

Bpg_xlog

Cpg_wal

Dwal_files

Answer : C

Question 5

In PostgreSQL, which system catalog stores information about databases?

Apg_database

Bpg_class

Cpg_tables

Dinformation_schema.databases

Answer : A

Question 6

You want to export query results to a CSV file from psql. Which command should you use?

A\copy tablename TO 'filename.csv' CSV

BEXPORT TO 'filename.csv'

C\export filename.csv

DSAVE AS 'filename.csv'

Answer : A

Question 7

Which pg_dump option allows you to dump only the data without schema definitions?

A-d

B--data-only

C-D

D--no-schema

Answer : B

EnterpriseDB PostgreSQL Essentials Certification v13 PostgreSQL-Essentials Exam Questions