Difference between primary key and unique key ?
- 77 Answers
- 190700 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 save point in oracle database?
What is the data pump export utility?
Use of an integrity constraint is better to validate data. Explain
What are the restrictions on external table columns?
Is oracle a language?
How to fetch the row which has the max value for a column?
How to compare dates in oracle sql?
How to upsert (update or insert into a table)?
How to create a new oracle data file?
what are bitmap indexes? How does they work?
What is a partition in oracle?
What are the execution control statements in oracle?
What is data type in oracle?
Explain the use of grant option in imp command.
Explain view?
