Free EnterpriseDB PostgreSQL-Essentials Exam Dumps Questions & Answers

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

• A.  pg_dump
• B.  pg_basebackup
• C.  pg_restore
• D.  psql

Which of the following statements is true about PostgreSQL 13?

• A.  ALTER SYSTEM writes the setting to a file called postgresql.auto.conf
• B.  ALTER CLUSTER writes the setting to a file called postgresql.conf
• C.  ALTER CLUSTER writes the setting to a file called postgresql.auto.conf
• D.  ALTER SYSTEM writes the setting to a file called postgresql.conf

Which psql meta-command lists all schemas in the current database?

• A.  \dn
• B.  \schemas
• C.  \ls
• D.  \ds

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.  -x
• C.  --wal-segsize
• D.  No such option is available in PostgreSQL

Which psql meta-command is used to describe a table including its structure, columns, and constraints?

• A.  \dt tablename
• B.  \describe tablename
• C.  \d tablename
• D.  \show tablename