Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207619 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 parameter file in oracle.
What is a table index in oracle?
What is the minimum client footprint required to connect c# to an oracle database?
What is system global area (sga) in oracle?
What is the difference between translate and replace?
How do you store pictures in a database?
What is user managed backup in Oracle?
What is a snapshot log?
What is oracle used for?
How can we force the database to use the user specified rollback segment?
What is the data type of dual table?
What happens to the data files if a tablespace is dropped?
How to grant create session privilege to a user in oracle?
Explain the use of Merge statement in oracle 11g
What is different types of joins?
