Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212270 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 / hemendra singh chaudhary
In the Table a primary key constraint column cannot holding
the null values.whereas unique constraint colum can holding
the null values.
Ex.|--------------------|
| ID(P) | Name(U) | #ID(P) ->It's a Primary Key
|--------------------| * Its a Not Null
| 1 | Hemendra | * A table Contain 1 Primary
| 2 | Neeraj | Key.
| 3 | PremJe | #Name(U)->It's a Unique Key
|NotNull |canbe Null| * Its can contain Null Value
|--------------------| * A table Contain more
than 1 unique Key.
Please Check the Radio Button..........
******************Gud Luck********************
| Is This Answer Correct ? | 45 Yes | 0 No |
Post New Answer View All Answers
Explain an exception and its types?
Explain do view contain data?
Can we save images in a database and if yes, how?
What are the ansi data types supported in oracle?
What are named parameters?
How will you identify oracle database software release?
Oracle
How to drop an index?
What is the difference between I and G in Oracle?
How to call a stored function in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How do you tell what your machine name is and what is its IP address?
How to define an explicit cursor in oracle?
What is MTTR advisor in Oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
