Difference between primary key and unique key ?
- 77 Answers
- 191167 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 / laxman k
1) Primary key can not accept null values, but unique can
accept null values.
2) only one primary key have in a table but max 249 unique
in a table
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is columnar storage what is the advantage?
candidate key is subset of super key but not vice-verse explain
List out the difference between commit, rollback, and savepoint?
How to bring a tablespace online?
What is tns entry?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is a table index in oracle?
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
does the query needs a hint to access a materialized view?
How to create a table index in oracle?
What is the best way to do multi-row insert in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to specify default values in insert statement using oracle?
What is merge in oracle?
