Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212302 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 / tom
There is two difference between them.
1. The not null constraint is by default added to primary
key, it means, primary key attribute cannot accept null
values, whereas, the attribute declared as unique can accept
null values. It is the major difference between the two.
2. Secondly, we can have only one primary key in a relation,
whereas, multiple attributes can be declared unique at the
same time.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a proxy object?
What are the different editions of oracle?
How to use "for" statements in oracle?
What is the difference between a hot backup and a cold backup in oracle?
What is a trigger oracle?
how do u setup a replication site?
What happens to the current transaction if the session is ended?
How will you identify oracle database software release?
What is a user role in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to add a new column to an existing table in oracle?
How to find the duplicate rows count from employees table in oracle?
What are the common oracle dba tasks?
What are joins, explain all types of joins?
