Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212354 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 will you write a query to get a 5th rank student from a table student_report?
What is a table index?
How to run create database statement again?
What is proxy method?
What are the oracle built-in data types?
Explain the use of compress option in exp command.
What are set operators?
In the oracle version 9.3.0.5.0, what does each number shows?
Respected sir, Please send me technical questions related to oracle apps..
What is a directory object?
Is oracle a relational database?
How to store only time; not date and time?
Which environment variables are absolutely critical in order to run the OUI?
How to import one table back from a dump file?
What is set operator oracle?
