PostgreSQL test for hiring
See how candidates interpret PostgreSQL queries, settings, commands, and query plans.
- 10 āĻŽāĻŋāύāĻŋāĻ
- 15āĻāĻŋ āĻĒā§āϰāĻļā§āύ
- āĻŽāĻžāĻāĻžāϰāĻŋ
- āĻŦāĻšā§āύāĻŋāϰā§āĻŦāĻžāĻāύā§
- āĻāĻāϰā§āĻāĻŋ āĻāĻžāώāĻžāϝāĻŧ āĻĒā§āϰāĻļā§āύ
- āĻĢā§āύ āĻ āĻĄā§āϏā§āĻāĻāĻĒ
āϏāĻāĻā§āώāĻŋāĻĒā§āϤ āĻāϤā§āϤāϰ
The PostgreSQL test is a 10-minute, 15-question assessment of practical intermediate skills. It covers schema and SQL, administration, replication and recovery, and monitoring and tuning through short questions about queries, commands, settings, and query plans. Use it to inform hiring for database administrators and engineers, backend and software engineers, and operations roles.
āĻāĻāĻŋ āĻā§ āĻĒāϰāĻŋāĻŽāĻžāĻĒ āĻāϰā§
Practical PostgreSQL knowledge: schema and SQL, administration, replication and recovery, and monitoring and tuning.
Schema and SQL
Questions cover designing tables and writing SQL, including interpreting short queries and their results.
Administration
Questions assess knowledge of administering a PostgreSQL server and interpreting its commands and settings.
Replication and recovery
Questions cover keeping data available through replication, backups, and recovery.
Monitoring and tuning
Questions ask candidates to find and fix slow queries using information such as a query plan.
āĻĒā§āϰāĻļā§āύā§āϰ āϧāϰāύ
āĻŦāĻšā§āύāĻŋāϰā§āĻŦāĻžāĻāύā§
āĻĒā§āϰāĻžāϰā§āĻĨā§: āĻāĻāĻāĻŋ āϏāĻāĻā§āώāĻŋāĻĒā§āϤ āĻĒāϰāĻŋāϏā§āĻĨāĻŋāϤāĻŋ, āϏāĻžāϰāĻŖāĻŋ āĻŦāĻž āĻŦāĻŋāĻŦā§āϤāĻŋ āĻĒāĻĄāĻŧā§ āϏāĻ āĻŋāĻ āĻāϤā§āϤāϰāĻāĻŋ, āĻ āĻĨāĻŦāĻž āϏāĻŦ āϏāĻ āĻŋāĻ āĻāϤā§āϤāϰ āĻŦā§āĻā§ āύā§āϝāĻŧāĨ¤
āĻāĻĒāύāĻŋ āĻĻā§āĻā§āύ: āĻĒā§āϰāĻžāϰā§āĻĨā§ āĻŦāĻŋāώāϝāĻŧāĻāĻŋ āĻļā§āϧ⧠āĻāĻŋāύāϤ⧠āĻĒāĻžāϰā§āύ āĻāĻŋ āύāĻž āύāϝāĻŧ, āĻāĻžāĻā§ āϞāĻžāĻāĻžāύā§āϰ āĻŽāϤ⧠āϝāĻĨā§āώā§āĻ āĻāĻžāϞā§āĻāĻžāĻŦā§ āĻāĻžāύā§āύ āĻāĻŋ āύāĻžāĨ¤
10 āĻŽāĻŋāύāĻŋāĻā§ 15āĻāĻŋ āĻĒā§āϰāĻļā§āύ, āĻāĻāĻŦāĻžāϰ⧠āĻāĻāĻāĻŋ āĻāϰ⧠āĻĻā§āĻāĻžāύ⧠āĻšāϝāĻŧāĨ¤
āĻāĻ āĻĒāϰā§āĻā§āώāĻžāϰ āĻāĻĒāϝā§āĻā§ āĻĒāĻĻ
Database administrators and database engineers, backend and software engineers, site reliability and operations engineers, and system administrators who run or build on PostgreSQL.
What the PostgreSQL test can show
Practical knowledge, not just a job title
See how a candidate reasons about short PostgreSQL queries, commands, settings, and query plans, alongside what their resume says.
A focused follow-up
Use results to focus interview time on schema and SQL, server administration, recovery, or tuning areas relevant to the role.
Four areas in one short assessment
The same 10-minute test samples database design and SQL, administration, replication and recovery, and monitoring and tuning.
āĻĒā§āϰāϤāĻŋāĻāĻŋ āĻĒā§āϰāĻžāϰā§āĻĨā§āϰ āĻāύā§āϝ āĻāĻĒāύāĻŋ āϝāĻž āĻĒāĻžāĻŦā§āύ
- āĻĒā§āϰ⧠āϏāĻŽāϝāĻŧ āĻĒāϰā§āĻā§āώāĻžāϰ āĻā§āϝāĻžāĻŦā§āĻ āĻāĻŋāϞā§āύ
- āĻāĻĒāĻŋ-āĻĒā§āϏā§āĻ āĻāϰāĻž āĻāϤā§āϤāϰ āύā§āĻ
- āĻāĻāĻāĻžāύāĻž āĻāϤāĻŋāϤ⧠āĻāϤā§āϤāϰ āĻĻāĻŋāϝāĻŧā§āĻā§āύ
āϏā§āĻā§āϰ, āĻĒā§āϰā§āĻĢāĻžāĻāϞ āĻ āϏāϤāϤāĻžāϰ āϏāĻāĻā§āϤāĻā§āϞāĻŋ āϏāĻžāĻā§āώāĻžā§āĻāĻžāϰā§āϰ āĻĒāĻžāĻļāĻžāĻĒāĻžāĻļāĻŋ āĻāĻĒāύāĻžāϰ āĻĒāϰā§āϝāĻžāϞā§āĻāύāĻžāϰ āĻāύā§āϝ āĻĒā§āϰāĻŽāĻžāĻŖ, āĻāĻāύāĻ āϏā§āĻŦāϝāĻŧāĻāĻā§āϰāĻŋāϝāĻŧ āϏāĻŋāĻĻā§āϧāĻžāύā§āϤā§āϰ āĻāĻŋāϤā§āϤāĻŋ āύāϝāĻŧāĨ¤
āĻāĻ āĻā§āϏā§āĻāĻāĻŋ āĻŦāĻŋāύāĻžāĻŽā§āϞā§āϝ⧠āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰā§āύ
Test integrity features
Each candidate receives a different set of questions from large pools. Question order and answer options are shuffled, and the browser shows one question at a time. Answer keys stay on HireValidâs servers. The 10-minute timer runs on the server, so reloading brings back the same question with only the time left. Candidates cannot return to earlier questions. Question text cannot be copied or selected, and blocked copy attempts appear in the timeline. Personal invitation links expire, and a finished test cannot be taken again. HireValid records signals such as time away from the test tab, pastes into answers, and answers faster than a question can be read. An Integrity Score and evidence timeline give the employer signals to review; neither decides on its own. With candidate consent, random webcam photos can be added.
āĻāĻŽāϰāĻž āϝā§āĻāĻžāĻŦā§ AI āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰ⧠āĻĒā§āϰāϤāĻžāϰāĻŖāĻž āĻ ā§āĻāĻžāĻ Âˇ āĻ āĻāĻŖā§āĻĄāϤāĻž-āϏāĻāĻā§āϰāĻžāύā§āϤ āϏāĻāĻā§āϤ
Use the score as evidence
Review the score alongside a short work sample and a structured interview. Ask the candidate to inspect a brief query, setting, or query plan and explain a likely outcome or fix. Use the interview to explore their reasoning about schema and SQL, server administration, recovery, or tuning. For a separate view of query writing, see SQL Coding: Querying. If the role also calls for related technical skills, consider the separate Linux or Snowflake tests. Treat the score as evidence for a person to review, never as the sole basis for a hiring decision.
Structured interview questions
A query against an orders table is slower than expected. How would you investigate it and choose a change?
Listen for a reasoned approach to examining the query and its plan, identifying a possible cause, and checking whether a change helps.
You need to change a schema while an application uses the database. How would you plan and check the change?
Listen for how the candidate would think through the table design, SQL changes, and their effect on the application.
A PostgreSQL server needs recovery after data loss. How would you decide what to restore and check availability?
Listen for a clear explanation of how backups, recovery, and replication relate to restoring service.
āϏā§āĻā§āϰāĻŋāĻ āĻ āĻŦā§āĻā§āĻāĻŽāĻžāϰā§āĻ āϏāĻŽā§āĻĒāϰā§āĻā§ āĻāĻžāύā§āύ
āύā§āϝāĻžāϝā§āϝāϤāĻž āĻ āĻĒā§āϰāϝāĻŧā§āĻāύā§āϝāĻŧ āϏā§āĻŦāĻŋāϧāĻž
Questions use neutral sample data such as orders, tickets, sensors and stock, with names from many backgrounds and no money symbols or local knowledge. They describe the behavior of currently supported PostgreSQL releases under default settings and name the release whenever behavior differs between versions. No hosting provider or add-on product is assumed. Code is kept short, with narrow lines, so it can be read on any screen.
āϝā§āĻā§āϤāĻŋāϏāĻā§āĻāϤ āϏā§āĻŦāĻŋāϧāĻž āĻšāĻŋāϏā§āĻŦā§ āĻāĻĒāύāĻŋ āϝā§āĻā§āύ⧠āĻĒā§āϰāĻžāϰā§āĻĨā§āĻā§ āĻ āϤāĻŋāϰāĻŋāĻā§āϤ āϏāĻŽāϝāĻŧ āĻĻāĻŋāϤ⧠āĻĒāĻžāϰā§āύāĨ¤ āĻĢāϞāĻžāĻĢāϞ āĻāĻāĻāύ āĻŦā§āϝāĻā§āϤāĻŋāϰ āĻĒāϰā§āϝāĻžāϞā§āĻāύāĻžāϰ āĻāύā§āϝ āĻĒā§āϰāĻŽāĻžāĻŖ, āĻāĻāύāĻ āϏā§āĻŦāϝāĻŧāĻāĻā§āϰāĻŋāϝāĻŧ āϏāĻŋāĻĻā§āϧāĻžāύā§āϤ āύāϝāĻŧāĨ¤
Provisional: reliability is reported once 200 candidates have completed it.
āĻĒāϰā§āĻā§āώāĻžāϰ āĻŦāĻŋāĻŦāϰāĻŖ
Short, timed questions on running PostgreSQL at an intermediate level. They cover four areas: designing tables and writing SQL, administering a server, keeping data available through replication, backups and recovery, and finding and fixing slow queries. Most questions show a short query, command, setting or query plan and ask what happens, what it returns or which fix is right.
- āĻĒā§āϰāĻļā§āύāĻā§āϞāĻŋ āĻāĻāϰā§āĻāĻŋāϤā§āĨ¤
- āĻā§āύ⧠āϏāĻšāĻžāϝāĻŧāĻ āĻāĻĒāĻāϰāĻŖā§āϰ āĻĒā§āϰāϝāĻŧā§āĻāύ āύā§āĻāĨ¤
- āĻĒā§āϰāϤāĻŋāĻāĻŋ āĻĒā§āϰāĻļā§āύ āĻā§āϰāĻŽāĻžāύā§āϏāĻžāϰ⧠āĻāĻāĻŦāĻžāϰ āĻāϰ⧠āĻāϤā§āϤāϰ āĻĻāĻŋāϤ⧠āĻšāϝāĻŧāĨ¤ āĻāĻā§āϰ āĻĒā§āϰāĻļā§āύ⧠āĻĢāĻŋāϰ⧠āϝāĻžāĻāϝāĻŧāĻžāϰ āϏā§āϝā§āĻ āύā§āĻāĨ¤
- āϏāĻŽāϝāĻŧāĻŦāĻĻā§āϧ āĻĒāϰā§āĻā§āώāĻžāϰ āĻāĻā§ 4 āĻŽāĻŋāύāĻŋāĻā§ 4āĻāĻŋ āĻ āύā§āĻļā§āϞāύā§āϰ āĻĒā§āϰāĻļā§āύāĨ¤
PostgreSQL āĻāϰ āĻŽāĻžāϞāĻŋāĻā§āϰ āĻā§āϰā§āĻĄāĻŽāĻžāϰā§āĻāĨ¤ HireValid āĻāϰ āϏāĻā§āĻā§ āϝā§āĻā§āϤ āύāϝāĻŧ āĻŦāĻž āĻāϰ āĻĻā§āĻŦāĻžāϰāĻž āϏāĻŽāϰā§āĻĨāĻŋāϤ āύāϝāĻŧāĨ¤
āĻĒā§āϰāĻžāϝāĻŧāĻļāĻ āĻāĻŋāĻā§āĻāĻžāϏāĻŋāϤ āĻĒā§āϰāĻļā§āύ
What does the PostgreSQL test measure?+
It measures practical knowledge of schema and SQL, server administration, replication and recovery, and monitoring and tuning. Questions use short queries, commands, settings, or query plans and ask what happens, what a query returns, or which fix is appropriate.
Who should take the PostgreSQL test?+
It is intended for intermediate database administrators and database engineers, backend and software engineers, site reliability and operations engineers, and system administrators who run or build on PostgreSQL.
How does the PostgreSQL test differ from a query-writing assessment?+
Along with schema and SQL, this test includes server administration, replication and recovery, and monitoring and tuning. Short questions can ask candidates to interpret a command, setting, or query plan, not only a query.
What question formats are in the PostgreSQL test?+
The test has 15 multiple-choice questions in English and takes 10 minutes. Most questions show a short query, command, setting, or query plan and ask what happens, what it returns, or which fix is right.
āĻ āϏāĻŽā§āĻĒāϰā§āĻāĻŋāϤ āĻĒāϰā§āĻā§āώāĻž
Microsoft SQL Server
10 āĻŽāĻŋāύāĻŋāĻ, āϏāĻĢāĻāĻāϝāĻŧā§āϝāĻžāϰ-āϏāĻāĻā§āϰāĻžāύā§āϤ āĻĻāĻā§āώāϤāĻž
āĻĻā§āĻā§ āύāĻŋāύāĻĄā§āĻā§āϞāĻĒāĻžāϰāĻĻā§āϰ āĻāύā§āϝ MariaDB
10 āĻŽāĻŋāύāĻŋāĻ, āϏāĻĢāĻāĻāϝāĻŧā§āϝāĻžāϰ-āϏāĻāĻā§āϰāĻžāύā§āϤ āĻĻāĻā§āώāϤāĻž
āĻĻā§āĻā§ āύāĻŋāύOracle DBMS
10 āĻŽāĻŋāύāĻŋāĻ, āϏāĻĢāĻāĻāϝāĻŧā§āϝāĻžāϰ-āϏāĻāĻā§āϰāĻžāύā§āϤ āĻĻāĻā§āώāϤāĻž
āĻĻā§āĻā§ āύāĻŋāύMongoDB
10 āĻŽāĻŋāύāĻŋāĻ, āϏāĻĢāĻāĻāϝāĻŧā§āϝāĻžāϰ-āϏāĻāĻā§āϰāĻžāύā§āϤ āĻĻāĻā§āώāϤāĻž
āĻĻā§āĻā§ āύāĻŋāύElasticsearch
10 āĻŽāĻŋāύāĻŋāĻ, āϏāĻĢāĻāĻāϝāĻŧā§āϝāĻžāϰ-āϏāĻāĻā§āϰāĻžāύā§āϤ āĻĻāĻā§āώāϤāĻž
āĻĻā§āĻā§ āύāĻŋāύSQL Server Management Studio
10 āĻŽāĻŋāύāĻŋāĻ, āϏāĻĢāĻāĻāϝāĻŧā§āϝāĻžāϰ-āϏāĻāĻā§āϰāĻžāύā§āϤ āĻĻāĻā§āώāϤāĻž
āĻĻā§āĻā§ āύāĻŋāύāĻĒāϰāĻŦāϰā§āϤ⧠āύāĻŋāϝāĻŧā§āĻā§ PostgreSQL āĻā§āϏā§āĻāĻāĻŋ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰā§āύ
Free-āϏāĻš āĻĒā§āϰāϤāĻŋāĻāĻŋ āĻĒā§āϞā§āϝāĻžāύā§āĻ āϏāĻŽā§āĻĒā§āϰā§āĻŖ āĻā§āϏā§āĻ āϞāĻžāĻāĻŦā§āϰā§āϰāĻŋ āϰāϝāĻŧā§āĻā§āĨ¤