Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207466 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
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
How to create lov dynamically at runtime & attach to text field?
What do you mean by a tablespace?
What are the types of partitions in oracle?
What is oracle sid?
How to check the server version in oracle?
What are the types of trigger in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to create a table index in oracle?
How much memory your 10g xe server is using?
Give the different types of rollback segments.
What is coalesce function?
How to turn on or off recycle bin for the session?
When do you get a .pll extension in oracle?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How to delete a column in an existing table?
