Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210069 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 / anand b
Primary Key : Is an identity of a row, Only one primary key per table, No duplicate values allowed, & No NULL values are allowed.
Unique Key : Its values are unique, It can contain any number of NULL values unless combination is going to be unique.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain self joins in oracle?
In oracle there is column command, how will you explain that?
is there a tool to trace queries, like profiler for sql server?
How to write date and time literals in oracle?
What is proxy method?
How many anonymous blocks can be defined?
What is a data dictionary and how can it be created?
What is the disadvantage of User defind function?
Point the difference between translate and replace?
Write a syntax for update query in oracle?
How to write numeric literals in oracle?
How to rename a column in an existing table?
How to use "if" statements on multiple conditions?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Can we use bind variables in oracle stored procedure?
