200+ Free EDB PostgreSQL Associate Practice Questions

Pass your EDB Essentials for PostgreSQL Associate Certification exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately

200+ Questions

100% Free

1 / 200

Question 1

Score: 0/0

Why are planner statistics important for index selection and join strategy decisions?

Because PostgreSQL uses data-distribution estimates to compare plan costs

Because statistics store the full table data in memory

Because statistics replace WAL files

Because statistics exist only in pgAdmin

to track

2026 Statistics

Key Facts: EDB PostgreSQL Associate Exam

Exam Questions

EDB public catalog

70%

Passing Score

EDB public catalog

60 min

Exam Duration

EDB public catalog

$200

Exam Fee

EDB public catalog

Official Competencies

EDB public catalog

v18/v16/v14

Current Versions Listed

EDB certification catalog

As of March 11, 2026, EDB's current public certification materials list the Essentials for PostgreSQL associate exam at 50 questions, 60 minutes, 70% passing, and $200 USD. EDB publicly lists seven competencies for the exam but does not publish public percentage weights in the currently indexed catalog, so this 200-question practice bank weights SQL and everyday administration a bit more heavily than the surrounding domains while still covering all official competency areas.

Sample EDB PostgreSQL Associate Practice Questions

Try these sample questions to test your EDB PostgreSQL Associate exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 200+ question experience with AI tutoring.

1Why are planner statistics important for index selection and join strategy decisions?

A.Because PostgreSQL uses data-distribution estimates to compare plan costs

B.Because statistics store the full table data in memory

C.Because statistics replace WAL files

D.Because statistics exist only in pgAdmin

Explanation: The planner depends on statistics to estimate row counts and selectivity. When statistics are stale, PostgreSQL can make poor choices about scans, joins, and execution order.

2What does setting `port = 5433` in `postgresql.conf` change?

A.The WAL segment size for the cluster

B.The TCP port PostgreSQL listens on for incoming client connections

C.The replication protocol version used by standbys

D.The default database name for psql sessions

Explanation: The `port` parameter sets the server TCP port for incoming connections. The default is 5432, but DBAs commonly change it when multiple clusters run on the same host.

3Which statement about `peer` authentication is correct on Unix-like systems?

A.It compares the operating-system user identity to the requested PostgreSQL role or an ident map

B.It always requires a SCRAM password exchange

C.It can be used only for TCP connections from remote hosts

D.It automatically grants superuser rights

Explanation: Peer authentication uses the local operating-system identity for authentication decisions. It is common for local socket connections and can work with role-name mapping rules.

4What is the main role of `shared_buffers`?

A.It controls PostgreSQL's shared memory area used to cache data pages

B.It defines the number of replication slots

C.It limits the number of schemas in a database

D.It sets statement timeout for all roles

Explanation: `shared_buffers` is PostgreSQL's main shared page cache setting. It affects how much table and index data the server can keep in shared memory for reuse.

5What is the most direct purpose of the `COPY` command in PostgreSQL administration?

A.To move bulk data between a table and a file or STDIN/STDOUT efficiently

B.To duplicate an entire database cluster for failover

C.To clone a schema and all privileges automatically

D.To compress WAL segments before archiving

Explanation: COPY is PostgreSQL's high-throughput data-loading and unloading mechanism. It is a standard choice for imports, exports, and ETL-style bulk movement tasks.

6A DBA loads millions of rows and notices autovacuum has not yet run. Which manual action is most helpful before benchmarking query performance?

A.DROP DATABASE

B.ANALYZE the table

C.Change `listen_addresses`

D.Revoke CONNECT from all users

Explanation: After a large load, the planner benefits from fresh statistics right away. Running ANALYZE manually can improve plan quality before autovacuum reaches the table.

7What is a common risk of an abandoned replication slot?

A.It can cause WAL files to accumulate because PostgreSQL thinks a replica still needs them

B.It automatically promotes a standby

C.It disables all checkpoints

D.It drops the replica database

Explanation: If a replication slot remains active for a consumer that is gone or stuck, WAL retention can grow unexpectedly. DBAs must monitor slot usage and clean up unused slots.

8A DBA wants to undo several DML statements that were executed after a transaction began. Which command is appropriate if the changes have not been committed yet?

A.VACUUM

B.ROLLBACK

C.REINDEX

D.ANALYZE

Explanation: `ROLLBACK` cancels the current transaction and discards its uncommitted changes. Once a transaction is committed, rollback is no longer available as a direct undo mechanism.

9Which privilege allows a role to create objects in a schema?

A.USAGE only

B.CREATE on the schema

C.CONNECT on the database

D.TEMP on the database

Explanation: A role needs the CREATE privilege on a schema to create objects there. USAGE alone allows object access by name but does not allow new object creation.

10Which statement about the `postgres` operating-system account is most accurate on many PostgreSQL servers?

A.It is a required SQL role created inside every application database

B.It is commonly the service account that owns PostgreSQL files and runs the server process

C.It is the only account allowed to use `psql`

D.It is automatically granted superuser rights on remote clients

Explanation: Many PostgreSQL installations use an operating-system account named `postgres` to own the software and data files and to run the server. That OS account is separate from PostgreSQL SQL roles, even if names often overlap.

About the EDB PostgreSQL Associate Exam

EDB's associate-level PostgreSQL certification validates the core skills expected from a junior PostgreSQL database administrator. The exam focuses on architecture and installation, SQL fluency, day-to-day administration, backup and recovery, high availability concepts, and monitoring or tuning basics for production PostgreSQL environments.

Questions

50 scored questions

Time Limit

60 minutes

Passing Score

70%

Exam Fee

$200 USD (EnterpriseDB (EDB))

EDB PostgreSQL Associate Exam Content Outline

Practice emphasis 15%

Explain PostgreSQL architecture and installation

Understand the PostgreSQL server process model, database clusters, initdb, filesystem layout, configuration files, startup behavior, and the fundamentals of installing or initializing a PostgreSQL environment.

Practice emphasis 20%

Demonstrate SQL knowledge

Work confidently with SELECT statements, filtering, sorting, joins, grouping, data types, constraints, and transaction-safe DML in everyday PostgreSQL administration scenarios.

Practice emphasis 10%

Use PostgreSQL administrative tools

Navigate psql meta-commands, pgAdmin, client-side utilities, and PostgreSQL catalogs or information-schema views to inspect, manage, and troubleshoot database environments.

Practice emphasis 20%

Demonstrate basic PostgreSQL administration knowledge

Create and manage databases, schemas, tablespaces, roles, privileges, authentication settings, routine maintenance workflows, and common data-loading or data-movement operations.

Practice emphasis 15%

Implement backup and recovery strategies

Distinguish logical and physical backups, use pg_dump and pg_restore, understand pg_basebackup and WAL archiving, and choose the right restore or point-in-time recovery approach.

Practice emphasis 10%

Identify high availability options

Recognize PostgreSQL replication and failover concepts, including hot standby, streaming replication, synchronous versus asynchronous behavior, replication slots, and practical HA tradeoffs.

Practice emphasis 10%

Monitor and tune PostgreSQL

Read PostgreSQL statistics views, interpret EXPLAIN output, understand index usage, review logs and autovacuum behavior, and apply safe first-line performance configuration decisions.

How to Pass the EDB PostgreSQL Associate Exam

What You Need to Know

Passing score: 70%
Exam length: 50 questions
Time limit: 60 minutes
Exam fee: $200 USD

Keys to Passing

Complete 500+ practice questions
Score 80%+ consistently before scheduling
Focus on highest-weighted sections
Use our AI tutor for tough concepts

EDB PostgreSQL Associate Study Tips from Top Performers

1Use a real PostgreSQL lab and practice with psql every day; this exam is easier when command names, meta-commands, and object hierarchy feel routine.

2Be clear on PostgreSQL vocabulary such as cluster, database, schema, role, tablespace, WAL, standby, and autovacuum because EDB questions use those terms precisely.

3Practice the difference between logical and physical backup workflows instead of memorizing command names in isolation.

4Review pg_hba.conf, role attributes, GRANT or REVOKE, and ownership rules together so authentication and authorization questions do not blur together.

5Use EXPLAIN and EXPLAIN ANALYZE on small sample queries so you can recognize sequential scans, index scans, and the purpose of updated planner statistics.

6Know what VACUUM, VACUUM FULL, ANALYZE, and autovacuum each do, including when they help and when they can be disruptive.

7Aim for consistent scores above 80% on mixed practice sets before paying for the live exam.

Frequently Asked Questions

What exam facts should I use for the current EDB PostgreSQL Associate exam?

As of March 11, 2026, EDB's current public catalog points to a 50-question, 60-minute associate exam priced at $200 USD with a 70% passing score. Some older version-specific course pages still reference 54 questions, so the newer catalog numbers are the safer planning baseline.

What topics does EDB officially say this exam covers?

EDB's current public competency list covers seven areas: architecture and installation, SQL knowledge, administrative tools, basic PostgreSQL administration, backup and recovery, high availability options, and monitoring or tuning. Those seven areas drive this practice bank.

Does EDB publish official percentage weights for each domain?

Not in the currently indexed public catalog pages. EDB publicly lists the competencies, but not public percentage weights, so this practice bank uses transparent practice-weighting across all seven official areas instead of claiming unpublished official percentages.

How much study time should most candidates plan?

Candidates with prior SQL or Linux administration experience can often prepare in roughly 30 to 50 focused hours. If PostgreSQL is new to you, a more realistic range is 50 to 80 hours with hands-on lab time using psql, pgAdmin, pg_dump, pg_restore, and a small replication or backup lab.

Is the exam tied to one PostgreSQL version only?

EDB's current certification catalog lists Essentials for PostgreSQL versions v18, v16, and v14. The tested skills are intentionally fundamental and portable across versions, but you should still be comfortable with current PostgreSQL defaults, tooling, and terminology.

Were there any 2026 regulatory changes for this exam?

No separate 2026 regulatory changes were found in current public EDB materials. The main current change is branding and version availability in the certification catalog, not a regulatory or licensure-driven overhaul.