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 sql profiler in oracle?

568


When are we going to use truncate and delete?

555


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

623


when is the use of update_statistics command? : Sql dba

504


What is the difference between subquery and correlated query?

530






Where the sql database files are stored?

495


What is data manipulation language?

702


Explain select statements in sql?

591


Explain table and field in sql?

585


what are the different tables present in mysql? : Sql dba

506


Does db2 use sql?

513


What is a subquery in sql?

511


What is difference between sql and excel?

517


Can pl sql procedure have a return statement?

552


How delete all data from all tables in sql?

540