GATE 1994
A database data file contains 20,000 records sorted on a primary key field. Each disk block holds 20 records. A sparse primary index is created with one entry per block. How many index entries are in the primary index?
Related Database Management PYQs
Which of the following relational algebra expressions is equivalent to the SQL conditional cross-join: SELECT * FROM R, S WHERE R.…
In relational algebra, the division operator (R ÷ S) is used to express queries involving:
In a B+ tree, searching for a single record with a specific search key value takes time proportional to:
A primary index is created on a field that is:
Let P, Q, R and S be the attributes of a relation in a relational schema. Let X → Y indicate functional dependency in the context …
In the context of relational database normalization, which of the following statements is/are true?
Free account benefits
Turn practice into measurable progress
Public PYQs and reference pages stay free. Sign in when you want GATEverse to remember what you studied and guide what to practise next.
Saved progressKeep answers, mock results and completion history across devices.
Adaptive practiceGet questions matched to your recent accuracy and difficulty level.
Bookmarks and notesBuild a personal revision list and record why a question was difficult.
Performance insightsSee weak subjects, accuracy trends, streaks and exam readiness.