edited by
13,857 views
33 votes
33 votes

A clustering index is defined on the fields which are of type

  1. non-key and ordering
  2. non-key and non-ordering
  3. key and ordering
  4. key and non-ordering
edited by

4 Answers

Best answer
38 votes
38 votes

There are several types of ordered indexes. A primary index is specified on the ordering key field of an ordered file of records. Recall from Section 17.7 that an ordering key field is used to physically order the file records on disk, and every record has a unique value for that field. If the ordering field is not a key field- that is, if numerous records in the file can have the same value for the ordering field— another type of index, called a clustering index, can be used. The data file is called a clustered file in this latter case. Notice that a file can have at most one physical ordering field, so it can have at most one primary index or one clustering index, but not both

Reference -> Database Systems book BY Navathe, $6^{th}$ Edition, 18.1 Types of Single- Level Ordered Indexes Page no. 632.

Answer should be A.

edited by
29 votes
29 votes

A clustered index can be created on any attribute set, which is ordered (but maximum one for a table). By default, it is created for the primary key. We can change this to any non-key also. So, (A) and (C) can have clustered index. I guess the question assumes primary index as not being called clustered index, so answer should be A. 

http://msdn.microsoft.com/en-us/library/ms186342.aspx

4 votes
4 votes
Clustering index is an index whose search key also defines the sequential order of the file. Clustering indices are also called primary indices. The primary index may appear to denote the index of an primary key; but can be built on any search key. The serach key of an clustering index is also called primary key;although not necessarily ... so search key can be non key value and it works on sequential manner means ordered ... so option A ..
Answer:

Related questions

37 votes
37 votes
8 answers
1
Kathleen asked Sep 11, 2014
17,613 views
What is the maximum size of data that the application layer can pass on to the TCP layer below?Any size$2^{16}$ bytes - size of TCP header$2^{16}$ bytes$1500$ bytes
33 votes
33 votes
5 answers
2
67 votes
67 votes
5 answers
3
ABG asked Sep 2, 2014
23,531 views
Consider a file of $16384$ records. Each record is $32\;\text{bytes}$ long and its key field is of size $6\;\text{bytes}$. The file is ordered on a non-key field, and the...