Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 208736 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 / sripathi venkata ramesh
I am Sripathi Venkata Ramesh from Gudivada and the answer
is mentioned below
Primary key: A Primary key is a column or group of columns
used to uniquely identify each row in a table like
It defines the column as a Mandatory column.
The data held across the column must be unique.
By default it creates clustered index.
It does not allow null values and duplicate values
Unique key: It also for the record uniqueness.
It allows only one null value
By default it creates non clustered index
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the types of trigger in oracle?
What privilege is needed for a user to create indexes in oracle?
Can you have more than one content canvas view attached with a window ?
Differentiate between post-database commit and post-form commit?
What are a cluster and non-cluster index?
What are the numeric comparison operations?
How to execute a stored procedure in oracle?
What is a connect identifier?
What is a dead lock in oracle?
Explain the difference between sql and oracle?
Where is the export dump file located?
What is the maximum number of triggers that can be applied to a single table?
Is insert autocommit in oracle?
Give the various exception types.
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
