Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212227 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
Explain an exception and its types?
Explain view?
How to sort output in descending order in oracle?
How a tablespace is related to data files?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is a dynamic performance view in oracle?
How to find the duplicate rows count from employees table in oracle?
How many types of tables are there in oracle?
Explain about the analyze command in oracle?
What is a named program unit?
What is primefaces used for?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to connect to a remote server?
Where are the settings stored for each instance in oracle?
What is an oracle data file?
