IKM Database Administration Concepts 2

Question 1

What is the purpose of database normalization?

Accepted Answer

Eliminate data redundancy and improve integrity

Answer

Increase query speed

Answer

Compress storage

Answer

Create backups

Question 2

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

Accepted Answer

B-tree index

Answer

Hash index

Answer

Bitmap index

Answer

Full-text index

Question 3

What does ACID stand for in database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

Automated, Consistent, Independent, Durable

Answer

Access, Control, Integrity, Distribution

Answer

Availability, Concurrency, Isolation, Delivery

Question 4

What is a stored procedure?

Accepted Answer

Precompiled set of SQL statements stored in the database

Answer

Temporary table

Answer

Backup schedule

Answer

Access control list

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

Clustered are faster for all queries

Answer

Non-clustered cannot be on primary keys

Answer

Clustered use hash storage

Question 6

What is database sharding?

Accepted Answer

Horizontally partitioning data across multiple servers

Answer

Creating read replicas

Answer

Encrypting data at rest

Answer

Archiving old data