Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 208333 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
material view and view disadvantages?
Explain an exception and its types?
master table and child table performances and comparisons in Oracle ?
How to open and close an explicit cursor in oracle?
What are the different types of database objects?
What is an oracle transaction?
What is the difference between substr & instr functions?
What is oracle latest version?
What is using clause and give example?
Can select statements be used on views in oracle?
What are the major difference between truncate and delete?
What does sharding mean?
What privilege is needed for a user to create indexes in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
What is a oracle database?
