Which of the following is characteristic of the indexed-sequential access method?
A) Processing is direct-access; queries are sequential.
B) Processing is sequential; queries are handled through an index.
C) Processing and queries are both handled through an index.
D) Processing and queries are both sequential.

Question

Quizplus · Accepted Answer

The indexed-sequential access method involves sequential processing but allows for queries to be handled through an index, which improves access time. Therefore, option B is the correct choice. Option A is incorrect because queries are not sequential, and option C is incorrect because processing still involves sequential access. Option D is also incorrect as only queries are not sequential, not both processing and queries.

Which of the Following Is Characteristic of the Indexed-Sequential Access