Non-key & ordering of clustering index is defined on fields - Database

Q.  Which type of clustering index is defined on the fields?
- Published on 25 Aug 15

a. Non-key and non-ordering
b. Non-key and ordering
c. Key and non-ordering
d. Key and Ordering

ANSWER: Non-key and ordering

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 04 Nov 15
    - Indexing is defined based on its indexing attributes.

    - The different types of Indexing are:

    Primary Index
    - It is defined as an ordered data file.
    - The data file is ordered on a key field.
    - The key field is generally the primary key of the relation.

    Secondary Index
    - This index may be generated from a field which is a candidate key and has a unique value in every record, or a non-key with duplicate values.

    Clustering Index
    - This index is defined on an ordered data file.
    - The data file is ordered on a non-key field.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲