Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212371 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
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Can we use bind variables in oracle stored procedure?
What is a dead lock in oracle?
What is archive log in Oracle?
How to create a testing table in oracle?
How to write a left outer join with the where clause in oracle?
What happens in oracle commit?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Difference between oracle's plus (+) notation and ansi join notation?
Does oracle charge for java?
Explain what are the advantages of views?
How a database is related to tablespaces?
How to define an anonymous block?
Are truncate and delete commands same? If so why?
How do I spool in oracle?
