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
- 32266 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
Explain about a primary key?
How you can make a parameterized view?
How to combine two function together?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Explain about the database management systems.
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.
What are data modelling techniques?
fact table and dimension table containg one to many relationship or many to one relastionship
How can you fix a poorly performing query?
How long can an error message be in raiseerror function?
How to use online Backups?
What is an application role and explain a scenario when you would use one?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What is a database development?
How to generate OIDS
