Multiple Choice
-In an indexed sequential file _____.
A) only one field may be indexed
B) the field on which the file is sequenced must be indexed
C) a field other than the one on which the file is sequenced must be indexed
D) it is possible that there is no index
E) the record addresses in the index must be sorted
Correct Answer:

Verified
Correct Answer:
Verified
Q41: One of the main potential problems in
Q42: Storing derived data improves performance in the
Q43: A record insertion in a B+-tree index
Q44: Direct access can be achieved _.<br>A) with
Q45: Both horizontal and vertical partitioning can improve
Q47: Denormalization can improve the _.<br>A) performance of
Q48: The first step in indexing a file
Q49: Building indexes over relational tables always has
Q50: Combining two tables that represent a one-to-one
Q51: Response time is the measure of how