IKM Database Administration Concepts 2

Question 1

What is the purpose of database normalization?

Accepted Answer

Eliminate data redundancy and improve integrity

Answer

Normalization organizes data to reduce redundancy and prevent update anomalies.

Question 2

Which index type organizes data in a sorted tree for efficient range queries?

Accepted Answer

B-tree index

Answer

B-tree indexes store data in a balanced tree maintaining sorted order for efficient searches.

Question 3

What does ACID stand for in database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

ACID ensures reliable transactions: Atomicity, Consistency, Isolation, Durability.

Question 4

What is a stored procedure?

Accepted Answer

Precompiled set of SQL statements stored in the database

Answer

A stored procedure is a named collection of SQL statements that can be executed on demand.

Question 5

What is the difference between clustered and non-clustered indexes?

Accepted Answer

Clustered determines physical row order; non-clustered creates a separate structure

Answer

A clustered index sorts actual data rows; a non-clustered index creates a separate lookup structure.

IKM - International Knowledge Measurement Practice Test