Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210315 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 / arpit sachan
Primary key Accept only one Null Value...But a Unique key Accept one or More Null value........
create table #foo(id varchar(5)primary key,name varchar(10));
insert into #foo('','Your name');
---------->> see the result.....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the set operators union, union all, minus & intersect meant to do?
Explain oracle data types with examples?
what is the scripts in data base?
How to unlock the sample user account in oracle?
How to return top 5 rows in oracle?
What is an oracle user account?
How to create an oracle database?
How do we get field details of a table?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Explain oracle instance.
What is Data Dictionary Cache in Oracle?
Explain about your project and its relation to the current job position you are applying to?
What happens to the indexes if a table is recovered?
How can I introduce multiple conditions in like operator?
When system tablespace is created?
