Difference between primary key and unique key ?
- 77 Answers
- 198303 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 / mohan singh
Primary key contain non repetitive value and not null
value,and primary key is created on clustered index.In the
table their should be one primary key column.
Unique key contain non repetitive value but can contain
only one null value in the column.And unique key is created
on non clustered index.
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
How to update values in a table in oracle?
Explain the use of owner option in exp command.
What happens if the update subquery returns multiple rows?
Explain view?
What is program global area (pga) in oracle?
How to create a new user account in oracle?
What is the disadvantage of User defind function?
What is user managed backup in Oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Why use resource manager in Oracle?
Why do we use coalesce function in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Is oracle an operator?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is the exact use of Collections?
