A database table stores 100,000 student records. A query searches for all students in a specific major. Without an index, the database reads every page of the table. With an index on the major column, the database reads only the pages containing matching rows. What is the mechanism that allows the index to skip irrelevant pages?

Question

Accepted Answer

The index stores a sorted copy of the major column with pointers to the corresponding rows, allowing the database to navigate directly to matching entries

Answer

The index compresses the table data so fewer pages are needed overall

Answer

The index reorganises the table on disk so that students in the same major are stored on consecutive pages

Answer

The index caches frequently accessed rows in memory so disk reads are  avoided

Crowdly

A database table stores 100,000 student records. A query searches for all studen...

Want instant access to all verified answers on moodle.polytechnic.bh?