Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a primary index and a
secondary index? What is a duplicate data entry in an index?
Can a primary index contain duplicates?
- 5 Answers
- 32531 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / roshan jha
The index in which the sort order of a search key is similar
to the sort order of a relation then the index is called
primary index.Ex.front index of the book.
While in secondary index the order of the search key is in
different order from the order of the key in file.eg.index
in back side of some book.
Two entries are said to be duplicate if have same
value for the search key field associated.primary index
doesnot have duplicates.
| Is This Answer Correct ? | 27 Yes | 14 No |
Post New Answer View All Answers
What is dbms and its application?
In which table collections errors are stored.
How can you fix a poorly performing query?
How can you log an error to the server event log from a stored procedure?
Explain the rollup operator?
Explain about relational operator join?
Explain about the hierarchical model of the database?
Explain the process of the user request and data generating?
Explain about query and reporting.
explain detail about ftp in datastage?
What is the physical representation for a many-to-many relationship?
Explain about post-relational databases?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are the types of database model?
