Difference between primary key and unique key ?
Answer Posted / rinu
1)unique key can be null but primariy key cant be null.
2)primariy key can be refrenced to other table as FK.
3)we can have multiple unique key in a table but PK is one
and only one.
4)PK in itself is unique key.
5)a table can have more then one unique key column but a
table can have only one primary key column.
6)primary key creates clustered index but unique key
creates non clustered index.
Is This Answer Correct ? | 12 Yes | 7 No |
Post New Answer View All Answers
Name the three major set of files on disk that compose a database in Oracle?
How to create an oracle database?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How do we represent comments in oracle?
How to use select statement to count the number of rows in oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What is merge in oracle?
What is a snapshot log?
Is oracle the best database?
How many types of tables are there in oracle?
What is the difference between substr & instr functions?
Difference between cartesian join and cross join?
Which is faster join or subquery in oracle?
How do we get field details of a table?
What happens if you set the sga too low in oracle?