Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207483 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 / prashant t.
First difference is that primary key doesn't accept null
values whereas unique accepts one or multiple.
second difference is that Clustered index is created on
Primary key constraint and non clustered unique indexes is
created on Unique key constraint.
| Is This Answer Correct ? | 320 Yes | 94 No |
Post New Answer View All Answers
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are advantages of dateset in datastage?
What is the difference between post-database commit and post-form commit?
What is the max number of columns in an oracle table?
List the parts of a database trigger.
Explain an index?
Explain what are clusters?
Why does for update in oracle 8 cause an ora-01002 error?
What is the Tune Query
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to count duplicated values in a column in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How can we force the database to use the user specified rollback segment?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to unlock the sample user account in oracle?
