Technology, software, data, AI, and cybersecurity
Database administration practice questions
Suite 222 · apt-222-database-administration. Published A4A vertical slice with guided, mini, full, and reserve banks.
Official sourcesVerification pending
About this practice suite
This suite prepares candidates for database administration selection in the technology, software, data, ai, and cybersecurity sector with 5 skill areas: technical reasoning, numerical reasoning, situational judgment, attention and concentration and critical thinking. Every question was written by Novus editors for this suite (none are taken from live or leaked exams), and the full bank holds 52 scored questions across three modes, plus 8 reserve questions used to vary repeat attempts. Answer keys never ship to the browser: your answers are scored server-side, and results stay on your device.
Skills this suite practises
- Technical reasoning: Applied technical principles, diagrams, tools, systems, measurements, and troubleshooting.
- Numerical reasoning: Arithmetic, fractions, percentages, ratios, rates, estimation, word problems, and number relationships.
- Situational judgment: Evaluating workplace responses against role-relevant principles.
- Attention and concentration: Sustained focus, selective attention, and accuracy under time pressure.
- Critical thinking: Evaluating evidence, assumptions, arguments, credibility, and alternative explanations.
Sample questions from the guided bank
Two of the 10 guided-practice questions, shown exactly as they appear in a session. Answers and explanations are not printed here, because keys stay on the server. Open guided practice to answer them and see how you did.
Before a production schema change, educational DBA priority?
- A. Apply directly on prod with no ticket
- B. Disable all logging
- C. Confirm backup/restore point, change window, and rollback/forward plan
- D. Drop the standby to free space
App reports timeouts; CPU low but wait events show lock waits. Best first focus?
- A. Buy more GPUs immediately
- B. Turn off authentication
- C. Delete the transaction log casually
- D. Identify blocking sessions/transactions and long-held locks
Practice modes and timing
Guided practice is untimed-feeling and instructional; the mini-test is a short timed check; the full simulation mirrors a complete sitting. All three draw on separate question sets, so moving up a mode never repeats what you practised.
| Mode | Questions | Duration | Start |
|---|---|---|---|
| Guided practice | 10 | 15 minutes | Open |
| Timed mini-test | 12 | 18 minutes | Open |
| Full simulation | 30 | 45 minutes | Open |
Study outline
Read the study outline for this suite’s skills, timings, and recommended lessons on one printable page, or take the full study guide away as a PDF, a spreadsheet, plain text, or HTML. Each download contains every skill’s complete lesson, not a list of links.
- Download full study guide (HTML) Opens in any browser, works offline.
- Download full study guide (PDF) Paginated, print-ready, opens anywhere.
- Download full study guide (CSV (spreadsheet)) Opens in a spreadsheet, one row per item.
- Download full study guide (Plain text) Plain text for notes apps and screen readers.