374 views
1 votes
1 votes

1. Why in question They treat both clustered and primary indices Different, because both are the same thing(written in Korth).

Only the thing is Primary indices means search key is Primary Key and Clustered means it can be any search Key and both defines the same order as the order of database records right ?

Like in this Question :https://gateoverflow.in/414/gate2008-16-isro2016-60      the answer should be both A and C right ?

 

2. Can we have One Clustered and one unclustered indices on different set of attributes for the Records ? I know the records are only physically ordered in one way But Say i took Primary key which is in order with file and created a clustered index and i took another attribute not in the order say Salary and created a different Secondary index on the Records ?

Please log in or register to answer this question.

Related questions

0 votes
0 votes
1 answer
1
samarpita asked Nov 14, 2021
257 views
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...
2 votes
2 votes
2 answers
2
aditi19 asked Nov 23, 2018
1,600 views
what is the minimum and maximum number of keys for non-leaf nodes and leaf nodes for B+ Tree of order p?
2 votes
2 votes
2 answers
4
Arnabi asked Oct 25, 2017
633 views