Difference between primary key and unique key ?
- 77 Answers
- 198286 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
How to end the current transaction in oracle?
Why we use bulk collect in oracle?
What is save point in oracle database?
What is an oracle user role?
Which is better Oracle or MS SQL? Why?
How to define an anonymous procedure without variables?
What is a database table in oracle?
State and explain the different types of data models?
Explain the use of rows option in exp command.
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to create a stored procedure in oracle?
Explain cascading triggers.
How to use values from other tables in update statements using oracle?
How to use an explicit cursor without open statements?
Explain what are the advantages of views?
