menu
Login
Register
search
Log In
account_circle
Log In
Email or Username
Password
Remember
Log In
Register
I forgot my password
Register
Username
Email
Password
Register
add
Activity
Questions
Unanswered
Tags
Subjects
Users
Ask
Prev
Blogs
New Blog
Exams
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
How to read operating systems concept by galvin?
Update on GO Book for GATE 2022
Barc Interview Experience 2020- CSE stream
JEST 2021 registrations are open
TIFR GS-2021 Online Application portal
Subjects
All categories
General Aptitude
(2.1k)
Engineering Mathematics
(8.5k)
Digital Logic
(3k)
Programming and DS
(5.2k)
Algorithms
(4.5k)
Theory of Computation
(6.3k)
Compiler Design
(2.2k)
Operating System
(4.7k)
Databases
(4.3k)
CO and Architecture
(3.5k)
Computer Networks
(4.3k)
Non GATE
(1.2k)
Others
(1.3k)
Admissions
(595)
Exam Queries
(838)
Tier 1 Placement Questions
(16)
Job Queries
(71)
Projects
(19)
Unknown Category
(1.1k)
Recent Blog Comments
My advice, for now just read the gate syllabus...
Mock 3 will be added soon.
What are the expected dates for release of Mock 3...
Thank You So Much...
Ohh, yeah now turned off. Got it sir, Thank you :)
Network Sites
GO Mechanical
GO Electrical
GO Electronics
GO Civil
CSE Doubts
DBMS Korth Edition 4 Exercise 12 Question 3 (Page No. 489)
0
votes
73
views
What is the difference between a primary index and a secondary index ?
korth
databases
indexing
descriptive
asked
Apr 1, 2019
in
Databases
akash.dinkar12
73
views
answer
comment
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
0
votes
In primary index data is ordered whereas in secondary index data is unordered
answered
Apr 26, 2020
Abhi11jeet
comment
Please
log in
or
register
to add a comment.
← Prev.
Next →
← Prev. Qn. in Sub.
Next Qn. in Sub. →
Related questions
1
vote
4
answers
1
334
views
DBMS Korth Edition 4 Exercise 12 Question 4 (Page No. 489)
Is it possible in general to have two primary indices on the same relation for different search keys ? Explain your answer.
Is it possible in general to have two primary indices on the same relation for different search keys ? Explain your answer.
asked
Apr 1, 2019
in
Databases
akash.dinkar12
334
views
korth
databases
indexing
descriptive
0
votes
0
answers
2
88
views
DBMS Korth Edition 4 Exercise 12 Question 2 (Page No. 489)
Since indices speed query processing, why might they not be kept on several search keys ? List as many reasons as possible.
Since indices speed query processing, why might they not be kept on several search keys ? List as many reasons as possible.
asked
Apr 1, 2019
in
Databases
akash.dinkar12
88
views
korth
databases
indexing
descriptive
0
votes
0
answers
3
78
views
DBMS Korth Edition 4 Exercise 12 Question 1 (Page No. 489)
When is it preferable to use a dense index rather than a sparse index ? Explain your answer.
When is it preferable to use a dense index rather than a sparse index ? Explain your answer.
asked
Apr 1, 2019
in
Databases
akash.dinkar12
78
views
korth
databases
indexing
descriptive
1
vote
0
answers
4
209
views
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 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
asked
Apr 1, 2019
in
Databases
akash.dinkar12
209
views
korth
databases
indexing
b-tree
descriptive
...