Functional-Dependency
October 3, 2023Database-Management-System
October 3, 2023Database-Management-System
Question 90 |
Which one of the following is a key factor for preferring B+– trees to binary search trees for indexing database relations?
Database relations have a large number of records | |
Database relations are sorted on the primary key | |
B+– trees require less memory than binary search trees
| |
Data transfer from disks is in blocks |
Question 90 Explanation:
B+ trees is a balanced tree and it can store multiple keys in each node of B+ tree.
Thus, the data can be transferred through blocks in B+ trees. This can be used for indexing the database relations.
Thus, the data can be transferred through blocks in B+ trees. This can be used for indexing the database relations.
Correct Answer: D
Question 90 Explanation:
B+ trees is a balanced tree and it can store multiple keys in each node of B+ tree.
Thus, the data can be transferred through blocks in B+ trees. This can be used for indexing the database relations.
Thus, the data can be transferred through blocks in B+ trees. This can be used for indexing the database relations.
Subscribe
Login
0 Comments