Why are planner statistics important for index selection and join strategy decisions?
Postgresql Associate Monitoring Tuning
Question · Easy
Wedding seating, as a LEFT JOIN
Short
What does setting `port = 5433` in `postgresql.conf` change?
Postgresql Associate Architecture Installation
Chapter 1: Exam Overview & PostgreSQL Foundation
1.1 EDB PostgreSQL Associate Certification Overview
Study guide
Which statement about `peer` authentication is correct on Unix-like systems?
Postgresql Associate Basic Administration
Question · Hard
Tech Exam Prep Podcast
Listen on Spotify
Podcast
What is the main role of `shared_buffers`?
What is the most direct purpose of the `COPY` command in PostgreSQL administration?
RTO vs RPO
A DBA loads millions of rows and notices autovacuum has not yet run. Which manual action is most helpful before benchmarking query performance?
Question · Medium
1.2 The PostgreSQL Relational Model & Architecture Principles
What is a common risk of an abandoned replication slot?
Postgresql Associate High Availability
A 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?
Postgresql Associate Sql Knowledge
Which privilege allows a role to create objects in a schema?
Which statement about the `postgres` operating-system account is most accurate on many PostgreSQL servers?
1.3 Study Strategies, Lab Setup & Exam-Day Execution
Which aggregate function counts non-NULL values in a column expression?
Which statement is true about `GROUP BY`?
Which psql meta-command is used to list relations such as tables in the current search path?
Postgresql Associate Admin Tools
Which statement about COMMIT is correct?
Chapter 2: PostgreSQL Architecture & Installation
2.1 The PostgreSQL Server Process Model
A query groups by department and computes `AVG(salary)`. Which clause should appear after GROUP BY if the DBA wants the highest average salary shown first?
What is the main purpose of the `initdb` command?
A DBA sees autovacuum falling behind on a busy update-heavy table. What is the operational concern?
Which statement about `COPY FROM STDIN` is correct?
2.2 Database Clusters & Cluster Initialization (initdb)
Which utility is commonly used to create or modify a PostgreSQL role from the command line?
What is the main purpose of read-only query traffic on a standby?
Which statement about PostgreSQL catalogs is correct?
What is the role of `template1` in PostgreSQL?
2.3 Filesystem Layout, Service Control & Startup/Shutdown
Which statement best describes PostgreSQL's client-server architecture?
A DBA wants to run a SQL script file from inside psql. Which meta-command is most direct?
What does `COUNT(*)` return?
When does PostgreSQL usually acquire row-level locks for `UPDATE` statements?
2.4 Server Configuration Parameters
What is the most direct way to guarantee that each email address appears only once in a table?
Which statement about restoring a plain-text SQL dump from `pg_dump` is correct?
Postgresql Associate Backup Recovery
Which statement about failover is correct?
Which parameter family is generally associated with memory available for query operations such as sorts and hashes, not the shared buffer cache?
Chapter 3: Demonstrating SQL Knowledge
3.1 Relational Data Types & Table Design
What is the purpose of `pg_hba_file_rules`?
A DBA wants to see currently connected sessions using a PostgreSQL system view. Which object is the usual first choice?
Which statement about `pg_basebackup` is correct?
A host runs two PostgreSQL clusters on ports 5432 and 5433. Which setting must differ between them even if binaries are shared?
3.2 Integrity Constraints & Data Validation
What is the main difference between `pg_dump` and `pg_dumpall`?
Why is a plain SQL dump often less convenient than a custom archive for large selective restores?
Loading more…