retagged by
193 views
0 votes
0 votes
Use the following information to answer Questions 7 and 8.

A sorted file has the following details: Number of records = 13,10,720; record length = 200 bytes;

size of the primary key field = 13 bytes; size of block pointer = 7 bytes; block size = 2048 bytes. For this file, we need to build a multi-level index on the

primary key.

1 point

7) The blocking factors for the data file and the index file, respectively, are

a)11,292

b)10, 100

c)11, 101

d)10, 102

Accepted Answers:

10, 102

8) The number of blocks in the first level index file is:

a)131072

b)1311

c)1310

d)1286

Accepted Answers:

1286
retagged by

Please log in or register to answer this question.

Related questions

3.6k
views
0 answers
0 votes
ibia asked Apr 6, 2016
3,637 views
Specify the following queries in SQL on the COMPANY relational database schema shown in figure 3.5 .Show the result of each query if it is applied to the COMPANY databas...
2.2k
views
1 answers
0 votes
mukul maurya asked Sep 1, 2018
2,227 views
Identify the valid data type which can be used in sql to define type of data ?a. varcharb. memoc. numericd. string
1.5k
views
2 answers
3 votes
srestha asked May 17, 2019
1,504 views
The minimum number of nodes (both leaf and non-leaf) of $B^{+}$ tree index required for storing $5500$ keys and order of $B^{+}$ tree is $8$________________(order is max ...
645
views
0 answers
2 votes
Ayush Upadhyaya asked Oct 12, 2018
645 views
I have two doubts here(1)Doubt1-The number of blocks needed to store file must be 3000 and not 2930. Record organisation is unspanned and so 1 block can contain only 10 r...