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

what is difference between "Primary key" and "Unique key"?

Question Posted / swapna

Answers were Sorted based on User's Feedback



what is difference between "Primary key" and "Unique key"?..

Answer / swapna

1)unique key can be null but primariy key cant be null.
2)primariy key can be refrenced to other table as FK.
Primary key and unique are Entity integrity constraints
Primary key allows each row in a table to be uniquely
identified and ensures that no duplicate rows
exist and no null values are entered.
Unique key constraint is used to prevent the duplication of
key values within the rows of a table and allow null
values. (In oracle, one null is not equal to another null).

Is This Answer Correct ?    4 Yes 0 No

what is difference between "Primary key" and "Unique key"?..

Answer / satya_k21

Hi,

Primary Key: Not Null+ unique.but it wont allows null
values.

Unique: It allows null values , but it should be unique.

Regards,
Satya.k

Is This Answer Correct ?    3 Yes 0 No

what is difference between "Primary key" and "Unique key"?..

Answer / nitin gupta

Uniques: Enforce unique data in the database
it allows row containing null value but only once
It implements non clustered index.

primary key: Enforce unique data in the database
it don't allow any record containing null value
it implements clustered index (data physically
sorted)

Is This Answer Correct ?    3 Yes 0 No

what is difference between "Primary key" and "Unique key"?..

Answer / kk

PRIMARY KEY=UNIQUE KEY+ NOT NULL KEY so its a combo drive

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

Is sql a scripting language?

0 Answers  

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

What are the events on which a database trigger can be based?

0 Answers  

What is NOCOPY?

6 Answers   DELL,

What are different joins used in sql?

0 Answers  

How to rename a table?

0 Answers  

What does dml mean?

0 Answers  

What is the size of partition table?

0 Answers  

trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

1 Answers   Oracle,

How to return multiple records from procedure?

2 Answers  

What is the use of sql trace?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories