Register

File indexing

172 views

1 Answer

0 votes
0 votes

Answer : A

When Index is build over a Ordered Key field then  it is called Primary Index. Which is the case here.

When Index is build over a Ordered Non-Key field then  it is called Clustered Index. 

When Index is build over a Unordered Key field then  it is called Secondary  Index over key. 

When Index is build over a Unordered Non-Key field then  it is called Secondary  Index over non-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,884 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!