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.

  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…