Project ForgeDatabase Management Systems
Indexing
GATE 2008
Medium
A clustering index is defined on the fields which are of type
- non-key and ordering
- Bnon-key and non-ordering
- Ckey and ordering
- Dkey and non-ordering
Explanation
A clustering index is built on the field that determines the PHYSICAL ORDERING of the data file — that ordering field need NOT be a key (multiple records can share the same ordering-field value), distinguishing it from a primary index (built on a key, ordering field) or a secondary index (non-ordering field).
Source: GATE CS 2008 (2008)
This question is part of a 15-day revision cycle — sign in and Project Forge will bring it back the day before you'd forget it.