Phman Super

<div>
Unless my help was wrong, you should close the question by accepting my comment as the solution. Otherwise, please state what was wrong.
</div>


Unless my help was wrong, you should close the question by accepting my comment as the solution. Otherwise, please state what was wrong.

<div>
<div class="content wysiwyg-content">
Suppose a heap file contains 100,000 records of 400 bytes each. Block size is 4096. &nbsp;During processing, 2 records get added to the end of the file for every record deleted somewhere within the file. &nbsp;This continues until the file has 200,000 active records.<br />
<br />
a. How many disk blocks does the file currently occupy?<br />
b. How many records have been deleted?<br />
c. How percentage of the space within the file is not being used?
</div>
</div>


Suppose a heap file contains 100,000 records of 400 bytes each. Block size is 4096.  During processing, 2 records get added to the end of the file for every record deleted somewhere within the file.  This continues until the file has 200,000 active records.

a. How many disk blocks does the file currently occupy?
b. How many records have been deleted?
c. How percentage of the space within the file is not being used?

Heap File

An algorithm is a self-contained step-by-step set of operations to be performed. Algorithms exist that perform calculation, data processing, and automated reasoning. Starting from an initial state and initial input (perhaps empty), the instructions describe a computation that, when executed, proceeds through a finite number of well-defined successive states, eventually producing "output" and terminating at a final ending state. The transition from one state to the next is not necessarily deterministic; some algorithms, known as randomized algorithms, incorporate random input.