Difference between primary key and unique key ?
- 77 Answers
- 190707 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
How can I get column names from a table in oracle?
Which environment variables are absolutely critical in order to run the OUI?
How can Oracle users be audited?
does the query needs a hint to access a materialized view?
How do I manually create a database in oracle?
What is a procedure in oracle?
What is bulk load in oracle?
what is the difference between functional dependecy and multilevel dependency?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Why is oracle used?
What happens to the current transaction if a ddl statement is executed?
Differentiate between post-database commit and post-form commit?
please explain.. DB architecture ...
what is difference between sql plus and sql*plus? (not sql and sql plus).
What are the differences between number and binary_float in oracle?
