Difference between primary key and unique key ?
- 77 Answers
- 190720 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 / ela tiku
1. Primary key does not allow Nill value whereas Unique key
allows Null values.
2. There can more than one Unique key for a table however
there is only one primary key for ant tanle.
2. Whenever a primary key is assigned by default a
Clustered Index is created whereas When a Unique key is
created a Non Index clustered index is created...
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What are the most common interview questions on ETL Testing for experience?
List the types of joins used in writing subqueries?
Where are the settings stored for each instance in oracle?
How to apply filtering criteria at group level in oracle?
What is a lookup table in oracle?
What happens to the current transaction if the session is ended?
Explain the difference between sap and oracle?
What is the oracle implicit cursor?
What is the scope of a local variable?
what's query optimization and without use of IN AND Exist can we get another way data from query
How many data types are supported?
What is the use of aggregate functions in oracle?
What is recovery manager(rman) backup in Oracle?
What is bulk collect in oracle?
What is ASM (Automatic Storage Management) in Oracle?
