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 the purpose of database normalization?
Answer: Eliminate data redundancy and improve integrity
Normalization organizes data to reduce redundancy and prevent update anomalies.
Which index type organizes data in a sorted tree for efficient range queries?
Answer: B-tree index
B-tree indexes store data in a balanced tree maintaining sorted order for efficient searches.
What does ACID stand for in database transactions?
Answer: Atomicity, Consistency, Isolation, Durability
ACID ensures reliable transactions: Atomicity, Consistency, Isolation, Durability.
What is a stored procedure?
Answer: Precompiled set of SQL statements stored in the database
A stored procedure is a named collection of SQL statements that can be executed on demand.
What is the difference between clustered and non-clustered indexes?
Answer: Clustered determines physical row order; non-clustered creates a separate structure
A clustered index sorts actual data rows; a non-clustered index creates a separate lookup structure.
What is database sharding?
Answer: Horizontally partitioning data across multiple servers
Sharding distributes rows across multiple instances based on a shard key.