Database Administrator
Role: Database Administrator
Tests database administration fundamentals: indexing and query optimization, backup and recovery, transactions, high availability and security. Intended for companies with critical data and demanding performance and availability requirements.
Sample questions
Taken from the template itself. Questions with a recorded answer key are left out, so reading this page cannot help anyone pass the test.
As the candidate sees it
Database Administrator
- 1.Short text
Which SQL command displays a query's execution plan?
You want to understand how the optimizer intends to access tables and indexes for a slow query before changing anything. Answer with the command (you may name the DBMS).
- 2.Short text
Which normal form requires non-key attributes to depend on the whole key?
The rule forbids partial dependencies: no non-key attribute may depend on only part of a composite key. Answer with the name of the normal form.
- Shown once you copy the template
- Shown once you copy the template
- Shown once you copy the template
6 more questions in the full template.
How this template was made, and what you can check
Are these the real questions?
Yes. The questions on this page are the questions a candidate gets. They are not samples written for the site: they come from the template itself, word for word.
Why are some questions missing from this page?
Any question with a recorded answer key is left out, so that reading this page cannot help anyone pass. The count of what is missing is shown; the questions themselves appear once you copy the template.
Which language does the candidate see?
Every template exists in English and Portuguese. The candidate answers in theirs and you read in yours.
Will this template work on my plan?
Question types are checked against your plan by the database itself, so a template never promises a type your plan cannot run. Building assessments and collecting answers is free; automatic scoring starts on the Starter plan.
Can I change the questions?
Once you copy it, the template is yours: change the wording, drop a question, add your own. None of this is fixed.
How fast can I send it?
Create a free account, copy the template and share the link. The candidate opens it in the browser, with nothing to install.
Use this template on your next opening
Copy the template, change what you want, send a link. Assessly marks each answer, scores it and explains the score.
What comes back to you
Short text
Which SQL command displays a query's execution plan?
Answer
Score
Why this score
The question is real. The answer and the score are drawn as an example of what a review looks like.