The index in which the sort order of a search key is similar to the sort o

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?

Question Posted / roshan jha

5 Answers
32316 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / roshan jha

The index in which the sort order of a search key is similar
to the sort order of a relation then the index is called
primary index.Ex.front index of the book.
While in secondary index the order of the search key is in
different order from the order of the key in file.eg.index
in back side of some book.
Two entries are said to be duplicate if have same
value for the search key field associated.primary index
doesnot have duplicates.

Is This Answer Correct ?

27 Yes

14 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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?

907

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?

2364

Explain about network model?

954

What are the types of database model?

1030

What is the maximum length of an extended property?

932

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2165

Explain the process of the user request and data generating?

1046

Explain about the storage and physical database design?

871

How to use timestamp datatypes

1976

What is the database development process?

1161

How would you design a database for an online site, which would average a million hits a day?

953

Who are end users in dbms?

920

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3959

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

2093

How can I detect whether a given connection is blocked?

992