Difference between primary key and unique key ?
- 77 Answers
- 197800 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
Write a trigger example in oracle?
What is the quickest way to export a table to a flat file?
Explain the use of indexes option in imp command.
How can windows applications connect to oracle servers?
How to start your 10g xe server?
What do you understand by a database object?
What are the different types of trigger and explain its various uses and functions?
What are set operators?
How do I limit the number of oracle database connections generated by weblogic server?
How to use an explicit cursor without open statements?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How do I uninstall oracle 11g?
What are the differences between number and binary_float in oracle?
Describe an oracle table?
