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 youre 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 youre 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 _____________