Multiple Choice
Which of the following is true about indexes, in general?
A) An index can only be built over a field that has unique values.
B) Only one field of a file can be indexed.
C) An index can be used to retrieve the records of a file in logical sequence based on the indexed field.
D) An index cannot be built over a combination of fields of a file.
E) The updating of an indexed field in a record requires that the index be updated but record insertions and record deletions do not require any index to be updated.
Correct Answer:

Verified
Correct Answer:
Verified
Q11: The creating a new primary key physical
Q12: In the clustering files physical database design
Q13: The movement of a disk drive's access
Q14: In a disk, once the access arm
Q15: Physical database design is necessary _.<br>A) to
Q17: A file can have only one index
Q18: All of the following are good candidates
Q19: In terms of performance, there is no
Q20: Each entry in a simple linear index
Q21: Using the clustered files technique involves reorganizing