Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged b-tree
0
votes
1
answer
91
MadeEasy Test Series: Databases - B Tree
" B+ tree index has more levels than B tree index for large number of keys. " How the above statement is true ??
" B+ tree index has more levels than B tree index for large number of keys. "How the above statement is true ??
ashish pal
513
views
ashish pal
asked
Dec 26, 2017
Databases
made-easy-test-series
databases
b-tree
+
–
0
votes
1
answer
92
B+ Trees
Going with the definition, that order of a B+ tree is the maximum number of children a node can have. What is exactly meant by the order of a leaf node? As per my understanding order of a leaf node is the number of <key,pr> pairs it can hold. But in ... the upper limit on keys should be 5 and not 4. Could someone explain why its taken to be n-1 in every B+ tree insertion tutorial.
Going with the definition, that order of a B+ tree is the maximum number of children a node can have.What is exactly meant by the order of a leaf node? As per my understa...
Shiwam1994
1.3k
views
Shiwam1994
asked
Dec 19, 2017
Databases
databases
b-tree
+
–
1
votes
1
answer
93
B tree
In B+ tree of order p,each leaf node should have (A) atmost $\left \lceil \frac{p}{2} \right \rceil$ values (B) atleast $\left \lceil \frac{p}{2} \right \rceil$ values (C) atmost $\left \lfloor \frac{p}{2} \right \rfloor$ values (D) atleast $\left \lfloor \frac{p}{2} \right \rfloor$ values
In B+ tree of order p,each leaf node should have(A) atmost $\left \lceil \frac{p}{2} \right \rceil$ values(B) atleast $\left \lceil \frac{p}{2} \right \rceil$ values(C) a...
srestha
511
views
srestha
asked
Dec 16, 2017
Databases
databases
b-tree
+
–
0
votes
1
answer
94
B+ Tree Question
Does values in Leaf nodes of B+ tree repeats or ever leaf node has an unique value?
Does values in Leaf nodes of B+ tree repeats or ever leaf node has an unique value?
iarnav
1.4k
views
iarnav
asked
Dec 15, 2017
Databases
b-tree
bplustrees
databases
indexing
tree
+
–
0
votes
0
answers
95
#dbms b+tree
can anyone please explain the standard/universal procedure on how to perform deletion in b+ tree with the help of an example.
can anyone please explain the standard/universal procedure on how to perform deletion in b+ tree with the help of an example.
iarnav
195
views
iarnav
asked
Dec 15, 2017
Databases
databases
b-tree
bplustrees
+
–
0
votes
0
answers
96
#dbms b+tree
can anyone please explain the standard/universal procedure on how to perform insertion in b+ tree with the help of an example.
can anyone please explain the standard/universal procedure on how to perform insertion in b+ tree with the help of an example.
iarnav
300
views
iarnav
asked
Dec 15, 2017
Databases
databases
b-tree
bplustrees
+
–
0
votes
0
answers
97
madeeasy booklet
while(1) { flag[i]=true; while(flag[j]); <cs> flag[i]=false; } someone please tell bounded wait is satisfying or not???
while(1) {flag[i]=true;while(flag[j]);<cs>flag[i]=false;}someone please tell bounded wait is satisfying or not???
aaru14
340
views
aaru14
asked
Dec 12, 2017
Operating System
operating-system
b-tree
+
–
2
votes
1
answer
98
MadeEasy Test Series: Databases - B Tree
Suppose size of disk block 1000 Bytes and search key of 12 Bytes, pointer size 8 bytes. How many minimum number of records in data file which leads 3 level dense B+ tree index? (Assume minimum node fill factor ceil(P/2) pointers where p is the maximum pointer per node).
Suppose size of disk block 1000 Bytes and search key of 12 Bytes, pointer size 8 bytes. How many minimum number of records in data file which leads 3 level dense B+ tree ...
Upasana singh
2.0k
views
Upasana singh
asked
Dec 11, 2017
Databases
made-easy-test-series
databases
b-tree
+
–
0
votes
1
answer
99
Doubt in gate 2009 B+-tree question
https://gateoverflow.in/1330/gate2009-44 Can anybody provide me the diagrams of the insertion operations. In both the cases, left biasing and right biasing. Do we split every time a node is full? Even when its siblings have space? Thank You.
https://gateoverflow.in/1330/gate2009-44Can anybody provide me the diagrams of the insertion operations. In both the cases, left biasing and right biasing.Do we split eve...
Rishabh Gupta 2
1.1k
views
Rishabh Gupta 2
asked
Dec 9, 2017
Databases
databases
b-tree
+
–
0
votes
0
answers
100
B TREE
Abhijeet_Kumar
435
views
Abhijeet_Kumar
asked
Dec 8, 2017
Databases
databases
b-tree
+
–
0
votes
0
answers
101
B+ trees
Given a B+ tree, How can we find out their sequence of insertion?
Given a B+ tree, How can we find out their sequence of insertion?
Pawan Kumar 2
345
views
Pawan Kumar 2
asked
Dec 7, 2017
Databases
b-tree
databases
+
–
1
votes
1
answer
102
B+ tree
$\text{Insertion Sequence}$ : $8,5,1,7,3,12,9,6$ Can someone plz show the Sequence of insertion in B+ tree step by step Thanks
$\text{Insertion Sequence}$ : $8,5,1,7,3,12,9,6$Can someone plz show the Sequence of insertion in B+ tree step by step Thanks
Pawan Kumar 2
1.0k
views
Pawan Kumar 2
asked
Dec 7, 2017
Databases
b-tree
tree
bplustrees
+
–
0
votes
0
answers
103
MadeEasy Test Series: Databases - B Tree
Suppose size of block 1000 bytes search key of 12 bytes, pointer size 8 bytes. How many maximum records in DB file which can index by dense B+ tree of 2 levels? given ans is 2499 but I am getting 2450
Suppose size of block 1000 bytes search key of 12 bytes, pointer size 8 bytes. How many maximum records in DB file which can index by dense B+ tree of 2 levels?given ans ...
sunaina rawat
416
views
sunaina rawat
asked
Dec 4, 2017
Databases
made-easy-test-series
databases
b-tree
+
–
1
votes
3
answers
104
MadeEasy Test Series: Databases - B Tree
Which of the following statement true about B tree and B+ tree index? Assume order of B tree node same as order of B+ tree node. B tree index has more levels than B+ tree index for large number of keys. B+ tree index has more levels than B ... records. B+ tree index nodes more than B tree for large number of keys I think a is correct but the given ans is b
Which of the following statement true about B tree and B+ tree index? Assume order of B tree node same as order of B+ tree node.B tree index has more levels than B+ tree ...
shivangi5
1.8k
views
shivangi5
asked
Dec 4, 2017
Databases
made-easy-test-series
databases
b-tree
+
–
1
votes
1
answer
105
B+ tree
Assume a system has following parameters to construct a B+ tree. The specification of the tree are: • Size of search key is 15 B • Size of block is 512 B • Size of record pointer is 9 B • Size of block pointer is 8 B The maximum number of keys that can be accommodated in each non-leaf node of the tree is ________.
Assume a system has following parameters to construct a B+ tree. The specification of the tree are:• Size of search key is 15 B• Size of block is 512 B• Size of rec...
Tuhin Dutta
786
views
Tuhin Dutta
asked
Nov 30, 2017
Databases
databases
b-tree
tree
+
–
2
votes
2
answers
106
B Trees
Which of the following statement true about B tree and B+ tree index? Assume order of B tree node same as order of B+ tree node. B tree index has more levels than B+ tree index for large number of keys. B+ tree index has more levels than B tree index for ... keys. Both B tree B+ tree best for sequential access of records. B+ tree index nodes more than B+ tree for large number of keys.
Which of the following statement true about B tree and B+ tree index? Assume order of B tree node same as order of B+ tree node.B tree index has more levels than B+ tree ...
sunaina rawat
2.1k
views
sunaina rawat
asked
Nov 24, 2017
Databases
databases
b-tree
+
–
0
votes
0
answers
107
nptel
Consider a B-tree with the following specifications: Page size c = 2 kB; Size of key γ = 32 bytes; Size of pointer η = 8 bytes. What is the order m of the B+-tree? How many records can a tree of height 3 store? doubt: x->pointer to block 8*x +(8+32)*(x-1)<=2048 x<=43.5 but given solution is 2*1024>=32*m+8(m+1)+8*m=42.2=42 please guide where i am wrong
Consider a B-tree with the following specifications: Page size c = 2 kB; Size of key γ = 32 bytes; Size of pointer η = 8 bytes. What is the order m of the B+-tree? How ...
Learner_jai
578
views
Learner_jai
asked
Nov 23, 2017
Databases
b-tree
+
–
0
votes
0
answers
108
self doubt dbms
Deletion in B+ tree, unable to get the underflow condition when we deal with http://home.iitj.ac.in/~ramana/ch10-st How grouping is done during underflow in B+, IN B we see the most populous sibling and do grouping and merge it.
Deletion in B+ tree, unable to get the underflow condition when we deal with http://home.iitj.ac.in/~ramana/ch10-stHow grouping is done during underflow in B+, IN B we se...
Learner_jai
300
views
Learner_jai
asked
Nov 23, 2017
Databases
b-tree
+
–
0
votes
1
answer
109
data base 2
nikkey123
478
views
nikkey123
asked
Nov 22, 2017
Databases
databases
b-tree
indexing
+
–
0
votes
1
answer
110
data base 1
nikkey123
287
views
nikkey123
asked
Nov 22, 2017
Databases
databases
b-tree
indexing
+
–
0
votes
1
answer
111
B-tree
please check this
please check this
Anjan
411
views
Anjan
asked
Nov 21, 2017
Databases
databases
b-tree
+
–
0
votes
1
answer
112
virtual gate
Given key values 8,9,5,12,15,16,18,1,2 and using left biasing, which of the following btree is correct with order 3.
Given key values 8,9,5,12,15,16,18,1,2 and using left biasing, which of the following btree is correct with order 3.
Manoja Rajalakshmi A
474
views
Manoja Rajalakshmi A
asked
Nov 17, 2017
DS
b-tree
left-biasing
+
–
0
votes
1
answer
113
B tree
A B tree has order 10. Suppose it's leaf node already has 9 elements and one more element is inserted in it and split occurs. Now my question is is it always necessary that the split is of size 4 and 5 ie left child contain 4 values and right child node contain 5 values? Or it could also be 5 and 4? Thanks.
A B tree has order 10. Suppose it's leaf node already has 9 elements and one more element is inserted in it and split occurs. Now my question is is it always necessary th...
Mahendra Singh Kanya
611
views
Mahendra Singh Kanya
asked
Nov 6, 2017
Databases
databases
b-tree
+
–
3
votes
2
answers
114
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
+
–
1
votes
1
answer
115
B-Tree
What is the maximum number of nodes and keys in a B-tree of order 10 of depth 3 (root at depth 0) ?
What is the maximum number of nodes and keys in a B-tree of order 10 of depth 3 (root at depth 0) ?
rishu_darkshadow
2.0k
views
rishu_darkshadow
asked
Sep 25, 2017
DS
b-tree
data-structures
+
–
1
votes
1
answer
116
Test by Bikram | Databases | Test 2 | Question: 20
Assume that a B-Tree is used as an index for a large database table which has six levels (including the root node). If a new key is inserted into this index, then the maximum number of levels possible in the updated tree is ______.
Assume that a B-Tree is used as an index for a large database table which has six levels (including the root node). If a new key is inserted into this index, then the max...
Bikram
421
views
Bikram
asked
Aug 26, 2017
Databases
tbb-dbms-2
numerical-answers
databases
b-tree
+
–
1
votes
1
answer
117
Test by Bikram | Databases | Test 2 | Question: 9
In a B-Tree, the block size is $512$ Bytes, search key is $4$ Bytes, block pointer size is $8$ Bytes and record pointer size is $8$ Bytes. Every node contains $n-1$ record pointers, $n-1$ search keys and n block pointers (where ... of search keys that can be accommodated in level $0$ of the above B-tree (where root is at level $0$) is _________.
In a B-Tree, the block size is $512$ Bytes, search key is $4$ Bytes, block pointer size is $8$ Bytes and record pointer size is $8$ Bytes. Every node contains $n-1$ recor...
Bikram
388
views
Bikram
asked
Aug 26, 2017
Databases
tbb-dbms-2
numerical-answers
databases
b-tree
+
–
1
votes
2
answers
118
Ace Test Series: Databases - B Tree
When would you want to use a B-tree instead of B+ Tree? 1. When sequential access to key values is never required. 2. When sequential access to key values is required. 3. When both Direct and sequential access is required. 4. When Direct access is required without sequential access.
When would you want to use a B-tree instead of B+ Tree?1. When sequential access to key values is never required.2. When sequential access to key values is required.3. Wh...
Arnab Bhadra
2.9k
views
Arnab Bhadra
asked
May 30, 2017
Databases
ace-test-series
databases
b-tree
+
–
2
votes
1
answer
119
databases
In the given B-Tree below , insert an index record with key 40 ? (order of b-tree is 4) ANSWER : PLEASE VERIFY ...
In the given B-Tree below , insert an index record with key 40 ? (order of b-tree is 4)ANSWER :PLEASE VERIFY ...
vignesh
730
views
vignesh
asked
May 8, 2017
Databases
databases
indexing
b-tree
+
–
2
votes
2
answers
120
databases
what is the difference between a "Block" and "Sector" in Hard disk ..??? Are they both same ???
what is the difference between a "Block" and "Sector" in Hard disk ..??? Are they both same ???
vignesh
380
views
vignesh
asked
Apr 23, 2017
Databases
databases
b-tree
co-and-architecture
operating-system
+
–
Page:
« prev
1
2
3
4
5
6
7
8
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register