← Back to all categories
🐘 PostgreSQL DBA
Choose a Topic
22 topics · 440 questions total · 20 per quiz · Free
💾
Backup and Recovery: PG_Dump vs. PG_BackRest
20 Questions
Start →
🔀
Connection Pooling with PGBouncer and PGPool-II
20 Questions
Start →
📝
Converting PL/SQL to PL/pgSQL: Key Differences & Challenges
20 Questions
Start →
⚡
EDB Failover Manager (EFM) vs. Patroni
20 Questions
Start →
🏢
EDB Postgres Advanced Server (EPAS): Oracle Compatibility Features
20 Questions
Start →
🌐
EDB Postgres Distributed (BDR): Multi-Master Replication
20 Questions
Start →
🧩
Extensions Ecosystem: PostGIS
20 Questions
Start →
🛡️
High Availability with Patroni and Etcd
20 Questions
Start →
🗂️
Indexing Strategies: B-Tree
20 Questions
Start →
⬆️
Major Upgrade Strategies: Logical Replication vs. In-place
20 Questions
Start →
🛠️
Migration Tools: ora2pg
20 Questions
Start →
🔄
MVCC Internals: Snapshots
20 Questions
Start →
🔁
Oracle to Postgres Migration: Schema Mapping & Data Types
20 Questions
Start →
📊
Partitioning: Declarative vs. Inheritance-based
20 Questions
Start →
✅
Post-Upgrade Tasks: Statistics
20 Questions
Start →
🏗️
PostgreSQL Architecture: Postmaster
20 Questions
Start →
🔧
PostgreSQL Version Upgrades: pg_upgrade (Link Mode vs. Copy)
20 Questions
Start →
🔍
Query Planning & Statistics (EXPLAIN ANALYZE)
20 Questions
Start →
📦
Storage Internals: Pages
20 Questions
Start →
📡
Streaming Replication & Slot Management
20 Questions
Start →
🧹
Vacuuming & Autovacuum: Managing Bloat and Wraparound
20 Questions
Start →
📋
Write Ahead Logging (WAL) & Checkpointing
20 Questions
Start →