Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210089 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
Explain oracle’s server parameter file.
Why is oracle so popular?
what is insert all statement in sql
Give the various exception types.
What are transaction isolation levels supported by oracle?
Explain an index?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
When do you get a .pll extension in oracle?
How to recover a dropped table in oracle?
What are the different types of database objects?
How to drop a stored procedure in oracle?
What is set verify off in oracle?
Explain the difference between sap and oracle?
How to build data dictionary view an new database?
Explain an integrity constrains?
