How many null values can be inserted in a coulmn whihc is unique constraint

Answer Posted / amit

Any no. of times you can insert null values in a coulmn
whihc is unique constraint because a Null value is
undefined,unassigned,and unapplicable value so thats why we
cannot compaire with any other null value or other value.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create a table index in mysql? : Sql dba

591


How do you update f as m and m as f from the below table testtable?

1065


How do you drop a trigger?

536


Can you upgrade sql express to full sql?

509


Mention what are the benefits of pl/sql packages?

532






ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2002


Can we rename a column in the output of sql query?

538


Why is stored procedure faster than query?

486


What is triggering circuit?

590


What are inbuilt functions in sql?

595


How many sql core licenses do I need?

505


How can we link a sql database to an existing android app?

546


Can I learn sql in a week?

545


Which table is left in join?

514


Explian rowid, rownum?

558