define primary key & secondary key?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell us what is junit? And what is junit annotation?

521


Discuss the economics of automation and the role of metrics in testing.

2032


IS DATA INTEGRITY TESTING AND INTEGRATION TESTING ONE AND THE SAME?IF DIFF CAN U SPECIFY THE DIFFERENCES

1588


Tell me what databases can test director reside on?

458


Do you think that testing can be done only at the ui level?

609






Tell us the difference between assert and verify commands?

559


How could the web element attributes be inspected in order to use them in different locators?

530


Does every software project need testers?

545


How the object properties will be recognised by the tool If the functions/ statements are written manually?

1743


On what factors can you map the success of automation testing?

549


What is in-house tool?

551


What is test automation?

1663


Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(

1769


Give some examples of priority – severity defect levels.

528


What all different approaches can be used for designing an automation solution?

485