Indices whose search key specifies an order different from the sequential order of the file are called                        indices.

Related MCQs

• Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.
• In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.
• In a                clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• An                          consists of a search-key value and pointers to one or more records with that value as their search-key value.
• A search key containing more than one attribute is referred to as a                    search key.
• An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
• A search key containing more than one attribute is referred to as a _________ search key.
• State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
• A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency