Cisco®
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
All Vendors
  2. Home
  3. Exams
  4. EnterpriseDB
  5. PostgreSQL-Essentials

Free EnterpriseDB PostgreSQL-Essentials Exam Questions (page: 4)

Page 2 of 10
PDF with 71 Questions

You are connected to a PostgreSQL database. After executing a complex query an error message is displayed. You want to edit and rerun the previously executed query.
Which command can be used to edit the query buffer?

  1. L
  2. R
  3. \e
  4. e

Answer(s): C



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?

  1. =- waldir
  2. --wal-segsize
  3. -x
  4. No such option is available in PostgreSQL

Answer(s): B



SERIAL and IDENTITY columns can be used to add an auto-incrementing column in a Postgres table.
Which of these two column types are SQL standard compliant?

  1. Serial
  2. Identity
  3. None

Answer(s): B



You want to list all available databases in your PostgreSQL cluster using psql.
Which command should you use?

  1. \list
  2. \l
  3. SHOW DATABASES;
  4. SELECT databases();

Answer(s): B



Which PostgreSQL backup utility can create backups in custom compressed format?

  1. pg_dump with -Fc option
  2. pg_restore
  3. pg_basebackup
  4. psql

Answer(s): A



In PostgreSQL 13, which command is used to switch your connection to a different database in psql?

  1. \connect dbname
  2. USE dbname;
  3. SWITCH dbname;
  4. SET DATABASE dbname;

Answer(s): A



Which PostgreSQL configuration parameter controls the amount of memory used for sorting operations before writing to temporary disk files?

  1. shared_buffers
  2. work_mem
  3. maintenance_work_mem
  4. temp_buffers

Answer(s): B



You need to restore only the schema from a custom format backup file.
Which pg_restore option should you use?

  1. --data-only
  2. --schema-only
  3. -s
  4. Both B and C

Answer(s): D



Viewing page 4 of 10
Viewing questions 25 - 32 out of 71 questions



Post your Comments and Discuss EnterpriseDB PostgreSQL-Essentials exam prep with other Community members:

PostgreSQL-Essentials Exam Discussions & Posts