Difference between primary key and unique key ?

Answer Posted / ibrahim

PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
PRIMARY KEY not accepts null values but unique can accept null.

but the core different between primary key and unique is we use primary key to link tow tables with each other but we can not use unique key to do this.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1214


What is the relation of a user account and a schema?

893


What is the difference between a hot backup and a cold backup in oracle?

790


How to retrieve data from an cursor to a record?

783


What is a cursor variable?

821


What is the implicit cursor in oracle?

833


How to connect to oracle using service name instead of sid?

806


How to experiment a data lock in oracle?

821


How many anonymous blocks can be defined?

834


How oracle handles dead locks?

832


What is a sub query and what are the different types of subqueries?

894


How to define a sub function?

896


Is oracle the best database?

740


What are the four Oracle system processes that must always be up and running for the database to be useable?

792


What are the differences between primary key and unique key?

758