Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 209907 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 a segment?
What is the difference between translate and replace?
What privilege is needed for a user to query tables in another schema?
What is oracle rowcount?
How to do a full database export?
What language does oracle use?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to drop an index?
Explain table?
What is the implicit cursor in oracle?
Are truncate and delete commands same? If so why?
How many data types are supported?
What are a cluster and non-cluster index?
Is oracle a language?
What are the various oracle database objects?
