Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210701 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
IS it possible to built the oracle database without setting the kernal parameters?
What is oracle update statement with inner join ?
How to convert character types to numeric types?
How to write date and time literals in oracle?
Can group functions be mixed with non-group selection fields?
How to export your connection information to a file?
What is transaction control statement and how many types of transaction control statement in Oracle?
please explain.. DB architecture ...
Explain the use of ignore option in imp command.
What is program global area (pga) in oracle?
Why do you use stored procedures and state some of its disadvantages?
What happens if recursive calls get out of control?
What do database buffers contain?
What are the oracle differences between nvl and coalesce
What is execute immediate in oracle?
