Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207505 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 / susil kumar rout
When we applied primary key constraint upon a column of a table internally oracle create a cluster index.In case of unique constraint,oracle create a non-cluster index.
In a table or entity one primary key and one or more than one
unique key can be applied.
We can't insert duplicate value or null value to primary key
column where as null value can insert into unique key column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why we use bulk collect in oracle?
How do we create privileges in oracle?
Explain the use of online redo log files in oracle.
What is Segment Advisor in Oracle?
What is raw datatype?
What is index-organized table in Oracle?
Explain database link?
Is there a function to split a string in plsql?
How to create a stored procedure in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
Explain the difference between replace() and translate() functions in oracle?
Who developed oracle & when?
Difference between inner join vs where ?
What are the different types of partitions in oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
