Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Search results for b-tree
0
votes
0
answers
41
Unacademy AIMT -1
the answer is 28
the answer is 28
TusharKumar
637
views
TusharKumar
asked
Dec 23, 2022
Databases
databases
b-tree
unacademy-test-series
+
–
40
votes
5
answers
42
GATE CSE 2016 Set 2 | Question: 21
B+ Trees are considered BALANCED because. The lengths of the paths from the root to all leaf nodes are all equal. The lengths of the paths from the root to all leaf nodes differ from each other by at most $1$. The number of children of any two non-leaf sibling nodes differ by at most $1$. The number of records in any two leaf nodes differ by at most $1$.
B+ Trees are considered BALANCED because.The lengths of the paths from the root to all leaf nodes are all equal.The lengths of the paths from the root to all leaf nodes d...
Akash Kanase
11.7k
views
Akash Kanase
asked
Feb 12, 2016
Databases
gatecse-2016-set2
databases
b-tree
normal
+
–
0
votes
1
answer
43
do we have B trees in gate 2023 syllabus?
Sai eswar
659
views
Sai eswar
asked
Oct 24, 2022
Unknown Category
b-tree
syllabus
+
–
31
votes
5
answers
44
GATE CSE 2017 Set 2 | Question: 49
In a B+ Tree , if the search-key value is $8$ bytes long , the block size is $512$ bytes and the pointer size is $2\;\text{B}$ , then the maximum order of the B+ Tree is ____
In a B+ Tree , if the search-key value is $8$ bytes long , the block size is $512$ bytes and the pointer size is $2\;\text{B}$ , then the maximum order of the B+ Tree is ...
Madhav
11.0k
views
Madhav
asked
Feb 14, 2017
Databases
gatecse-2017-set2
databases
b-tree
numerical-answers
normal
+
–
1
votes
1
answer
45
Igate2022 Test Series
consider a ABC university and the relation took(StudentID, CourseNo, Quarter, Year, Units, Grade) contains the grades for the courses completed by ABC students during the last 20 years. For simplicity, assume that there are 25,000 students enrolled each quarter, and ... the B+ use, in the worst case. (n denotes the maximum number of pointers in a node.) Ans 3 Please explain
consider a ABC university and the relation took(StudentID, CourseNo, Quarter, Year, Units, Grade) contains the grades for the courses completed by ABC students during the...
SKMAKM
506
views
SKMAKM
asked
Sep 19, 2022
Databases
indexing
b-tree
test-series
+
–
33
votes
4
answers
46
GATE CSE 1989 | Question: 12a
The below figure shows a $B^+$ tree where only key values are indicated in the records. Each block can hold upto three records. A record with a key value $34$ is inserted into the $B^+$ tree. Obtain the modified $B^+$ tree after insertion.
The below figure shows a $B^+$ tree where only key values are indicated in the records. Each block can hold upto three records. A record with a key value $34$ is inserted...
makhdoom ghaya
8.4k
views
makhdoom ghaya
asked
Dec 9, 2016
Databases
descriptive
gate1989
databases
b-tree
+
–
45
votes
4
answers
47
GATE CSE 2000 | Question: 1.22, UGCNET-June2012-II: 11
B$^{+}$-trees are preferred to binary trees in databases because Disk capacities are greater than memory capacities Disk access is much slower than memory access Disk data transfer rates are much less than memory data transfer rates Disks are more reliable than memory
B$^{+}$-trees are preferred to binary trees in databases becauseDisk capacities are greater than memory capacitiesDisk access is much slower than memory accessDisk data t...
Kathleen
15.6k
views
Kathleen
asked
Sep 14, 2014
Databases
gatecse-2000
databases
b-tree
normal
ugcnetcse-june2012-paper2
+
–
44
votes
3
answers
48
GATE CSE 2015 Set 2 | Question: 6
With reference to the B+ tree index of order $1$ shown below, the minimum number of nodes (including the Root node) that must be fetched in order to satisfy the following query. "Get all records with a search key greater than or equal to $7$ and less than $15$ " is ______.
With reference to the B+ tree index of order $1$ shown below, the minimum number of nodes (including the Root node) that must be fetched in order to satisfy the following...
go_editor
13.4k
views
go_editor
asked
Feb 12, 2015
Databases
gatecse-2015-set2
databases
b-tree
normal
numerical-answers
+
–
50
votes
6
answers
49
GATE CSE 2008 | Question: 41
A B-tree of order $4$ is built from scratch by $10$ successive insertions. What is the maximum number of node splitting operations that may take place? $3$ $4$ $5$ $6$
A B-tree of order $4$ is built from scratch by $10$ successive insertions. What is the maximum number of node splitting operations that may take place?$3$$4$$5$$6$
Kathleen
21.9k
views
Kathleen
asked
Sep 12, 2014
Databases
gatecse-2008
databases
b-tree
normal
+
–
2
votes
1
answer
50
Applied Mock Test
The smallest number of keys that will force a B-Tree of order 3 to have a height of 3 are _______ Consider that the root node is at height 0.
The smallest number of keys that will force a B-Tree of order 3 to have a height of 3 are _______Consider that the root node is at height 0.
LRU
833
views
LRU
asked
Dec 22, 2021
Databases
test-series
databases
b-tree
+
–
1
votes
1
answer
51
Ace BITS&BYTES, #Trees #B-Tree
What is the smallest and largest number of entries for 2_3 BTree (B2_3 Tree) of height 8 (i.e 8 levels) ? 255 & 6560 127 & 2186 6561 & 255 255 & 2186
What is the smallest and largest number of entries for 2_3 BTree (B2_3 Tree) of height 8 (i.e 8 levels) ? 255 & 6560127 & 21866561 & 255255 & 2186
casberg
532
views
casberg
asked
Nov 23, 2021
DS
data-structures
b-tree
tree
ace-booklet
+
–
47
votes
5
answers
52
GATE IT 2007 | Question: 85
Consider the $B^{+}$ tree in the adjoining figure, where each node has at most two keys and three links. Keys $K15$ and then $K25$ are inserted into this tree in that order. Now the key $K50$ is deleted from the $B^+$ tree resulting after the two ... (i) and (ii) are true Statements (ii) and (iii) are true Statements (iii) and (i) are true All the statements are false
Consider the $B^{+}$ tree in the adjoining figure, where each node has at most two keys and three links.Keys $K15$ and then $K25$ are inserted into this tree in that orde...
Ishrat Jahan
18.8k
views
Ishrat Jahan
asked
Oct 30, 2014
Databases
gateit-2007
databases
b-tree
normal
+
–
0
votes
1
answer
53
MadeEasy Subject Test 2019: Databases - B Tree
By default take ROOT at level 1 or 0? and if asked for B tree then take all the levels but for B+ records only at leaf so only leaf level keys right?
By default take ROOT at level 1 or 0?and if asked for B tree then take all the levels but for B+ records only at leaf so only leaf level keys right?
Markzuck
488
views
Markzuck
asked
Dec 18, 2018
Databases
made-easy-test-series
databases
b-tree
+
–
1
votes
2
answers
54
DBMS basic test1
Shivani gaikawad
425
views
Shivani gaikawad
asked
Oct 27, 2018
Databases
databases
b-tree
tree
+
–
3
votes
1
answer
55
B+ Trees
Can anybody explain what is meant by "Minimum Space Utilization"?
Can anybody explain what is meant by "Minimum Space Utilization"?
vishal chugh
383
views
vishal chugh
asked
Jan 16, 2018
Databases
databases
b-tree
+
–
1
votes
3
answers
56
UGC NET CSE | January 2017 | Part 3 | Question: 12
If following sequence of keys are inserted in a B+ tree with K(=3) pointers: 8, 5, 1, 7, 3, 12, 9, 6 Which of the following shall be correct B+ tree?
If following sequence of keys are inserted in a B+ tree with K(=3) pointers:8, 5, 1, 7, 3, 12, 9, 6Which of the following shall be correct B+ tree?
go_editor
8.7k
views
go_editor
asked
Jan 31, 2017
Databases
ugcnetcse-jan2017-paper3
databases
b-tree
+
–
3
votes
2
answers
57
B+ tree maximum number of records.
What is the maximum number of records that can be indexed in B+ tree of level $4$ ,order $10$ where root is at level $1$ ? As the order of tree is $10$, nodes in the last level of b+ tree should contain $10$ record pointers (number of ... $10-1 = 9$ record pointers. Which one is correct?
What is the maximum number of records that can be indexed in B+ tree of level $4$ ,order $10$ where root is at level $1$ ?As the order of tree is $10$, nodes in the last ...
Xylene
4.8k
views
Xylene
asked
Oct 12, 2017
Databases
b-tree
databases
+
–
2
votes
1
answer
58
DBMS Korth Edition 4 Exercise 12 Question 5 (Page No. 490)
Construct a $B^+$-tree for the following set of key values: $(2, 3, 5, 7, 11, 17, 19, 23, 29, 31)$ Assume that the tree is initially empty and values are added in ascending order. Construct B+-trees for the cases where the number of pointers that will fit in one node is as follows: a. Four b. Six c. Eight
Construct a $B^+$-tree for the following set of key values:$(2, 3, 5, 7, 11, 17, 19, 23, 29, 31)$Assume that the tree is initially empty and values are added in ascending...
akash.dinkar12
1.5k
views
akash.dinkar12
asked
Apr 1, 2019
Databases
korth
databases
indexing
b-tree
descriptive
+
–
0
votes
3
answers
59
Self doubt
Consider a B+ tree in which the maximum number of keys in a Internal node is 5 and maximum number of keys in a leaf node is 4. What is the minimum number of keys in any non-root node?
Consider a B+ tree in which the maximum number of keys in a Internal node is 5 and maximum number of keys in a leaf node is 4. What is the minimum number of keys in any n...
jatin khachane 1
934
views
jatin khachane 1
asked
Oct 30, 2018
Databases
databases
b-tree
+
–
5
votes
3
answers
60
ISRO2018-49
in a file which contains $1$ million records and the order of the tree is $100$, then what is the maximum number of nodes to be accessed if $B$+ tree index is used? $5$ $4$ $3$ $10$
in a file which contains $1$ million records and the order of the tree is $100$, then what is the maximum number of nodes to be accessed if $B$+ tree index is used?$5$$4$...
Arjun
10.2k
views
Arjun
asked
Apr 22, 2018
Databases
isro2018
databases
b-tree
+
–
Page:
« prev
1
2
3
4
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register