Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

define primary key & secondary key?

Question Posted / mreddy

Answers were Sorted based on User's Feedback



define primary key & secondary key? ..

Answer / manoj

primary key is a key which always accept unique value.

secondary key is a key which when you are making primary key
for more than one column as primary key for retrieving of
reords.
eg.
create table tnam
(ano number,
bno number,
bname char(12),
primary key(ano,bno))

In this bno is secondary key.

Is This Answer Correct ?    31 Yes 18 No

define primary key & secondary key? ..

Answer / renu kakkar

PRIMARY REPRESENTS THE ROW/TUPPLE UNIQUELY WHEREAS
SECONDARY KEY REPRESENTS THE SET OF TUPPLES
EMPLOY_ID IS A PRIMARY KEY AND EMPLOY_DEPTT. IS A SECONDARY
KEY.

Is This Answer Correct ?    3 Yes 9 No

Post New Answer

More SQL PLSQL Interview Questions

What are analytic functions in sql?

0 Answers  

Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,

What is extent clause in table space?

1 Answers   TCS,

What is clustered index in sql?

0 Answers  

What are % type and % rowtype?

0 Answers  

What is delimiter sql?

0 Answers  

What does bitemporal mean?

0 Answers  

What is the current version of postgresql?

0 Answers  

What is the primary key?

0 Answers  

What is sql data?

0 Answers  

Can a procedure in a package be overloaded?

0 Answers   EXL,

What is sql used for?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories