We can insert any number of null values in the column which contains the

Can we use more than one null value for unique key?

Question Posted / anil kumar abbireddy

31 Answers
65234 Views
A1 Technology, Wipro, I also Faced
E-Mail Answers

Answer Posted / anil kumar abbireddy

We can insert any number of null values in the column which
contains the unique key
the reason is NULL is not equal to anothere NUll
so each null is different so there is no question of
duplication

Is This Answer Correct ?

140 Yes

30 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is secondary key?

927

Is nosql faster than sql?

1011

What is the difference between inner join and outer join?

985

What is a composite primary key?

1083

what is the command line end user interface - mysql? : Sql dba

976

Is left join same as inner join?

1111

What is the purpose of a secondary key?

956

What is output spooling in sql*plus?

1023

What is a .db file?

979

what is a constraint? : Sql dba

1143

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3037

What is sql clause?

1042

explain mysql aggregate functions. : Sql dba

980

What is the default isolation level in sql server? : Transact sql

1017

What is substitution variable in pl sql?

1038