-
A clustering index is defined on the fields which are of type
-
- non-key and ordering
- non-key and non-ordering
- key and ordering
- key and non-ordering
- non-key and ordering
Correct Option: A
We are given that the clustering index is defined on the fields. Now, if the records of the file are physically ordered on a non-key field since it is a non-key, it will not have a distinct value for each record. Therefore, the clustering index is defined on the fields of type non-key and ordering.