Difference between primary key and unique key ?
- 77 Answers
- 197728 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 / austin johnson
we can't insert a NULL value into to coloumn holding
primary key constrain.
where as we can insert a NULL value to a unique key feild.
Remember, both keys are used to identify the
rows/tuple/entry of the table uniquely.
so, only once u can enter a NULL value into the unique key
feild.
| Is This Answer Correct ? | 146 Yes | 57 No |
Post New Answer View All Answers
Can I create users through internet explorer in oracle 10g?
What is background process in Oracle?
How do we get field details of a table?
Explain the different normalization forms?
What is an oracle database?
How to drop a tablespace?
What is a data lock in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to define a procedure inside another procedure?
What do you mean by merge in oracle?
How to turn on or off recycle bin for the session?
How to rollback the current transaction in oracle?
Explain cascading triggers.
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain the function of optimizer in oracle?
