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
- 32479 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nusret sevinc
A primary index is an index on a set of fields that includes
the unique primary
key for the field and is guaranteed not to contain
duplicates. A secondary index
is an index that is not a primary index and may have
duplicates. Two entries are
said to be duplicates if they have the same value for the
search key field associated
with the index.
| Is This Answer Correct ? | 88 Yes | 20 No |
Post New Answer View All Answers
How can you log an error to the server event log from a stored procedure?
Explain about relational database management systems?
What is database design and development?
Write short notes on manual refreshes.
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?
Explain about the relational database?
Write the fastest query to find out how many rows exist in a table?
Explain about post-relational databases?
What is an application role and explain a scenario when you would use one?
What are the three basic rules which are to be followed for the relational model of the database?
How you can make a parameterized view?
State the acid rules?
Explain about relational operator join?
Explain about a primary key?
What is the database development process?
