Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210018 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 / yjreddy
primary key doesnt allow duplicates and null values
unique key allows null value only once
and more over
when you applying primary key by default clustered index is created on that table
when u applying unique key non clustered index is created on that table.
so primary key can be allowed only once(1) and unique u can apply more
than one on a single table(249)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is pragma autonomous transaction in oracle?
How do we get field detail of a table?
How to define a variable to match a table column data type?
What types of joins are used in writing subqueries?
What is the difference between truncate & delete command?
What happens if the imported table already exists?
what is the difference between data migration and production migration.
What is an oracle user role?
How to estimate disk space needed for an export job?
What is raw datatype?
Explain the use of log option in exp command.
How data locks are respected in oracle?
How to rename a tablespace in oracle?
What is an oracle data file?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
