Difference between primary key and unique key ?
- 77 Answers
- 198463 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 / vaithianathan
primary key not accepts null value and
not allows duplicate values.
but Unique key not allows duplicate values
but it accepts ONLY ONE NULL VALUE.
only one primary key allowed per table
we can create multiple unique keys
on the table
By Default, Primary key creates Clustered Index and Unique key Creates Non Clustered Index
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
interview questions with answer for cts
How do I limit the number of oracle database connections generated by weblogic server?
What are the attributes that are found in a cursor?
What are the different types of record groups in oracle? Explain each of them
What is oracle database client?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Explain the use of ignore option in imp command.
What is logical backup in oracle?
What do you mean by a tablespace?
What are the varoius components of physical database structure of oracle database?
What is system global area (sga) in oracle?
How will you write a query to get a 5th rank student from a table student_report?
What is the difference between translate and replace?
How to use subqueries with the exists operator in oracle?
How can I see all tables in oracle?
