Question: SQL Question Consider a disk with the following characteristics: block size B=512 bytes, interblock gap size G=128 bytes, number of blocks per track=20, number of

SQL Question

SQL Question Consider a disk with the following characteristics: block size

Consider a disk with the following characteristics: block size B=512 bytes, interblock gap size G=128 bytes, number of blocks per track=20, number of tracks per surface=400. A disk pack consists of 15 double-sided disks. (a) What is the total capacity of a track and what is its useful capacity (excluding interblock gaps)? (b) How many cylinders are there? What is the total capacity and the useful capacity of a cylinder? (d) What is the total capacity and the useful capacity of a disk pack? Suppose the disk drive rotates the disk pack at a speed of 2400 rpm (revolutions per minute); what is the transfer rate (tr) in bytes/msec and the block transfer time (btt) in msec? What is the average rotational delay (rd) in msec? What is the bulk transfer rate (btr)? (1) Suppose the average seek time is 30 msec. How much time does it take on the average) in msec to locate and transfer a single block given its block address? (g) Calculate the average time it would take to transfer 20 random blocks (may not be on the same cylinder) and compare it with the time it would take to transfer 20 consecutive blocks (all in on cylinder). m

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Question 1: Consider a disk with the following characteristics: block size B=512 bytes, interblock gap size G=128 bytes, number of blocks per track=20, number of tracks per surface=400. A disk pack...

Consider a disk with the following characteristics: block size B = 5 1 2 bytes, inter - block gap size G = 1 2 8 bytes, number of blocks per track = 2 0 , number of tracks per surface = 4 0 0 . A...

Consider a disk with the following characteristics: block size B=512 bytes, interblock gap size G=28 bytes, number of blocks per track =20, number of tracks per surface =400. A disk pack consists of...

Suppose that a disk unit has the following parameters: seek time s = 1 0 msec; rotational delay r d = 5 msec; block transfer time btt = 1 . 5 msec; block size B = 2 4 0 0 bytes; interblock gap size G...

Consider a disk with the following characteristics: block size B = 512 bytes, interblock gap is G = 128 bytes, the number of blocks per track is 20, and the number of tracks per surface is 400. A...

Consider a disk with the following characteristics: block size B = 1 2 8 bytes; number of blocks per track = 4 0 ; number of tracks per surface = 8 0 0 . A disk pack consists of 2 5 double - sided...

Examples Q1:Consider a disk with the following characteristics: block size B 512 bytes; interblock gap size G-128 bytes; number of blocks per track -20; number of tracks per surface 400. A disk pack...

Consider a disk with the following characteristics (these are not parameters of any particular disk unit): block size B=512 bytes, interblock gap size G=128 bytes, number of blocks per track=20,...

Question 1. Suppose that a disk unit has the following parameters: seek time = 15 milliseconds (ms); rotational delay = 30 ms; block transfer time = 2 ms; block size = 2048 bytes; interblock gap size...

The revenues and expenses of Paradise Travel Service for the year ended May 31, 2018, follow: Accounts Fees earned $801,000 Office expense 295,300 Miscellaneous expense 10,000 Wages expense 451,700...

Calculating area of rectangle Report the answer with the correct number of significant figures. Length (cm) Width (cm) Area (cm) Your measurements 20.12 14.45 ?

View Policies Current Attempt in Progress Having one person responsible for the related activities of ordering merchandise, recelving goods, and paying for them is an example of good internal...

The supplies account had a beginning balance of $1,707. Supplies purchased during the period totaled $4,961. At the end of the period before adjustment, $242 of supplies were on hand. Prepare the...

Assess the benefits and concerns that may arise as a result of the relative sizes of P-time and Dtime. Compile your views in the table below: Benefits P-time greater than D- P-time = D-time time...

List six applications of responsiveness in an organisation: for example, external phone calls answered within five rings. How many organisations can you think of that compete overtly on time, such as...

2 Explain the significance of P:D ratios. How can the production lead time be reduced?