Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210101 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 / deen dayal sharma
1. PRIMARY KEY & UNIQUE KEY both uniquely identity of each
row in a table.
2. BOTH keys will not contain repeated value.
3. One table may have more than one Unique Key Constraint But
it should have only one Primary Key Constraint column.
4. BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to check database size in Oracle?
What is a user account in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is merge in oracle?
Where do you use decode and case statements?
What privilege is needed for a user to insert rows to tables in another schema?
What is the quickest way to export a table to a flat file?
Point out the difference between user tables and data dictionary?
What are the attributes of cursor?
How to see free space of each tablespace?
How to grant create session privilege to a user in oracle?
what are steps for interface? where is exchange rate defined in which table?
What is a data lock in oracle?
What is backup in Oracle?
What are transaction isolation levels supported by oracle?
