Yes,Multiple Null values are allowed in Unique key Constraint because eac

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

Question Posted / anjani kumar

Answer Posted / anjani kumar

Yes,Multiple Null values are allowed in Unique key
Constraint because each Null is different from another Null
so there is no case of duplication.

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1191

what is the functionality of the function htmlentities? : Sql dba

962

How subquery works in sql?

1068

Does varchar need length?

992

what are the join types in tsql? : Transact sql

1064

How do I view a table in sql?

1007

how to run 'mysql' commands from a batch file? : Sql dba

1120

What is a constraint?

1022

What is sqlerrd?

968

Explain the order of sql statement execution?

1045

What is difference between rank () row_number () and dense_rank () in sql?

1101

What is pl/sql table? Why it is used?

1036

What is the use of pl/sql table?

1066

What is t-sql? : Transact sql

985