Skip to content
Related Articles

Related Articles

Improve Article

GATE | GATE CS 2008 | Question 15

  • Last Updated : 28 Jun, 2021
Geek Week

A clustering index is defined on the fields which are of type
(A) non-key and ordering
(B) non-key and non-ordering
(C) key and ordering
(D) key and non-ordering


Answer: (A)

Explanation: A clustering index as the name suggests is created when the data can be grouped in the form of clusters.

yashika

For example: A small database file storing roll no and subjects enrolled for a particular student. Here data can be grouped on the basis of Roll No.s.

Hence to create such kind of index files, fields could be non-key attributes and which are in ordered form so as to form clusters easily.
Hence option (A) – non key and ordering.
Additional points for Clustered Indexing:
1. The number of entries in the index file
are the unique values of the attribute on which indexing is done.
2. The pointer in the index file will give the base address of the block in which the value appear for the first time.

https://www.geeksforgeeks.org/indexing-in-databases-set-1/



This solution is contributed by Yashika Arora.

Quiz of this Question

Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

My Personal Notes arrow_drop_up
Recommended Articles
Page :