Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207615 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
What is Library Cache in Oracle?
How many categories of data types?
What is an oracle user account?
What is the difference between a user and a schema in oracle?
definition of cluster and non-clustered index?
What are the differences between interval year to month and interval day to second?
What is tns entry?
What is partitioned table in Oracle?
Explain the use of rows option in imp command.
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is a database schema in oracle?
How to join two tables in a single query using oracle?
How to assign a table row to a record variable?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What are operators in oracle?
