Difference between primary key and unique key ?
- 77 Answers
- 198860 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
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to invoke the data pump import utility?
can u plz provide me oca sql dumps please i need them
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is background process in Oracle?
How to create an oracle testing table?
What is connection pooling in oracle?
What is Reduced List of Values?
Explain the truncate in oracle?
How can we view last record added to a table?
Explain a private synonyms?
Explain the different normalization forms?
What are the different types of synonyms?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What are the various types of snapshots ?
