Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210104 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 / chetan sharma
Primary key creates Clustered Index.
Unique key creates non-clustered Index.
the no of primary key in a table is one but the no of
unique is more then one
there is only one primary key for one table;
it can not acept null values;
any no uniquefor a table;
it can accept null values;
which the rows are unique value;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I learn what codesets are available in oracle?
How to sort output in descending order in oracle?
How do I manually uninstall oracle client?
What is a nvl function?
How to convert numbers to characters in oracle?
What is object data modeling?
How to generate query output in html format?
Which are the five query types available in oracle?
Is oracle a language?
How to get execution statistics reports on query statements?
Explain the use of ignore option in imp command.
What are the ansi data types supported in oracle?
How many types of database triggers exist?
How to increment dates by 1 in oracle?
What is an oracle user account?
