Answer the following statements true (T) or false (F)

1. It is possible (and can be useful) to keep multiple index files on a single data file.
2. Use of an index file increases the number of required block accesses of the data file, especially for adds and removals.
3. When external hashing is used, you hash the index file instead of the data file
4. It is not possible to organize an index file as an external 2-3 tree.
5. In an external environment, the advantage of keeping a search tree short far outweighs the disadvantage of performing extra work, such as comparisons, at each node.


1. True
2. False
3. True
4. False
5. True

Computer Science & Information Technology

You might also like to view...

A(n) ______________ should be used to declare the size of an array, because it eliminates magic numbers.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

You can use the ____ command in enable mode to retrieve the statistics that CDP will report on the local router's interfaces.

A. show cdp running B. show cdp startup C. show cdp config D. show cdp interface

Computer Science & Information Technology

Suppose a new tech startup wants to define the data model. They would then ____.

A. collect and cleanse the data B. define user access privileges C. create the entity-relationship model D. acquire a new database management system

Computer Science & Information Technology

Critical Thinking QuestionsCase 1-2You work at home and are planning to have an Internet connection installed in your home office. As part of your planning effort, you must decide on the best type of connection for your needs. Which of the following Internet connection types is the better choice if cost is no object and you live in a rural area with few other alternatives? a. ADSLc. DSLb. satellited. cable

What will be an ideal response?

Computer Science & Information Technology