in Education by
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. (a) Clustered index (b) Structured index (c) Unstructured index (d) Nonclustered index The question was asked by my school principal while I was bunking the class. The query is from Bitmap Indices in section Indexing and Hashing of Database Management

1 Answer

0 votes
by
Right answer is (a) Clustered index The best I can explain: Clustering index are also called primary indices; the term primary index may appear to denote an index on a primary key, but such indices can in fact be built on any search key.

Related questions

0 votes
    In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Indices whose search key specifies an order different from the sequential order of the file are called ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    In a _______ clustering index, the index record contains the search-key value and a pointer to the first ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Bitmap indices are a specialized type of index designed for easy querying on ___________ (a) Bit values ( ... Bitmap Indices in division Indexing and Hashing of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    In a __________ index, an index entry appears for only some of the search-key values. (a) Dense (b) ... from Ordered Indices in portion Indexing and Hashing of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    An ____________ consists of a search-key value and pointers to one or more records with that value as ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    A search key containing more than one attribute is referred to as a _________ search key. (a) Simple ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Given a binary file STUDENT.DAT , containing records of the following type: [S_Admno, S_Name, Percentage] Where these ... is above 75. Select the correct answer from above options...
asked Dec 10, 2021 in Education by JackTerrance
0 votes
    The algorithm that uses a secondary ordered index to guide retrieval for comparison conditions involving is ( ... Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Incase the indices values are larger, index is created for these values of the index. This is called (a) ... Ordered Indices in chapter Indexing and Hashing of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    Bitmaps can be combined with regular B+-tree indices for relations where a few attribute values are ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    What is key that dictates how the rows are ordered on reads? (1)Comparator (2)Position and size (3)Size or length (4)Shapes...
asked May 7, 2021 in Technology by JackTerrance
...