Home » Database » Database miscellaneous » Question

Database miscellaneous

  1. 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
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.



Your comments will be displayed only after manual approval.