Test by Bikram | Databases | Test 1 | Question: 19

Question

Which is the best file organization when data is frequently added or deleted from a file?

• A. Sequential
• B. Direct
• C. Index sequential
• D. None of the above

Comments

https://gateoverflow.in/37735/which-organization-when-frequently-added-deleted-iete_elan

---

Direct file organisation => Random access (uses hashing)

Answer 1

bikram sir ,

A) Sequential Access slower as has to start from the begining every time.

B) Direct Acces very quick for repeated accesses.

C) What is Index Sequential ? Is it that you read through all the indices sequentially , which will then make it slower than the second one.

Comments

@Harsh

ISAM (Indexed Sequential Access Method) is a file management system that allows records to be accessed either sequentially(in the order they were entered) or randomly (with an index).

Each indexdefines a different ordering of the records.

read this http://searchdatacenter.techtarget.com/definition/ISAM

that sequential behaviour make them slow when data is deleted / added frequently.