Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210342 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 / lucky
Primary key not accepts to null values in database, but
uniqe key accepts to the null values in database.
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between count (*), count (expression), count (distinct expression)?
What are the differences between blob and clob in oracle?
What is connection pooling in oracle?
How to check the oracle tns settings?
How to change user password in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
how to clone 9i Database on to 10g Database.
How to insert a new row into a table in oracle?
How to create a new view in oracle?
What is a snapshot log?
What are the uses of synonyms?
Explain overloading. Can functions be overloaded?
What is a database schema in oracle?
What is tns entry?
How do we represent comments in oracle?
