Database: 1. What is the approximate access time of a hard drive. Is it a) 200 m

Question

Database:

1. What is the approximate access time of a hard drive. Is it a) 200 microseconds, b) 100

milliseconds, or c) 15 milliseconds? _________

2. What is the approximate cost of storage, in $/GB, for a 2 GB internal hard drive? a)

$0.05/GB   b) $0.10/GB   c) $0.25/GB   d) $1.00/GB __________________

3. What is the approximate cost of storage, in $/GB, for a 500 GB internal SSD drive? a)

$0.10/GB b) $0.50/GB c) $1.00/GB d) $2.00/GB ___________________

4. Suppose you’re reading a 250 MB file from a hard drive using a sequential access pattern. Using typical hard drive specs, about how long does the read take? a) 0.5 sec b) 2.0 sec c) 10 sec. ___________________

5. Suppose you’re reading a 250 MB file from a hard drive using a random access pattern, where the file is split is located in 1000 different locations across the drive. Using typical hard drive specs, about how long does this read take?   a) 0.5 sec   b) 2.0 sec c) 10 sec

______________________

6. Is a search key a) a primary key, b) any candidate key, or c) any attribute or collection of attributes? _________

7. In the hard drive you would buy today, is the number of sectors per track constant across the hard drive surface?     a) yes b) no                                    _____________

Explanation / Answer

1. c)15 milliseconds
2. a)$0.05/GB
3. d) $2.00/GB
4. a) 0.5 sec
5. b) 2.0 sec
6. c) any attribute or collection of attributes
7. b) no

**Comment for any further queries.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.