рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ

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

  1. 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.

  2. A focused follow-up

    Use results to focus interview time on schema and SQL, server administration, recovery, or tuning areas relevant to the role.

  3. Four areas in one short assessment

    The same 10-minute test samples database design and SQL, administration, replication and recovery, and monitoring and tuning.

рдкреНрд░рддреНрдпреЗрдХ рдЙрдореЗрджрд╡рд╛рд░рд╛рд╕рд╛рдареА рддреБрдореНрд╣рд╛рд▓рд╛ рдХрд╛рдп рдорд┐рд│рддреЗ

рдЙрджрд╛рд╣рд░рдгрд╛рд░реНрде рдЕрд╣рд╡рд╛рд▓ (рдХрд╛рд▓реНрдкрдирд┐рдХ рдбреЗрдЯрд╛)PostgreSQL
ренрек%рдкрд░реНрд╕реЗрдВрдЯрд╛рдЗрд▓ 53. рдмреЗрдВрдЪрдорд╛рд░реНрдХ: HireValid рдЙрдореЗрджрд╡рд╛рд░, n = реи,режрежрен
Schema and SQLремрез%
Administrationремрек%
Replication and recoveryренреп%
Monitoring and tuningрепреж%
Integrity ScoreрдЙрдЪреНрдЪ рд╡рд┐рд╢реНрд╡рд╛рд╕рдкрд╛рддрд│реА
  • рд╕рдВрдкреВрд░реНрдг рдЪрд╛рдЪрдгреАрджрд░рдореНрдпрд╛рди рдЪрд╛рдЪрдгреАрдЪрд╛ рдЯреЕрдм рдЙрдШрдбрд╛ рдареЗрд╡рд▓рд╛
  • рдкреЗрд╕реНрдЯ рдХреЗрд▓реЗрд▓реА рдЙрддреНрддрд░реЗ рдирд╛рд╣реАрдд
  • рд╕реНрдерд┐рд░ рдЧрддреАрдиреЗ рдЙрддреНрддрд░реЗ рджрд┐рд▓реА

рд╕реНрдХреЛрдЕрд░, рдкреНрд░реЛрдлрд╛рдЗрд▓ рдЖрдгрд┐ Integrity Score рдордзреАрд▓ рд╕рдВрдХреЗрдд рд╣реЗ рдореБрд▓рд╛рдЦрддреАрд╕реЛрдмрдд рддреБрдореНрд╣реА рддрдкрд╛рд╕рдгреНрдпрд╛рд╕рд╛рдареАрдЪреЗ рдкреБрд░рд╛рд╡реЗ рдЖрд╣реЗрдд; рддреЗ рдХрдзреАрд╣реА рд╕реНрд╡рдпрдВрдЪрд▓рд┐рдд рдирд┐рд░реНрдгрдпрд╛рдЪрд╛ рдЖрдзрд╛рд░ рдирд╕рддрд╛рдд.

рд╣реА рдЯреЗрд╕реНрдЯ рд╡рд┐рдирд╛рдореВрд▓реНрдп рд╡рд╛рдкрд░рд╛

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.

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

  1. 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.

  2. 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.

  3. 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 рд╕рд╣рд┐рдд рдкреНрд░рддреНрдпреЗрдХ рдкреНрд▓реЕрдирдордзреНрдпреЗ рд╕рдВрдкреВрд░реНрдг рдЯреЗрд╕реНрдЯ рд▓рд╛рдпрдмреНрд░рд░реА рдЙрдкрд▓рдмреНрдз рдЖрд╣реЗ.

рд╣реА рдЯреЗрд╕реНрдЯ рд╡рд┐рдирд╛рдореВрд▓реНрдп рд╡рд╛рдкрд░рд╛Free рдкреНрд▓реЕрди. рдХреНрд░реЗрдбрд┐рдЯ рдХрд╛рд░реНрдбрдЪреА рдЧрд░рдЬ рдирд╛рд╣реА.
Free рдкреНрд▓реЕрди. рдХреНрд░реЗрдбрд┐рдЯ рдХрд╛рд░реНрдбрдЪреА рдЧрд░рдЬ рдирд╛рд╣реА.рд╣реА рдЯреЗрд╕реНрдЯ рд╡рд┐рдирд╛рдореВрд▓реНрдп рд╡рд╛рдкрд░рд╛

рд╕рдВрдкрд╛рджрдХреАрдп рдЯреАрдордмрджреНрджрд▓

HireValid editorial team рдиреЗ рд▓рд┐рд╣рд┐рд▓реЗрд▓реЗ рдЖрдгрд┐ рддрдереНрдпрд╛рдВрдЪреА рдкрдбрддрд╛рд│рдгреА рдХреЗрд▓реЗрд▓реЗ. рддрдкрд╛рд╕рд▓реЗрд▓реЗ рд╕реНрд░реЛрдд . рд╕рдВрдкрд╛рджрдХреАрдп рдзреЛрд░рдг рд╡рд╛рдЪрд╛.