Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Test by Bikram | Databases | Test 1 | Question: 24
Bikram
asked
in
Databases
Nov 26, 2016
407
views
0
votes
0
votes
Let the search key field of a B+ tree is 4 Bytes , the disk block size is 199 Bytes , and the index pointer is 3 Bytes, then the order of B+ tree is _______
tbb-dbms-1
numerical-answers
Bikram
asked
in
Databases
Nov 26, 2016
by
Bikram
407
views
answer
comment
Follow
share this
share
0 Comments
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
1
vote
1
vote
Best answer
n*3 + (n-1)4 <=199 , n<=29 , so order is 29
Bikram
answered
Nov 26, 2016
selected
Jan 13, 2017
by
Bikram
by
Bikram
comment
Follow
share this
4 Comments
Show 2 previous comments
by
Vaishali Trivedi
commented
Jan 13, 2017
reply
Follow
share this
sorry sir , it was typo i am saying it must be less than 29 every node need to sum additional information
am i not correct?
0
0
by
Bikram
commented
Jan 14, 2017
reply
Follow
share this
it is a B + tree so read B+ tree property once.
and see my given answer.
0
0
by
Jason_Roy
commented
Feb 8, 2017
reply
Follow
share this
index pointer is tree pointer or node pointer. right?
1
1
Please
log in
or
register
to add a comment.
Answer:
29
← Previous
Next →
← Previous in category
Next in category →
Related questions
1
vote
1
vote
2
answers
1
Bikram
asked
in
Databases
Nov 26, 2016
901
views
Test by Bikram | Databases | Test 1 | Question: 14
Let there is a Table named Stud_records with $3000$ records of fixed length, each record size is $50$ Bytes and records are stored in a block of size $512$ Bytes, If secondary index is built on the key field of size $10$ Bytes and a block pointer of size $5$ Bytes , then the number of first level index blocks are ______
Bikram
asked
in
Databases
Nov 26, 2016
by
Bikram
901
views
tbb-dbms-1
numerical-answers
0
votes
0
votes
1
answer
2
Bikram
asked
in
Databases
Nov 26, 2016
727
views
Test by Bikram | Databases | Test 1 | Question: 4
Each dealer owns one or more cars and each car is owned by at-most one dealer. If Dealer table has $20$ tuples and Cars table has $60$ tuples then owns table can have maximum _____ number of tuples
Bikram
asked
in
Databases
Nov 26, 2016
by
Bikram
727
views
tbb-dbms-1
numerical-answers
1
vote
1
vote
1
answer
3
Bikram
asked
in
Databases
Nov 26, 2016
324
views
Test by Bikram | Databases | Test 1 | Question: 30
Consider the join of relation R with a relation S. If R has $m$ tuples and S has $n$ tuples, then the maximum and minimum sizes of the join, respectively, are __________. $m+n$ and $0$ $m+n$ and $|m-n|$ $mn$ and $0$ $mn$ and $m+n$
Bikram
asked
in
Databases
Nov 26, 2016
by
Bikram
324
views
tbb-dbms-1
0
votes
0
votes
1
answer
4
Bikram
asked
in
Databases
Nov 26, 2016
237
views
Test by Bikram | Databases | Test 1 | Question: 29
A functional dependency of the form x → y is trivial if y ⊆ x y ⊂ x x ⊆ y x ⊂ y
Bikram
asked
in
Databases
Nov 26, 2016
by
Bikram
237
views
tbb-dbms-1
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy