Difference between primary key and unique key ?
Answer Posted / mudigouda patil
PRIMARY KEY
1)TABLE CAN NOT HAVE MORE THAN ONE PRIMARY KEY.
2)PK DOES NOT ALLOW NULL VALUES.
UNIQUE KEY
1)TABLES CAN HAVE MORE THAN ONE UNIQUE KEY.
2)UNIQUE KEY ALLOWS NULL VALUES.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do I manually create a database in oracle?
Explain what does a control file contain?
What is an oracle transaction?
How to revoke create session privilege from a user in oracle?
What do you mean by a tablespace?
What is the difference between formal parameters and actual parameters?
What are the ansi data types supported in oracle?
What are the differences between number and binary_float in oracle?
What is recycle bin in Oracle?
Is primary key indexed by default in oracle?
What is a cursor and what are the steps need to be taken?
What suggestions do you have to reduce the network traffic?
How to start a new transaction in oracle?
What is a user role in oracle?
What are the logical operations?