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?
Answer Posted / dinesh uikey
The primary index is on the field which specifies the
sequential order
of the file. There can be only one primary index while there
can be many
secondary indices.
| Is This Answer Correct ? | 12 Yes | 19 No |
Post New Answer View All Answers
What is the maximum length of an extended property?
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 the process of the user request and data generating?
Why does this query return 0?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
Explain about the storage and physical database design?
Who are end users in dbms?
How to replace not in with not exist?
How to use timestamp datatypes
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
What are data modelling techniques?
Write short notes on manual refreshes.
Explain about a primary key?
How to combine two function together?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?