Question

Does index take space in the disk?

(a) It stores memory as and when required

(b) Yes, Indexes are stored on disk

(c) Indexes are never stored on disk

(d) Indexes take no space

The question was posed to me during an interview.

My doubt stems from Index Definition in SQL topic in chapter Indexing and Hashing of Database Management

Answer 1

Right answer is (b) Yes, Indexes are stored on disk

To explain: Indexes take memory slots which are located on the disk.