Register

File indexing

242 views

1 Answer

1 votes
1 votes
Answer : C

Since the records of Database file are physically ordered based on Attribute $X$... So, The database file becomes Unordered for attribute $Y$. Hence, Now if we build Index for search key $Y$ then It will be Secondary Index (Non-clustered index) and Since, $Y$ is a candidate key... So, The index based on attribute $Y$ will be called "Secondary index on Key".
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
Suryadip asked Mar 9
100 views
File organisation and indexing (DBMS)
User Avatar
3 votes
3 votes
1 answer
2
Na462 asked Jan 26, 2019
1,883 views
Ace Test Series: DBMS - File Indexing
User Avatar
0 votes
0 votes
0 answers
3
Parimal Paritosh asked Aug 30, 2018
604 views
File Indexing
Which tree has more number of levels for 'n' nodes - B tree or B+ tree? What's the reason behind it?
Which tree has more number of levels for 'n' nodes - B tree or B+ tree? What's the reason behind it?
User Avatar
2 votes
2 votes
1 answer
4
Na462 asked Jun 29, 2018
676 views
Ace Test Series: DBMS - Indexing And File Organization
Here the indexing is done on ordered field so which to use Dense or Sparse because both can be done here ?
Here the indexing is done on ordered field so which to use Dense or Sparse because both can be done here ?
User Avatar
Link Copied!