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
- 32261 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sanjib sarkar
Index is a set of <KEY,ADDRESS> pair. Now in the case of
Primary Index both keys and addresses of the records are
kept in order to search a particular record faster but in
the case of Secondary Index only the addresses of the
records are kept in the index not the key.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What are the types of database model?
What is the physical representation for a many-to-many relationship?
How you can make a parameterized view?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
I have a few records all are same structures data, I want to store data in multiple targets how
Explain what a database is?
How to read and create .LDC data files which are used by linguatic dictionary.
Explain about the hierarchical model of the database?
What is DB Development software?
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 are the three basic rules which are to be followed for the relational model of the database?
Which four data types cannot be used as a return type from a user-defined function?
fact table and dimension table containg one to many relationship or many to one relastionship
Who are naive users?
What are the constraints on severity level in raiseerror?
