• retagged by
690 views
0 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

Please log in or register to answer this question.

Position:
Show:

Related questions

2 2 votes
1 1 answer
456
456 views
Vaibdoesit asked Sep 7, 2024
456 views
There is a schema as follows : loan(custname, branch, loanno, amount) with following Functiona dependencies : 1. custname - loanno.2.loanno. - amountbased on this the sch...
0 0 votes
0 0 answers
4.1k
4.1k views
ibia asked Apr 6, 2016
4,074 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...
0 0 votes
1 1 answer
2.6k
2.6k views
mukul maurya asked Sep 1, 2018
2,596 views
Identify the valid data type which can be used in sql to define type of data ?a. varcharb. memoc. numericd. string
0 0 votes
1 1 answer
707
707 views
roopkathaaa asked Aug 25, 2023
707 views
Your friend wants to design synchronization primitives and tells you that he would be better off by strictly ensuring that the processes alternate the critical section. Y...