disk configuration
Assume that the average seek time is 10 milliseconds and rotational latency is 6 milliseconds.
Consider the following disk configuration:
a. Sector size = 1024 bytes
b. The number of tracks = 4000 at each surface
c. The number of sectors = 100 per track
d. Disk contains multiple platters
e. Block size = 1024 bytes
Consider the following for the database:
a. A file with 200,000 rows
b. Row size = 200 bytes. Each row is of the same size.
c. A row exists in a single block only.
Now answer the following questions:
1 How many rows will fit in a block?
2. What time is required to read a file containing 100,000 records of 100 bytes each sequentially?
3. What is the time required to read a file containing 100,000 records of 100 bytes each in a random order?
Please explain clearly I will give upvote
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
