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 are the types of database model?
Explain the rollup operator?
I have a few records all are same structures data, I want to store data in multiple targets how
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
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?
Where is dbms used?
Explain about network model?
What is dbms explain in brief?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
How is data stored in dbms?
fact table and dimension table containg one to many relationship or many to one relastionship
Write short notes on manual refreshes.
Which data type cannot be used as a parameter in a udf?
How long can an error message be in raiseerror function?
What are the 18 schemas?