Register

Indexing

• edited by
381 views
0 votes
0 votes
consider a display block size is equal to 1024 bytes A block pointer 6 byte and record pointer 8 byte the file has 10000 employees record every record is fixed length of 100 bytes it is he is SSN which is a 2 byite the file is not ordered by the key field SSN and want to construct a secondary index on SSN and find out the number of blocks required in the first level index.
• edited by
User Avatar

1 Answer

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
Suryadip asked Mar 9
107 views
File organisation and indexing (DBMS)
User Avatar
0 votes
0 votes
1 answer
2
vishnu777 asked Nov 8, 2022
411 views
Indexing in database(Self Doubt)
Can anyone explain in detail about the concepts of sencondary indexing in dbms??
Can anyone explain in detail about the concepts of sencondary indexing in dbms??
User Avatar
2 votes
2 votes
1 answer
4
srestha asked May 13, 2019
1,764 views
Made Easy Test Series:Databases-Indexing
Consider the following statement below: $A)$ A clustered index may be either sparse or dense. $B)$ Every $B^{+}$ tree index is dense. Which of the above statement is true? Is clustering Index can be dense. Dense means non-ordering field, but clustering field should be ordering field right??
Consider the following statement below:$A)$ A clustered index may be either sparse or dense.$B)$ Every $B^{+}$ tree index is dense.Which of the above statement is true?Is...
User Avatar
Link Copied!