Index
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is the purpose of a database index?
2. What happens if a table has more indexes than it needs?
3. When is an index normally created on a table?
4. In the Library of Congress analogy for indexing, roughly how many items does the library hold?
5. What does the Library of Congress analogy illustrate about why indexes are needed?
6. Which of the following is an advantage of indexing?
7. Which of the following is a disadvantage of indexing?
8. What does a database management system need on a table in order to perform indexing?
9. Which of the following is NOT listed among the types of index?
10. Which restriction applies to an index-organised table?