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

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 on delete set null?

561


What is sql data?

546


what are the nonstandard string types? : Sql dba

601


Can procedure in package be overloaded?

605


How do you drop a trigger?

540






What is the difference between drop and truncate commands?

484


What is union and union all keyword in sql?

565


How many row comparison operators are used while working with a subquery?

533


Does sql backup shrink transaction log?

551


Can a select statement fire a trigger?

656


What are the properties of a transaction?

559


How do I view tables in sql developer?

512


What are the types of index in sql?

531


Why triggers are used?

553


What is sql injection vulnerability?

494