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
- 30737 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain about the relational database?
What are the three types of database design?
Explain about query and reporting.
In which table collections errors are stored.
explain detail about ftp in datastage?
Can an extended stored procedure be called from inside a user-defined function?
fact table and dimension table containg one to many relationship or many to one relastionship
Which data type cannot be used as a parameter in a udf?
How can you fix a poorly performing query?
Who are naive users?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
How long can an error message be in raiseerror function?
What is normalization? Explain different levels of normalization?
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?
How to customize error conditions.
