Question
Which of the following collision resolution techniques
involves storing all elements that hash to the same value in a linked list?Solution
Chaining is a collision resolution strategy where each index in the hash table is associated with a linked list. If multiple keys hash to the same index, they are added to the linked list at that index. This method allows the hash table to handle an unlimited number of collisions at a single index by dynamically growing the linked list. Advantages of chaining include:
- Simplifies handling collisions, especially in cases with high load factors.
- Reduces clustering compared to open addressing.
- Efficient for insertions and deletions as they occur in linked lists.
The result of a Cartesian product of two relations R and S will have:
Which command is used to remove all records from a table without deleting the table structure?
Which of the following is a valid constraint in SQL?
Which of the following is true about a view in SQL?
Which of the following prevents inheritance in C++?
What is early binding in the context of OOP?
Which of the following is used to eliminate redundancy and anomalies in a database?
Which SQL keyword is used to sort the result set?