Back to the 2025 paper
Similar questions
Database Management SystemWhat are indices in database systems? Explain the need and advantages of indexing. Describe various types of indexing techniques including primary index, secondary index, clustered and non-clustered indexes with the help of suitable diagrams.20247mDatabase Management SystemWhich of the following is used for indexing in database systems? (i) Transaction log (ii) B-tree (iii) Views (iv) Triggers20242mDATABASE MANAGEMENT SYSTEMWhat are the differences between primary index and secondary index?20217mDatabase Management SystemWhat is a B-tree? Explain its structure, order, and properties. How is a B-tree used in database indexing? Demonstrate insertion and search operations in a B-tree with a proper example. Also compare B-tree with binary search tree in context of database performance.20247m
PreviousExplain different normal forms up to BCNF with examples.NextConsider a hash table of size 10 with the hash function h(k) = k \pmod{10}. Insert the keys 23, 43, 13, 27, 37, and 50 into the hash table. Construct the hash table using separate chaining for collision resolution and then reconstruct it using linear probing. Compare the final arrangements obtained using both methods.