B+ trees organize data for efficient searching. Leaf nodes contain the records or pointers to records, while internal nodes act as an index to direct the search.
In B+ tree index, leaf nodes store -
Asked in Analyst Cum Programmer (Deputy Director) 2024 · Topic: Basics of Computers and Information Technology (Database Management Systems (DBMS) Basics: Concepts, Types of Databases)
Show answer
Answer: C. Pointer to a file record
Read the notes: Basics of Computers and Information Technology →
More Information and Communication Technology questions
- Which of the following expression is true due to associativity?
- When a foreign key attribute is updated, what must the DBMS ensure?
- What does the recovery manager do in DBMS transaction processing?
- SELECT Name FROM Employees WHERE Department = 'IT' UNION SELECT Name FROM FormerEmployees WHERE ExitReason = 'Resigned'; In the above SQL query, which of the following statement is true about its result? - Question not attempted
- Consider the following Assertion (A) and the Reason (R) - Assertion (A) : "In object-oriented databases, persistent objects can survive after program termination and can be retrieved in future sessions". Reason (R) : Persistent objects are stored in volatile memory for faster access and cease to exist when program ends. Which of the following is correct?
- Which property ensures that a transaction is either fully executed or not performed at all? - Question not attempted
- In ER diagrams, a 'weak entity' is characterized by which of the following? - Question not attempted
- What is the primary goal of BCNF in database normalization? - Question not attempted
All 1,360 Information and Communication Technology questions →