Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207510 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 / vaithianathan
primary key not accepts null value and
not allows duplicate values.
but Unique key not allows duplicate values
but it accepts ONLY ONE NULL VALUE.
only one primary key allowed per table
we can create multiple unique keys
on the table
By Default, Primary key creates Clustered Index and Unique key Creates Non Clustered Index
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to execute the package in oracle?
How to update values in a table in oracle?
what is dynamic SGA and static SGA
Explain the use of Merge statement in oracle 11g
How to run create database statement again?
Can objects of the same schema reside in different tablespace?
How to specify default values in insert statement using oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What privilege is needed for a user to create tables in oracle?
does the query needs a hint to access a materialized view?
What happens if recursive calls get out of control?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is the difference between $oracle_base and $oracle_home?
