calhire
Assessment library

Databases

The skills a Databases assessment can cover, how the assessment runs, and a sample question to try.

Skills covered

Candidates declare the skills they have, and each sitting is generated for their target role and those skills. These are skills from this field that an assessment can cover.

  • PostgreSQL
  • MySQL
  • MongoDB
  • Redis
  • Database Design
  • Query Optimization
  • Indexing
  • Replication
  • Transaction Management
  • Backup & Recovery

Sample question

A query that filters a large table on a single column has become slow. What is usually the first thing to check?

  1. AWhether the column is indexed and the query plan actually uses that index
  2. BWhether the table name is too long
  3. CWhether the server clock is correct
  4. DWhether the query is written in upper case
Show the answer

A. Whether the column is indexed and the query plan actually uses that index

Without a usable index the database scans every row. Reading the query plan shows whether an index exists and whether the planner chose it.

A sample only. Real questions are generated fresh for each sitting, so this exact question will not appear.

How assessments are scoredAll assessment fields

What the assessment looks like

A 25-question skills test and a 7-question text interview, about 50 minutes in total.

Sections

  • Multiple-choice questions12 questions
  • Scenario questions8 questions
  • Written case questions5 questions
  • AI text interview questions7 questions
Total time
About 50 minutes
Score validity
Your verified score stays valid for 90 days.
Retakes
One free early retake every 90 days; Premium adds a second.

Look around first. You can browse jobs and save the ones you like before taking the assessment. Saving a job doesn’t require it; applying does.

Browse jobsTry practice questions