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

Is automation testing a complete replacement for manual software testing?

0 Answers  


1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?

0 Answers   TCS,


In general, how do you see automation fitting into the overall process of testing?

0 Answers  


what is are the difference between qtp and selenium ?

1 Answers  


Describe some problem that you had with automating testing tool.

0 Answers  






Tell me what type of scenarios can be automated?

0 Answers  


Can object repository be kept in version control and Database(DB) backed up daily ?

1 Answers   Amazon,


How will you choose a tool for test automation?

0 Answers  


can you ple give me Quality Center interview questions and answer

5 Answers  


What is fastest locating Strategy?

1 Answers   HCL,


If I have given names to different DataTable columns and those column names are stored in a variable, then passing that variable to the datatable how can i Enter different values in those columns listed in that variable?? Please explain me with an example.I am not getting it.

0 Answers  


What are the main benefits of test automation?

2 Answers  


Categories