File Organization and Access Methods

Which file access method requires records to be accessed in order, one after another, starting from the beginning?

• Sequential

• Direct

• Indexed

• Random

In which scenario is sequential access considered ideal for processing data?

• Real-time transaction processing

• Quick retrieval of specific records

• Batch processing of large data volumes

• In-memory key-value lookups

What is a key characteristic of direct access that allows for immediate retrieval of records?

• Records are stored in a predefined order

• It requires traversing all previous records

• It uses hashing to calculate storage addresses

• It relies on B-tree structures for lookup

What is a primary advantage of Indexed Access compared to Sequential Access?

• Lower storage overhead

• Simpler implementation

• Faster lookup without scanning the entire file

• Better update efficiency for entire files