Difference between primary key and unique key ?
- 77 Answers
- 190699 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 operating systems are supported by oracle database 10g xe?
Explain about functional dependency and its relation with table design?
What happens if the imported table already exists?
List out the types of joins.
Briefly explain what is literal? Give an example where it can be used?
How to work with data objects interactively?
How to export data with a field delimiter?
What are the attributes that are found in a cursor?
What is an oracle?
Can you have more than one content canvas view attached with a window ?
How to drop an existing table in oracle?
What is clustered table in Oracle?
How to convert raw data type into text in oracle? Explain
What is oracle open database communication (odbc)?
Write a syntax for update query in oracle?
