Database Administration Concepts Flashcards
6 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 6 Database Administration Concepts flashcards as text
What is a Write-Ahead Log (WAL)?
Answer: Records all changes before they are written to data files
WAL records modifications before applying them to data files, enabling crash recovery.
Which isolation level prevents dirty reads but allows non-repeatable reads?
Answer: Read Committed
Read Committed prevents dirty reads but allows non-repeatable reads.
What is a materialized view?
Answer: Physically stored query result that must be refreshed
A materialized view stores the query result physically, requiring periodic refresh.
What is the CAP theorem?
Answer: A distributed system can guarantee at most two of Consistency, Availability, Partition tolerance
CAP states a distributed system cannot simultaneously provide all three: Consistency, Availability, Partition tolerance.
What is the purpose of a foreign key constraint?
Answer: Enforce referential integrity between tables
Foreign keys ensure values in one table match existing values in the referenced table.
What is the difference between horizontal and vertical scaling?
Answer: Horizontal adds more servers; vertical adds resources to existing servers
Vertical scaling adds more CPU/RAM; horizontal scaling adds more servers.
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