The GATE Grind

GATE Database Management and Warehousing: File organization and indexing – Previous Year Questions

3 GATE previous year questions on File organization and indexing (Database Management and Warehousing, Data Science and Artificial Intelligence) with answers and explanations, from every paper.

3 questions worth 5 marks in all (1 1-mark, 2 2-mark). Asked between 2024 and 2026, so you can see how the topic has been tested over time.

  1. GATE 2024 DA Q55 (2 marks, Multiple select) – An OTT company is maintaining a large disk-based relational database of different movies with the following schema: Movie(ID, CustomerRating)…
  2. GATE 2026 DA Q32 (1 mark, Numerical answer) – In a relational database, a B+ Tree Index is to be constructed for a relation on a key field. In a B+ Tree, a Node Pointer points to a sub-tree and a…
  3. GATE 2026 DA Q41 (2 marks, Multiple choice) – Consider a B+ Tree where the maximum number of key values in each leaf node is 2 and the maximum number of pointers in each non-leaf node is 3. Let…