Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210068 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 / ankit kumar singh
Primary Key:
* Primary Key can not contain null value
* Clustured index is created in Primary key.
* Primary Key allows Each row in a table to uniquely
identified and insures that no applicable row exists.
Unique Key:
* Unique Key can contain null value.
* More than one Unique key in a table can be declared.
* Non-clustered index is created in unique key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is bind variable in oracle 11g?
Explain integrity constraints?
What are the different types of partitions in oracle?
What is oracle server autotrace in oracle?
What are the common oracle dba tasks?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What happens if you lost a data file?
What is meant by an index?
Explain the function of optimizer in oracle?
Explain the use of log option in exp command.
How to shutdown your 10g xe server from command line?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Explain drop constraint oracle?
what are bitmap indexes? How does they work?
Name the various constraints used in oracle?
