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 is the purpose of update command in oracle?

7 Answers   MBT,

What are different types of tables in sql?

0 Answers  

what is explain plan?, given an example...

3 Answers   Polaris,

How to get help at the sql prompt?

0 Answers  

What is scalar data type in pl sql?

0 Answers  

What is a dynamic query?

0 Answers  

What is sql comments?

0 Answers  

How many types of literals are available in pl sql?

0 Answers  

Can we insert data in view?

0 Answers  

What are the various restrictions imposed on view in terms of dml?

0 Answers  

What is row_number () in sql?

0 Answers  

What is an Exception ? What are types of Exception ?

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories