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
indexing
Arnabi
asked
in
Databases
Oct 28, 2017
763
views
3
votes
3
votes
indexing
databases
Arnabi
asked
in
Databases
Oct 28, 2017
by
Arnabi
763
views
answer
comment
Follow
share this
share
2 Comments
by
akash.dinkar12
commented
Oct 28, 2017
reply
Follow
share this
whether the first entry of the page is sorted or not???
0
0
by
Arnabi
commented
Oct 28, 2017
reply
Follow
share this
nothing is said about whether its sorted or unsorted. pls explain with a diagram.
0
0
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
0
votes
0
votes
is it 2?
arch
answered
Oct 29, 2017
by
arch
comment
Follow
share this
4 Comments
Show 7 previous comments
by
utk0203
commented
Oct 29, 2017
reply
Follow
share this
Isn't is ceil(500) i.e 3 pages to be loked up?
0
0
by
Arnabi
commented
Oct 29, 2017
reply
Follow
share this
@arch thanks :)
So, index block contains name of first entry of each page and page no. Thus 1 page access for the index itself + 1 page for the particular entry we wanted to search. Total page to look up =2.
0
0
by
arch
commented
Oct 29, 2017
reply
Follow
share this
no question asked only for no. of page access thats y record access is ignored.
0
0
Please
log in
or
register
to add a comment.
← Previous
Next →
← Previous in category
Next in category →
Related questions
0
votes
0
votes
0
answers
1
Suryadip
asked
in
Databases
Mar 9
70
views
File organisation and indexing (DBMS)
Suryadip
asked
in
Databases
Mar 9
by
Suryadip
70
views
databases
indexing
file-system
3
votes
3
votes
2
answers
2
srestha
asked
in
Databases
May 17, 2019
1,447
views
Made Easy Test Series:Database-Indexing
The minimum number of nodes (both leaf and non-leaf) of $B^{+}$ tree index required for storing $5500$ keys and order of $B^{+}$ tree is $8$________________(order is max pointers a node can have) See here first level should be divide by $7$ ... pointer of 1st level has $8$ pointer in 2nd level. Am I missing something?? But in ans they divided by only $8$ :(
srestha
asked
in
Databases
May 17, 2019
by
srestha
1.4k
views
databases
made-easy-test-series
indexing
2
votes
2
votes
1
answer
3
srestha
asked
in
Databases
May 13, 2019
1,740
views
Made Easy Test Series:Databases-Indexing
Consider the following statement below: $A)$ A clustered index may be either sparse or dense. $B)$ Every $B^{+}$ tree index is dense. Which of the above statement is true? Is clustering Index can be dense. Dense means non-ordering field, but clustering field should be ordering field right??
srestha
asked
in
Databases
May 13, 2019
by
srestha
1.7k
views
databases
indexing
made-easy-test-series
3
votes
3
votes
1
answer
4
Na462
asked
in
Databases
Jan 26, 2019
1,905
views
Ace Test Series: DBMS - File Indexing
Na462
asked
in
Databases
Jan 26, 2019
by
Na462
1.9k
views
indexing
databases
ace-test-series
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