Difference between primary key and unique key ?
- 77 Answers
- 190714 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
How to assign values to variables?
What are the restrictions on external table columns?
How many types of tables are there in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to store pictures on to the database?
How to loop through data rows in the implicit cursor?
What is a tns service name?
Explain cascading triggers.
What are the different types of modules in oracle forms?
Why is oracle so popular?
What are the execution control statements in oracle?
How can Oracle users be audited?
How to use an explicit cursor without open statements?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is catalog in Oracle?
