define primary key & secondary key?

Answers were Sorted based on User's Feedback



define primary key & secondary key?..

Answer / anil kumar

Primary key is a field or combination of fields that can uniquely and minimally identifies a particular member of an entry.

A secondary key is a field or combination of fields that can be used to access or retrieve records.Secondary key values are not unique.

Is This Answer Correct ?    15 Yes 3 No

define primary key & secondary key?..

Answer / chandrashekar

Secondary indices or secondary databases are used to access
a primary database by a key other than the primary key.
Recall that the Supplier Number field is the primary key of
the Supplier database. In this section, the Supplier City
field will be used as a secondary lookup key. Given a city
value, we would like to be able to find the Suppliers in
that city. Note that more than one Supplier may be in the
same city.

Both primary and secondary databases contain key-value
records. The key of an index record is the secondary key,
and its value is the key of the associated record in the
primary database. When lookups by secondary key are
performed, the associated record in the primary database is
transparently retrieved by its primary key and returned to
the caller.

Thaking You

Is This Answer Correct ?    17 Yes 39 No

Post New Answer

More Automation Testing AllOther Interview Questions

Explain how to perform load-testing?

0 Answers  


Describe common problems of test automation.

0 Answers  


How do you plan test automation?

1 Answers  


When is automation testing useful?

0 Answers  


What are the pre-requisites to start automation testing?

0 Answers  






How to explain testing life cycle where exactly testing starts after coding stage or after preparing FRS document

5 Answers  


What are the advantages of automation testing?

0 Answers  


hi, I want to study TIA portla V11. where can I get online courses?

0 Answers  


Does automation testing have any disadvantages?

0 Answers  


What are the main attributes of test automation?

0 Answers  


what is the difference or comparison between QTP and rational? and which tool is better to use?

1 Answers  


I was asked these questions during a job interview question. I totally stumbled on # 1 and for # 2 even though I answered but not a very convincing way. I would appreciate a concise and well phrased asnwers: 1) During SDLC, when would you be asked to take it "offline" 2) Throughout SDLC process, where would you implement test automation and why?

0 Answers  


Categories