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
65418 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

Define tables and fields in a database

1131

What is microsoft t sql?

949

What do you mean by query optimization?

1002

What are operators available in sql?

1048

how to include character strings in sql statements? : Sql dba

1072

what is not null constraint? : Sql dba

1030

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

981

how to select unique records from a table? : Sql dba

1113

Which join is default?

954

explain the options of myisamchk to improve the performance of a table. : Sql dba

1010

What is meant by <> in sql?

978

Can function return multiple values in sql?

1060

What is package in pl sql with an examples?

1036

Are dml statements autocommit?

1045

What is an oracle stored procedure?

1053