PostgreSQL Certified Associate (EDB) Practice Test
PostgreSQL associate certification covering SQL fundamentals, database administration, backup, replication, performance tuning, and PostgreSQL extensions. Administered by EDB (EnterpriseDB). Key domains include Architecture & Installation, Backup, Replication, Security & Operations, Performance, Indexing & Query Tuning and SQL & Data Modeling.
Preguntas de Muestra
Prueba algunas preguntas para ver cómo es el examen completo.
Which configuration parameter controls the amount of memory allocated to PostgreSQL's shared cache used to hold disk blocks across all backends?
Which expression in a CREATE TABLE statement enforces that two columns combined never repeat across rows?
Logical replication is configured by which objects?
An application stores user preferences as a JSON document and needs efficient indexing plus operator support like @>, ?, ?| ?&. Which column type should be chosen?
A query repeatedly filters on lower(email). Which index makes this index-friendly?
Oportunidades profesionales y salario
Los rangos son cifras del mercado de EE. UU. salvo que se muestre un rango local.
Plan de Estudio
Cada dominio está ponderado para coincidir con el examen de certificación real, por lo que una simulación de práctica completa predice tu resultado.