calhire
Every applicant arrives assessed and AI-interviewed.See how

Vetted assessment library

Databases

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

Skills covered

Each talent declares 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 practice-style sample of the field’s knowledge. The vetted assessment itself has no multiple-choice test today: it is an AI text interview written fresh for each sitting and, for technical roles, a coding round.

How assessments are scoredAll assessment fields

What the vetted assessment looks like

Taken once and reused for every application while your score is valid. Your track follows the skills you declare, and you can choose it yourself.

Technical track

An 8-question AI interview, then a coding round of two problems with three follow-up questions about the code just written. About 65 minutes in total.

  • AI interview40% of the vetted score
  • Coding round60% of the vetted score

Non-technical track

A 9-question AI interview, three of them workplace scenarios. About 22 minutes in total.

  • AI interview100% of the vetted score
Score validity
Your verified score stays valid for six months (180 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