An index is clustered, if
Topic-wise GATE CS PYQs with verified steps
GATE CSE 2013 · Q15
MCQ1 markEasy
Time
An index is clustered, if
Select one answerSingle correct
Pick an option to check
Solution
Step-by-step verified solution
Official answer: C) the data records of the file are organized in the same order as the data entries of the index.
File Organization and IndexingA clustered index is defined as an index whose search key specifies the sequential order of the file; that is, the physical records in the data file are stored in the same order as the data entries of the index.
Option A and B: An index on a candidate or primary key is not necessarily clustered (it can be dense/sparse or unclustered).
Option C: Correctly defines a clustered index.
Option D: Defines an unclustered (non-clustered / secondary) index.
Try the question first, then check your work.
Examiner trap
The misconception this question tests
Recall the relationship between the physical storage ordering of data records in a table and the order of entries in a clustered index.
This File Organization and Indexing previous year question is Q15 of the GATE CSE 2013 paper. Find more GATE CSE PYQs on File Organization and Indexing in Databases, or browse all GATE CSE PYQs.
Free diagnostic
Where do you stand for GATE?
Take the 20-minute diagnostic: the 3 topics that cost you the most marks, and a rank range. Or sit 5 related File Organization and Indexing PYQs now with no account.
One GATE CSE PYQ every morning
An official question by email at 7 AM IST, with a link to its verified solution. Unsubscribe in one click.
File Organization and Indexing in GATE CSE
File Organization and Indexing has 17 GATE CSE PYQs across 17 papers from 2011 to 2026. 5 of them are 1-mark MCQs like this one, and it is the only one in GATE CSE 2013.
How GATE tests File Organization and IndexingMore from GATE CSE 2013
- Q17Which of the following statements is/are FALSE? 1. For every non-deterministic Turing machine, there exists an equivalent deterministic Turing machine. 2. Turi…MCQ1 markEasy
- Q13Using public key cryptography, X adds a digital signature to message M, encrypts M, , and sends it to Y, where it is decrypted. Which one of the following sequ…MCQ1 markMedium
- Q18Which of the following statements are TRUE? 1. The problem of determining whether there exists a cycle in an undirected graph is in P. 2. The problem of determ…MCQ1 markEasy
- Q12The transport layer protocols used for real time multimedia, file transfer, DNS and email, respectively areMCQ1 markEasy
Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.