Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210332 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
please explain.. DB architecture ...
Name the various constraints used in oracle?
How to lock and unlock a user account in oracle?
How to list all tables in your schema?
Explain the function of optimizer in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Is there an oracle sql query that aggregates multiple rows into one row?
What is the difference between sharding and replication?
How to select all columns of all rows from a table in oracle?
What is procedure overloading in oracle?
What happens in oracle commit?
How can Oracle users be audited?
Please explain drop constraint oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to use existing values in update statements using oracle?
