Question

Why do we need concurrency control on B+ trees ?

(a) To remove the unwanted data

(b) To easily add the index elements

(c) To maintain accuracy of index

(d) All of the mentioned

The question was posed to me by my school principal while I was bunking the class.

My doubt is from Concurrency in Index Structures topic in division Concurrency Control of Database Management

Answer 1

The correct choice is (c) To maintain accuracy of index

Easy explanation - Indices do not have to be treated like other database structures.