Question 2
Marks : +2 | -2
Pass Ratio : 100%
Which of the following is an issue that needs to be considered while choosing an indexing technique?
Explanation: The frequency of insertion and deletion has to be taken into consideration while choosing an indexing technique. The frequency of insertion and deletion determines the hash index.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
Hash structures are not the best choice for which of the following?
Explanation: Hash structures are not the best choice for search keys on which range queries are likely because the range queries might contain different values of the search keys which might result in improper placement in the hash table.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
Which of the following is a disadvantage of the dynamic hashing structure
Explanation: In dynamic hashing, lookup involves an additional level of indirection. The rest of the options are the advantages of dynamic hashing.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
Dynamic hashing allows us to?
Explanation: Dynamic hashing allows us to accommodate the growth of the database and the shrinkage of the database by allowing us to change the hash function dynamically.