280 views
0 votes
0 votes

Consider a disk with block size B=512 bytes. A block pointer is P=6 bytes long, and a record pointer is PR =7 bytes long. A file has r=16384 STUDENT records of fixed-length. Each record has the following fields: 
NAME (30 bytes), ROLL(9bytes), DEPARTMENT(9 bytes), ADDRESS(40 bytes), 
PHONE (10 bytes), DOB(8 bytes), CLASS(4 bytes), 
Two additional bytes are used as markers. Multilevel indexing is used. 
If the file is ordered using ROLL value, the number of block accesses needed to search for and retrieve a record from the file is:

a)3

b)4

c)5

d)6

Please log in or register to answer this question.

Related questions

0 votes
0 votes
0 answers
1
sim1234 asked Dec 21, 2018
715 views
Suppose R is a table with 4 attributes A,B, C and D, and S be a table with 3 attributes B, E, F. Now given a particular instance of R and S.S is empty, having no tuples. ...
0 votes
0 votes
0 answers
2
sim1234 asked Dec 17, 2018
403 views
Database that are designed and managed specifically to meet information needs are calledDatabase Management systemData WarehousesTransaction databasesProduction databases...
2 votes
2 votes
0 answers
3
1 votes
1 votes
1 answer
4
sim1234 asked Dec 26, 2018
708 views
Assuming that a pointer take 4 bytes and the size of an integer is 2 bytes. What is the size of the *a in declaration: int (*a) [10] ? 4802040