Question

Which are the common database operations that can help organize data for easy retrieval?

Answer 1

There are two common types for data access or retrieval

1. Sequential access is the main access mode only in batch systems, whereas files are used and updated at regular intervals.

2. Direct access - on-line processing requires direct access, whereby a record can be accessed without accessing the records between it and beginning of the file.