Suppose that your DBMS supports the following file organization: Heap file, Sorted file, Clustered file, Heap file with unclustered tree index, and Heap file with unclustered hash index. Discuss which organization you would choose for a file where the most frequent operations are as follows:

• Need to search for records using a range of field values
• Need to frequently perform inserts and scans, but don't cart about the record order
• Need to search for records using a particular field value.
  
  

Answer rating: 100% (QA)

1 Sorted file Organisation In this method As the name itself suggest whenever a new record has to be ... View the full answer