Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210441 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 oracle in java?
How do I connect to oracle database?
Does oracle partitioning improve performance?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to create a table index in oracle?
How to call a sub procedure?
How to use like conditions in oracle?
Name the three major set of files on disk that compose a database in Oracle?
What are the most common interview questions on ETL Testing for experience?
What happens if you use a wrong connect identifier?
Why does for update in oracle 8 cause an ora-01002 error?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to create lov dynamically at runtime & attach to text field?
What are the set operators union, union all, minus & intersect meant to do?
How to convert character types to numeric types?
