Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210076 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
What is different types of joins?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is not equal to in oracle?
How to build data dictionary view an new database?
How many types of table in Oracle?
What is a select query statement in oracle?
What is a proxy object?
What is control file used for?
What is oracle sid?
What is define in oracle?
What is a cognitive schema?
Explain the use of file option in exp command.
What happens to indexes if you drop a table?
What is the difference between sharding and partitioning?
How to call a stored function with parameters?
