How long will it take to find the block with the depratti

Assignment Help Computer Engineering

Reference no: EM132103958

Problem Assumptions:

There are 20,000 blocks on the CSC342.Person table file.

The table file is structured as a Heap file.

There is a ‘Last_Name' index on the table

The index has 4 levels.

It takes 1 millisecond to read a block from disk.

There is one person row with the last name = 'DePratti'

You want to do an equality search looking for all people with the last_name = ‘DePratti'.

How long will it take to find the block with the DePratti row?

Choose one from below

5 ms

4 ms

10 ms

20 ms

Reference no: EM132103958

Questions Cloud

What velocity would you need to shoot the ball into bucket : What velocity would you need to shoot the ball into the bucket? Note that the launch angle (?) was 27.5°

Transform the loop by unrolling the loop and reschedule : Consider the following code and answer the following questions. Note that F2 register holds a scalar constant that cannot be changed for the computation.

How far from the starting point is the first check point : In its motion, it takes 1.6 secs to pass between two points that are 24.0 m apart in its motion.

Annual consumption of energy in the united states : The book says that the annual consumption of energy in the United States is about 105 x 1018 J/year.

How long will it take to find the block with the depratti : You want to do an equality search looking for all people with the last_name = ‘DePratti'. How long will it take to find the block with the DePratti row?

Calculate the work done in lifting : Calculate the work done in lifting a 4-lb book to a height of 8ft.

Name three different types of advantages of technology : Advances in technology often lead to the development of a new or improvised system by exploiting an advantage not possessed by its predecessor.

What is the process for calculating launch velocity : What is the process for calculating launch velocity? Launch angle is 27.5 deg, launch height is 9.59 m, height of bucket opening is 2.5 m and the range is 68.

Describe a method for alice to encrypt an m-block message : Describe a method for Alice to encrypt an m-block message such that it can only be decrypted with the cooperation of both Bob and Charlie.

User Account

All Pages