Difference between primary key and unique key ?
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
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What do you mean by merge in oracle?
How to see the table columns used in an index?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is an oracle user account?
Which environment variables are absolutely critical in order to run the OUI?
What is execute immediate in oracle?
What is clustered table in Oracle?
What is the use of file param in imp command?
How to get a list of all user accounts in the database?
What is Redo Log Buffer in Oracle?
How to resolve the ORA-39133 error in Oracle?
How can you merge two tables in oracle?
What is data block in Oracle?
How to create a stored program unit?