Difference between primary key and unique key ?
Answer Posted / priyranjan das
The basic differences between Primary Key and Unique key are as follows.
1) By default Primary Key will generate Clustured Index
whereas Unique Key will Generate Non-Clustured Index.
2) Primary Key is a combination of Unique and NOT NULL Constraints so it can’t
have duplicate values or any NUll
Whereas for Oracle UNIQUE Key can have any number of NULL whereas for SQL
Server It can have only one NULL
3) A table can have only one PK but It can have any number of UNIQUE Key.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
6. Display the client name and order date for all orders using the traditional method.
how may join possible between (requisition with purchase order)
What happens in oracle commit?
What is oracle in java?
How to view the data files in the current database?
How to put more than 1000 values into an oracle in clause?
Explain the difference between a procedure and a function?
What are named parameters?
20. Using a set operator, display the client number of all clients who have never placed an order.
What would you do with an in-doubt distributed transaction?
How to define and use table alias names in oracle?
Where is the export dump file located?
What are the varoius components of physical database structure of oracle database?
What is hash cluster in oracle?
What is blob data type in oracle?