Recent questions tagged indexing

2 votes
1 answer
61
Here the indexing is done on ordered field so which to use Dense or Sparse because both can be done here ?
1 votes
1 answer
62
Please Solve this question. I didn't understood the question properly so please Make Me as well :) What is meant by Leaf Page ?
1 votes
3 answers
67
A file is organized so that the ordering of data record is same as or close to the ordering of data block in some index. Then that index is called:-DenseSparse.ClusteredU...
2 votes
2 answers
71
Which of the following is dense index?Primary indexClustered indexSecondary indexSecondary non-key index
0 votes
2 answers
72
What is the Difference between Primary and Clustering Index or both are actually the Same ?
1 votes
1 answer
74
which of the statements are correct?A a clustered index offers much better performance than unclustered index for range queriesB a clustered index istypically less expens...
0 votes
0 answers
77
B tree has minimum space utilization equals to 66.6%.explain?
0 votes
1 answer
78
2 votes
2 answers
80
Database file consist 1250 records. Block can hold either 3 records or (10 keys, 11 pointers). The maximum number of levels of index required for sparse B+ tree index for...
1 votes
0 answers
82
1 votes
0 answers
83
2 votes
1 answer
85
Every ________ index is Clustereda)primaryb)secondary
3 votes
1 answer
87
" For any data file, it is possible to construct two separate dense first level indexes on different keys. "How the above statement is true ??
0 votes
0 answers
89
0 votes
0 answers
90
A file can have either one primary index or one clustered index but not both. True or false ? Give an answer with explanation.