Free practice test

Database Administrator Practice Test

Check what you know about the database administrator job with 15 free questions and instant explanations.

Updated By the Career Education Institute Curriculum Team
About this practice test

15 multiple-choice questions on database administrator knowledge, safety and vocabulary. Submit to see your score and explanations, or open any question’s answer as you go. Nothing is saved or shared.

Question 1 of 15An index helps:
Show answer

Answer: Speed up queries. Indexes speed lookups.

Question 2 of 15RTO measures:
Show answer

Answer: How fast systems must be restored. Recovery time objective.

Question 3 of 15Least privilege means:
Show answer

Answer: Users get only needed access. Minimal access reduces risk.

Question 4 of 15A deadlock is:
Show answer

Answer: Two transactions blocking each other. Transactions wait on each other.

Question 5 of 15Why test restores?
Show answer

Answer: To prove backups work. Restores confirm recoverability.

Question 6 of 15Which term matches this definition: “Copying data to another server.”
Show answer

Answer: Replication. Replication: Copying data to another server.

Question 7 of 15What does “Index” mean?
Show answer

Answer: A structure that speeds up queries.. Index: A structure that speeds up queries.

Question 8 of 15Which term matches this definition: “Organizing data to reduce duplication.”
Show answer

Answer: Normalization. Normalization: Organizing data to reduce duplication.

Question 9 of 15What does “Transaction” mean?
Show answer

Answer: A unit of work that succeeds or fails completely.. Transaction: A unit of work that succeeds or fails completely.

Question 10 of 15Which term matches this definition: “Structured Query Language.”
Show answer

Answer: SQL. SQL: Structured Query Language.

Question 11 of 15What does “Restore” mean?
Show answer

Answer: Recovering data from a backup.. Restore: Recovering data from a backup.

Question 12 of 15Which term matches this definition: “Giving users only the access they need.”
Show answer

Answer: Least privilege. Least privilege: Giving users only the access they need.

Question 13 of 15What does “Deadlock” mean?
Show answer

Answer: When two transactions block each other.. Deadlock: When two transactions block each other.

Question 14 of 15Which term matches this definition: “How the database executes a query.”
Show answer

Answer: Query plan. Query plan: How the database executes a query.

Question 15 of 15What does “Schema” mean?
Show answer

Answer: The structure of a database.. Schema: The structure of a database.

How to study

View training