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.
• The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTERINSERT trigger.