Exams › GATE › Technical

An index is clustered if

1. it is on a set of fields that form a candidate key.
2. it is on a set of fields that include the primary key.
3. the data records of the file are organized in the same order as the data entries of the index.
4. the data records of the file are organized not in the same order as the data entries of the index.

Correct answer: the data records of the file are organized in the same order as the data entries of the index.

Solution

A clustered index organizes the actual data records in the database table in the same order as the index entries, allowing for faster retrieval of data since the physical storage aligns with the logical ordering of the index.

Related GATE Technical questions

• The truth table X Y f(X,Y) 0 0 0 0 1 0 1 0 1 1 1 1 represents the Boolean function
• The decimal value 0.5 in IEEE single precision floating point representation has
• A process executes the code fork(); fork(); fork(); The total number of child processes created is
• The protocol data unit (PDU) for the application layer in the Internet stack is
• Which of the following problems are decidable? 1) Does a given program ever produce an output? 2) If L is a context-free language, then is L̄ also context-free? 3) If L is a regular language, then is L̄ also regular? 4) If L is a recursive language, then is L̄ also recursive?
• A binary operation ⊕ on a set of integers is defined as x ⊕ y = x² × y². Which one of the following statements is TRUE about ⊕?

⚔️ Practice GATE Technical free + battle 1v1 →