Back to the 2020 paper
Similar questions
Database Management SystemFor the following set of key values construct a B+ tree with a degree 4: 5, 10, 15, 29, 35, 46, 58, 63, 67, 89 Initially tree is empty. Values must be added in ascending order. Show the step-by-step construction.201910mDatabase Management SystemFor a B-tree of order m, every non-root internal node must have at least: (i) m/2 children (ii) [m/2] children (iii) [m/2]-1 children (iv) m-1 children20252mDatabase Management SystemConstruct the B+ tree for the following set of key values: (2, 3, 5, 7, 11, 17, 19, 23, 29, 31) Assume that tree is initially empty and values are added in ascending order. Construct B+ tree for the cases where the number of pointers that will fit in one node is as follows: (a) Four (b) Six (c) Eight202014mDATABASE MANAGEMENT SYSTEMWhich of the following is true? - (i) B+ tree allows only the rapid random access (ii) B+ tree allows only the rapid sequential access (iii) B + tree allows rapid random access as well as rapid sequential access (iv) B + tree allows rapid random access and slower sequential access20212m
PreviousWhich of the following are the five built-in functions provided by SQL? (i) COUNT, SUM, AVG, MAX, MIN (ii) SUM, AVG, MIN, MAX, MULT (iii) SUM, AVG, MULT, DIV, MIN (iv) SUM, AVG, MIN, MAX, NAMENextConsider the following action : TRANSACTION..... Commit; ROLLBACK; What does rollback do? (i) Undoes the transactions before commit (ii) Clears all transactions (iii) Redoes the transactions before commit (iv) No action