Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207429 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 clustered table in Oracle?
How to execute a stored program unit?
what are bitmap indexes? How does they work?
How to create a single index for multiple columns?
How to write a query with a right outer join in oracle?
How can we delete duplicate rows in a table?
How to rebuild an index in oracle?
How to rename a column in an existing table?
How do I start tns listener?
What is not equal to in oracle?
How can we find out the duplicate values in an oracle table?
How to update values in a table in oracle?
What is varray?
What happens to the data files if a tablespace is dropped?
What are the different oracle database objects?
