Answer and Explanation:
Given that total number of records in a file = 100000
Each record consists of= 240 bytes
Given that B= 2400 bytes.
Then total blocks in file = 100000 records * 240 / 2400
= 10000 blocks.
Time that will take for exhaustive read
= s + r + b.btt
= 16 + 8.3 + (10000) * 0.8
= 8024.3 msec
Now as per given X be the number of records that are searched randomly and it takes more than exhaustive read time.
Hence, X (s + r + btt) > 8024.3
X (16+8.3+0.8) > 8024.3
X > 8024.3/25.1
So that, X > 319.69
Hence, atleast 320 random reads should be made to search the file
Answer:
SELECT vendor_number, vendor_name, CONCAT ('street', ' ' , 'city', ' ' , 'state', ' ' , 'zip code') as adress
FROM vendor_directory
ORDER BY vendor_name ASC;
Explanation:
* Suppose <u>vendor_directory</u> is the name of the table from which you extract the data with the SELECT sentence.
Definition
URL a.k.a uniform resource locater, is simply the address of a World Wide Webpage.
Sentence example:
"Type a URL into a browser's address bar."
Answer: TRUE! 100%
If I was helpful i would to be rated brainliest please thank you!
Explanation: