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
How to customize error conditions.
What are the three types of database design?
How to generate OIDS
How is data stored in dbms?
How to use online Backups?
How to use timestamp datatypes
Explain the role of indexing in databases?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
What is normalization? Explain different levels of normalization?
What are data modelling techniques?
Which data type cannot be used as a parameter in a udf?
How to combine two function together?
Which four data types cannot be used as a return type from a user-defined function?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS