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
- 31611 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 are the constraints on severity level in raiseerror?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What is data modeling with example?
How to generate OIDS
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
What are the types of database model?
Where is dbms used?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is DB Development software?
Write the fastest query to find out how many rows exist in a table?
Explain the rollup operator?
I have a few records all are same structures data, I want to store data in multiple targets how
Explain the process of the user request and data generating?
How to use online Backups?
