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
Slides
Recent questions tagged indexing
0
votes
0
answers
1
File organisation and indexing (DBMS)
Suryadip
asked
in
Databases
Mar 10
by
Suryadip
46
views
databases
indexing
file-system
3
votes
0
answers
2
GO Classes Test Series 2024 | Mock GATE | Test 12 | Question: 24
Assume that a data file has an index consisting of $\text{N}$ items, where $\text{N}$ is large. If a binary search of the index is used to find an item, then, of the following, which best approximates the mean number of comparisons required to locate a ... $\left(\log _2 \text{N}\right)-1$ $\text{N} \log _2 \text{N}$
GO Classes
asked
in
Databases
Jan 21
by
GO Classes
647
views
goclasses2024-mockgate-12
goclasses
databases
indexing
1-mark
1
vote
1
answer
3
Made Easy
Amy and Bob are working on a project vehicle rental system, they have a file consisting of 10000 records, having block size 1024 bytes, record size 100 bytes. Search key size 9 bytes, pointer 7 bytes. They want to implement single level indexing. ... dense index, however Amy suggested to implement sparse index. How many blocks are saved by Amy considering only 1st level index ________?
suvasish114
asked
in
Databases
Dec 10, 2023
by
suvasish114
406
views
indexing
databases
file-system
made-easy-test-series
0
votes
1
answer
4
data base
Construct the B+ tree for the following set of key values : {2,3,5,7,11,17,19,23,29,31}. Assume that tree is initially empty and values are added in ascending order. Construct B+ tree for the cases where the number of pointers that will fit in one node is as follows: (a) Four (b) Six (c) Eight
gateexplore
asked
in
Databases
Jun 30, 2023
by
gateexplore
547
views
databases
indexing
bplustrees
self-doubt
13
votes
2
answers
5
GATE CSE 2023 | Question: 52
Consider a database of fixed-length records, stored as an ordered file. The database has $25,000$ records, with each record being $100$ bytes, of which the primary key occupies $15$ bytes. The data file is block-aligned in that each data ... required to identify the block in the data file that may contain a record with the key, in the worst case, is _____________.
admin
asked
in
Databases
Feb 15, 2023
by
admin
11.4k
views
gatecse-2023
databases
file-system
indexing
numerical-answers
2-marks
0
votes
1
answer
6
Indexing in database(Self Doubt)
Can anyone explain in detail about the concepts of sencondary indexing in dbms??
vishnu777
asked
in
Databases
Nov 8, 2022
by
vishnu777
382
views
indexing
self-doubt
1
vote
1
answer
7
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
SKMAKM
asked
in
Databases
Sep 19, 2022
by
SKMAKM
478
views
indexing
b-tree
test-series
0
votes
0
answers
8
Best Open Video Playlist for Indexing (e.g., B and B+ trees) Topic | Databases
Please list out the best free available video playlist for Indexing (e.g., B and B+ trees) from Databases as an answer here (only one playlist per answer). We'll then select the best playlist and add to GO ... but standard ones are more likely to be selected as best. For the full list of selected videos please see here
makhdoom ghaya
asked
in
Study Resources
Aug 20, 2022
by
makhdoom ghaya
257
views
go-classroom
missing-videos
free-videos
video-links
indexing
0
votes
0
answers
9
AKTU university
Show the result of inserting the keys 9,24,19,13 in order into the following B-tree with minimum degree t=3.
CSE111
asked
in
Databases
Dec 7, 2021
by
CSE111
249
views
databases
indexing
0
votes
1
answer
10
#self doubt
Hash indexing and Hash file organization are there in gate syllabus??? I also wanted to know what are the topics are there in file organization and indexes….as I don’t find much question from file organization in gate questions...then please provide the video link???
samarpita
asked
in
Databases
Nov 14, 2021
by
samarpita
253
views
databases
file-organization
indexing
20
votes
1
answer
11
GATE CSE 2021 Set 2 | Question: 21
A data file consisting of $1,50,000$ student-records is stored on a hard disk with block size of $4096$ bytes. The data file is sorted on the primary key $\textrm{RollNo}$. The size of a record pointer for this disk is $7$ bytes. ... that the records of data file and index file are not split across disk blocks. The number of blocks in the index file is ________
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
9.0k
views
gatecse-2021-set2
numerical-answers
databases
indexing
1-mark
Page:
1
2
3
4
5
6
next »
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
(24)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(682)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
243k
comments
79.6k
users
Recent questions tagged indexing
Recent Blog Comments
Hlo I'm Rupesh I got AIR 3485 in gate CS and AIR...
@Ajay Sasank here is the direct link...
Thank you for the post didi My GATE 2023 & 2024...
I Hope it helps 😊
Today's best post I seen thank you for motivation