PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2021 paper

Unit 3: Storage and Transaction Processing

20212m

Which 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 access
Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (iii) B+ tree allows rapid random access as well as rapid sequential access

Explanation: B+ tree is variant of B-tree where all records stored in leaf nodes linked as linked list. Provides rapid random access via tree traversal (log N) and rapid sequential access via leaf chain. B tree allows random but sequential requires inorder traversal slower. B+ is preferred for indexes and range queries.

Similar questions

Database 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) Eight202014mMICROPROCESSORSWhich of the following statement is true for the instruction PUSH B? (i) It is an arithmetic instruction (ii) Executes in single machine cycle (iii) It reads from memory location (iv) It performs memory write operation20232mOperating SystemWhich of the following is a potential result of bad blocks on a disk? (i) Faster access time (ii) Increased storage capacity (iii) Data loss or corruption (iv) Improved disk scheduling20242mDatabase Management SystemA B-tree of order 4 and of height 3 will have a maximum of ____ keys. (i) 255 (ii) 63 (iii) 127 (iv) 18820202m
PreviousWhich of the following is the original purpose of SQL? - (i) To specify the syntax and semantics of SQL data definition language (ii) To specify the syntax and semantics of SQL manipulation language (ii) To define the data structures (iv) All of the aboveNextTransaction processing is associated with everything below, except - (i) conforming an action or triggering a response (ii) producing detailed summary or exception report (iii) recording a business activity (iv) maintaining a data
Official AppAndroid App

PYQDeck for Android

Solve BEU previous-year exam papers anywhere, anytime. Fast search, offline paper viewing, and step-by-step solutions designed specifically for your phone.

Get on Google Play