Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210443 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 / pralhad
Each table having only one PRIMARY KEY.And my contain many
UNIQUE KEYS.
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
BOTH keys will not contain repeated value.
BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.
| Is This Answer Correct ? | 63 Yes | 47 No |
Post New Answer View All Answers
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is oracle latest version?
How to define an anonymous block?
How to build data dictionary view an new database?
How to get execution path reports on query statements?
How to define an external table with a text file?
What is format trigger?
Explain index?
What is program global area (pga) in oracle?
Explain oracle 12c new features for developers?
How to execute the package in oracle?
what is the use of system.effective.date variable in oracle?
How do you store pictures in a database?
How can we find out the duplicate values in an oracle table?
Explain an exception and its types?
