Quiz 2

1. Which of the following file organizations must be used if one needs to retrieve all records in random order? ● Heap files ● Sorted files ● Indexes ● Scanned files 2. For which type of operations are heap files a sufficient method? ● Sorting data ● Bulk loading data ● Indexing data ● Selecting data 3. What is the purpose of file indexes? ● Sorting data ● Selecting data ● Searching data ● Loading data 4. In terms of decreasing the time it takes to process data searches, when does it make sense to create indexes for a database table? ● When the number of table columns is small. ● When the number of rows is much lower than the number of columns in the table. ● When data retrieved by queries is a large percentage of the available data in the table. ● When data retrieved by queries is a small percentage of the available data in the table. 5. Creating indexes is not a straightforward decision because of the costs involved. One must answer certain questions before creating indexes. Which of the following questions is not relevant? ● Should one build multiple indexes? ● Which tables should be indexed? ● Which record(s) should be part of an index? ● Which field(s) should be part of an index? 6. What does CPU stand for? ● Central Process Unit ● Center Processor Unit ● Central Processing Unit ● Center Process Unit 7. Which of the following computer components has the fastest processing speed? ● CPU ● Hard Disk ● Cache ● Memory 8. Which of the following computer components has the slowest processing speed? ● Memory ● Cache ● Hard Disk ● CPU