Database Administration Concepts Flashcards
7 cards from real IKM practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Database Administration Concepts flashcards as text
A company can tolerate losing at most 15 minutes of data after a failure. Which metric does this requirement define?
Answer: Recovery Point Objective (RPO)
RPO is the maximum acceptable amount of data loss measured in time, here 15 minutes.
A DBA restores last Sunday's full backup, then Wednesday's differential backup. Which additional backups are needed to recover up to Thursday 10:00 AM?
Answer: All transaction log backups taken after Wednesday's differential up to Thursday 10:00 AM
After the latest differential, you replay the log backups in order to roll forward to the target point in time.
Two transactions each hold a lock the other needs, and neither can continue. How does most RDBMS software usually resolve this?
Answer: It picks one transaction as the deadlock victim and rolls it back
Deadlock detection picks a victim, often the cheapest to roll back, so the other transaction can finish.
Under the READ COMMITTED isolation level, which anomaly can still occur?
Answer: Non-repeatable reads
READ COMMITTED blocks dirty reads, but a row read twice in the same transaction can return different committed values.
Why does a database use write-ahead logging (WAL)?
Answer: To make sure log records reach durable storage before the matching data pages do
WAL keeps transactions durable and recoverable by writing log records to disk before the data changes they describe.
A table has heavy INSERT activity on random key values, and page splits are causing fragmentation. Which index setting helps most directly?
Answer: Lowering the fill factor to leave free space on each page
A lower fill factor leaves room on index pages for new rows, which cuts down on page splits.
What is the main purpose of the CHECKPOINT operation in a relational database?
Answer: Writing dirty pages from memory to disk so less log needs to be replayed during crash recovery
A checkpoint flushes modified buffer pages to disk, which shortens recovery time after a crash.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- ikmnet.com — Test delivery, passing score · verified Oct 2026
- online.ikmnet.com — Eligibility, exam format, retake policy, score release, time limit · verified Oct 2026