MariaDB test for hiring
See how candidates read MariaDB code and reason about database application work.
- 10 рдорд┐рдирд┐рдЯреЗ
- 15 рдкреНрд░рд╢реНрди
- рдордзреНрдпрдо
- рдмрд╣реБрдкрд░реНрдпрд╛рдпреА
- рдЗрдВрдЧреНрд░рдЬреА рдордзреАрд▓ рдкреНрд░рд╢реНрди
- рдлреЛрди рдЖрдгрд┐ рдбреЗрд╕реНрдХрдЯреЙрдк
рдереЛрдбрдХреНрдпрд╛рдд рдЙрддреНрддрд░
The MariaDB for Developers test is an intermediate hiring assessment for developers who build on MariaDB, including backend and full-stack developers, database developers, data engineers, and application support engineers who write and tune SQL. Short code-reading questions measure working knowledge of schema design, SQL, transactions, error handling, and query tuning.
рд╣реЗ рдХрд╛рдп рдореЛрдЬрддреЗ
Working knowledge of MariaDB schema design, SQL, transactions, error handling and query tuning, read from short SQL.
Schema design
Candidates judge table definitions and the keys and indexes they need for the data and queries described.
Writing SQL
Questions show queries with joins, window functions or stored routines and ask what they return.
Transactions, errors and tuning
Candidates decide how a transaction or error should be handled and which change speeds up a slow query.
рдкреНрд░рд╢реНрдирд╛рдВрдЪреЗ рдкреНрд░рдХрд╛рд░
рдмрд╣реБрдкрд░реНрдпрд╛рдпреА
рдЙрдореЗрджрд╡рд╛рд░: рдереЛрдбрдХреНрдпрд╛рдд рджрд┐рд▓реЗрд▓реА рдкрд░рд┐рд╕реНрдерд┐рддреА, рддрдХреНрддрд╛ рдХрд┐рдВрд╡рд╛ рд╡рд┐рдзрд╛рди рд╡рд╛рдЪреВрди рдпреЛрдЧреНрдп рдЙрддреНрддрд░ рдХрд┐рдВрд╡рд╛ рд╕рд░реНрд╡ рдпреЛрдЧреНрдп рдЙрддреНрддрд░реЗ рдирд┐рд╡рдбрддреЗ.
рддреБрдореНрд╣рд╛рд▓рд╛ рджрд┐рд╕рддреЗ: рдЙрдореЗрджрд╡рд╛рд░рд╛рд▓рд╛ рд╡рд┐рд╖рдпрд╛рдЪреЗ рдЬреНрдЮрд╛рди рдХреЗрд╡рд│ рдУрд│рдЦрдгреНрдпрд╛рдкреБрд░рддреЗрдЪ рдирд╛рд╣реА, рддрд░ рддреЗ рд▓рд╛рдЧреВ рдХрд░рддрд╛ рдпреЗрдИрд▓ рдЗрддрдХреЗ рдЖрд╣реЗ рдХреА рдирд╛рд╣реА.
10 рдорд┐рдирд┐рдЯрд╛рдВрдд 15 рдкреНрд░рд╢реНрди, рдПрдХрд╛ рд╡реЗрд│реА рдПрдХ рдкреНрд░рд╢реНрди рджрд┐рд▓рд╛ рдЬрд╛рддреЛ.
рд╣реА рдЪрд╛рдЪрдгреА рд▓рд╛рдЧреВ рд╣реЛрдгрд╛рд▒реНрдпрд╛ рднреВрдорд┐рдХрд╛
Developers who build on MariaDB: backend and full-stack developers, database developers, data engineers, and application support engineers who write and tune SQL.
What this test can show
Reasoning from MariaDB code
Each question presents a short SQL snippet, table definition, or query plan, then asks what it does, returns, or which change is right.
Query plans, not only queries
Some questions show a MariaDB query plan and ask which change is right, so you see whether a candidate can tune a slow query rather than only write one.
A consistent database setup
Questions state behavior for a current long-term-support MariaDB release with InnoDB and default settings. Any setting a question depends on is named, so answers do not rely on a candidate's own installation or tools.
рдкреНрд░рддреНрдпреЗрдХ рдЙрдореЗрджрд╡рд╛рд░рд╛рд╕рд╛рдареА рддреБрдореНрд╣рд╛рд▓рд╛ рдХрд╛рдп рдорд┐рд│рддреЗ
- рд╕рдВрдкреВрд░реНрдг рдЪрд╛рдЪрдгреАрджрд░рдореНрдпрд╛рди рдЪрд╛рдЪрдгреАрдЪрд╛ рдЯреЕрдм рдЙрдШрдбрд╛ рдареЗрд╡рд▓рд╛
- рдкреЗрд╕реНрдЯ рдХреЗрд▓реЗрд▓реА рдЙрддреНрддрд░реЗ рдирд╛рд╣реАрдд
- рд╕реНрдерд┐рд░ рдЧрддреАрдиреЗ рдЙрддреНрддрд░реЗ рджрд┐рд▓реА
рд╕реНрдХреЛрдЕрд░, рдкреНрд░реЛрдлрд╛рдЗрд▓ рдЖрдгрд┐ Integrity Score рдордзреАрд▓ рд╕рдВрдХреЗрдд рд╣реЗ рдореБрд▓рд╛рдЦрддреАрд╕реЛрдмрдд рддреБрдореНрд╣реА рддрдкрд╛рд╕рдгреНрдпрд╛рд╕рд╛рдареАрдЪреЗ рдкреБрд░рд╛рд╡реЗ рдЖрд╣реЗрдд; рддреЗ рдХрдзреАрд╣реА рд╕реНрд╡рдпрдВрдЪрд▓рд┐рдд рдирд┐рд░реНрдгрдпрд╛рдЪрд╛ рдЖрдзрд╛рд░ рдирд╕рддрд╛рдд.
рд╣реА рдЯреЗрд╕реНрдЯ рд╡рд┐рдирд╛рдореВрд▓реНрдп рд╡рд╛рдкрд░рд╛
Integrity signals and test controls
Each candidate gets a different set of questions from large pools, with question order and answer options shuffled. The browser shows one question at a time, and answer keys stay on HireValid's servers. Timing runs on the server; reloading restores the same question with only the time left. Candidates cannot copy or select question text, and a blocked copy attempt is recorded in the timeline. HireValid summarizes signals such as time away from the test tab, pastes into answers, and answers faster than a question can be read in an Integrity Score with an evidence timeline for employer review. It never decides on its own. See How we build our tests for more about the test approach.
AI рдЪреНрдпрд╛ рдорджрддреАрдиреЗ рд╣реЛрдгрд╛рд░реА рдлрд╕рд╡рдгреВрдХ рдЖрдореНрд╣реА рдХрд╢реА рд░реЛрдЦрддреЛ ┬╖ рд╡рд┐рд╢реНрд╡рд╕рдиреАрдпрддреЗрдЪреЗ рд╕рдВрдХреЗрдд
Use the score as one piece of evidence
Review the score alongside a job-relevant MariaDB work sample and a structured interview. Use it to guide follow-up, not as a standalone decision or a pass mark. If you are assessing a different database, compare the PostgreSQL or MySQL test.
Structured interview questions
Tell me about a query you changed after reviewing its plan. What did you notice, change, and check afterward?
Listen for a clear account of reading the plan, explaining the change, and checking its effect.
Describe a table design you worked on where keys or indexes mattered. What needs shaped your choices?
Listen for how the candidate connected the data and its use to specific design decisions.
Walk me through a transaction or database error you had to handle in an application. How did you decide what to do?
Listen for the candidate's reasoning about the situation, the response, and its effect on the application.
рд╕реНрдХреЛрдЕрд░рд┐рдВрдЧ рдЖрдгрд┐ рдмреЗрдВрдЪрдорд╛рд░реНрдХ рд╕рдордЬреВрди рдШреНрдпрд╛
рдирд┐рд╖реНрдкрдХреНрд╖рддрд╛ рдЖрдгрд┐ рдЖрд╡рд╢реНрдпрдХ рд╕реБрд╡рд┐рдзрд╛
Questions use plain business data such as orders, stock, bookings and staff, with no money symbols and names from many backgrounds. The code is short and written in one consistent style. Behavior is stated for a current long-term-support release of MariaDB with InnoDB and default settings, and a question names any setting it depends on, so nothing depends on the candidate's own installation or tools. Code lines are kept short so they can be read on any screen.
рд╕реЛрдпреАрд╕рд╛рдареА рддреБрдореНрд╣реА рдХреЛрдгрддреНрдпрд╛рд╣реА рдЙрдореЗрджрд╡рд╛рд░рд╛рд▓рд╛ рдЕрддрд┐рд░рд┐рдХреНрдд рд╡реЗрд│ рджреЗрдК рд╢рдХрддрд╛. рдирд┐рдХрд╛рд▓ рд╣реЗ рдПрдЦрд╛рджреНрдпрд╛ рд╡реНрдпрдХреНрддреАрдиреЗ рддрдкрд╛рд╕рдгреНрдпрд╛рд╕рд╛рдареАрдЪреЗ рдкреБрд░рд╛рд╡реЗ рдЖрд╣реЗрдд, рд╕реНрд╡рдпрдВрдЪрд▓рд┐рдд рдирд┐рд░реНрдгрдпрд╛рдЪрд╛ рдЖрдзрд╛рд░ рдирд╛рд╣реАрдд.
Provisional: reliability is reported once 200 candidates have completed it.
рдЪрд╛рдЪрдгреАрдЪреЗ рддрдкрд╢реАрд▓
Short code-reading questions on building database applications on MariaDB at an intermediate level. The questions cover three areas: designing tables, keys and indexes; writing queries, joins, window functions and stored routines; and handling transactions, errors and slow queries. Each question shows a short SQL snippet, a table definition or a query plan and asks what it does, what it returns or which change is right.
- рдкреНрд░рд╢реНрди рдЗрдВрдЧреНрд░рдЬреАрдордзреНрдпреЗ рдЖрд╣реЗрдд.
- рдХреЛрдгрддреНрдпрд╛рд╣реА рд╕рд╣рд╛рдпреНрдпрдХ рд╕рд╛рдзрдирд╛рдВрдЪреА рдЧрд░рдЬ рдирд╛рд╣реА.
- рдкреНрд░рддреНрдпреЗрдХ рдкреНрд░рд╢реНрдирд╛рдЪреЗ рдЙрддреНрддрд░ рдХреНрд░рдорд╛рдиреЗ рдПрдХрджрд╛рдЪ рджреЗрддрд╛ рдпреЗрддреЗ. рдорд╛рдЧреАрд▓ рдкреНрд░рд╢реНрдирд╛рдХрдбреЗ рдкрд░рдд рдЬрд╛рддрд╛ рдпреЗрдд рдирд╛рд╣реА.
- рд╡реЗрд│реЗрдЪреНрдпрд╛ рдорд░реНрдпрд╛рджреЗрддреАрд▓ рдЯреЗрд╕реНрдЯрдкреВрд░реНрд╡реА 4 рд╕рд░рд╛рд╡ рдкреНрд░рд╢реНрди, 4 рдорд┐рдирд┐рдЯреЗ.
MariaDB рд╣рд╛ рддреНрдпрд╛рдЪреНрдпрд╛ рдорд╛рд▓рдХрд╛рдЪрд╛ рдЯреНрд░реЗрдбрдорд╛рд░реНрдХ рдЖрд╣реЗ. HireValid рддреНрдпрд╛рдЪреНрдпрд╛рд╢реА рд╕рдВрд▓рдЧреНрди рдирд╛рд╣реА рдХрд┐рдВрд╡рд╛ рддреНрдпрд╛рдЪреЗ рд╕рдорд░реНрдерди рдкреНрд░рд╛рдкреНрдд рдирд╛рд╣реА.
рд╡рд╛рд░рдВрд╡рд╛рд░ рд╡рд┐рдЪрд╛рд░рд▓реЗ рдЬрд╛рдгрд╛рд░реЗ рдкреНрд░рд╢реНрди
How does the MariaDB for Developers test account for different candidate setups?+
Behavior is stated for a current long-term-support MariaDB release with InnoDB and default settings. If a question depends on a setting, it names it, so the answer does not depend on a candidate's own installation or tools. Data is plain business data such as orders, stock, bookings and staff.
Can candidates use aids during the MariaDB for Developers test?+
No aids are allowed, and candidates cannot go back to an earlier question. Each question shows what is needed on the screen: a short SQL snippet, a table definition or a query plan, in one consistent style with lines short enough to read on any screen.
What is included in the MariaDB for Developers practice set?+
The practice set has 4 questions and lasts 4 minutes. It gives candidates a chance to see the test's short code-reading question format before taking the assessment.
Which roles fit the intermediate MariaDB for Developers test?+
It is for developers who build on MariaDB, including backend and full-stack developers, database developers, data engineers, and application support engineers who write and tune SQL. The intermediate level suits people who already write SQL for MariaDB applications, not those learning SQL for the first time.
рд╕рдВрдмрдВрдзрд┐рдд рдЪрд╛рдЪрдгреНрдпрд╛
PostgreSQL
10 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛Microsoft SQL Server
10 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛Elasticsearch
10 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛Oracle DBMS
10 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛SQL Server Management Studio
10 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛MongoDB
10 рдорд┐рдирд┐рдЯреЗ, рд╕реЙрдлреНрдЯрд╡реЗрдЕрд░ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛рддреБрдордЪреНрдпрд╛ рдкреБрдвреАрд▓ рднрд░рддреАрд╕рд╛рдареА рдбреЗрд╡реНрд╣рд▓рдкрд░реНрд╕рд╕рд╛рдареА MariaDB рдЯреЗрд╕реНрдЯ рд╡рд╛рдкрд░рд╛
Free рд╕рд╣рд┐рдд рдкреНрд░рддреНрдпреЗрдХ рдкреНрд▓реЕрдирдордзреНрдпреЗ рд╕рдВрдкреВрд░реНрдг рдЯреЗрд╕реНрдЯ рд▓рд╛рдпрдмреНрд░рд░реА рдЙрдкрд▓рдмреНрдз рдЖрд╣реЗ.