Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207506 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 / sandhya
Primary Key cannot contain null values
Each table has one and only one Primary Key
Primary Key is used to reference as Foreign key while
performing table joins
Clustered index is created on Primary Key
Unique Key can contain null value
A table can have any numberof unique keys
Non-clustered index is created on unique key columns
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
List the types of joins used in writing subqueries?
How to turn on or off recycle bin for the session?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to get a create statement for an existing table?
What is format trigger?
How to open and close an explicit cursor in oracle?
What are data pump export and import modes?
How to select some columns from a table in oracle?
How to use windows user to connect to the server?
What is using clause and give example?
What is recovery manager in Oracle?
What is the relation of a user account and a schema?
How to use like conditions in oracle?
What is meant by raw datatype?
How to execute a stored program unit?
