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

Answer Posted / ravin

Yes we can..
Hey guys.. don't be confused with the values and nulls.
Unique key conforms only the values to be unique. Since the
nulls are not any kind of value, they can occur as many
times as they can.. nulls are nothing..

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an escape character in sql?

745


What are the types of index in sql?

777


Explain mutating table error.

841


What is on delete set null?

767


Can triggers stop a dml statement from executing on a table?

806






What is difference between joins and union?

748


Is not null in sql?

732


how to enter characters as hex numbers? : Sql dba

749


What do you know by pl/sql cursors?

759


Explain dml and ddl?

740


What is serial sql?

701


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2764


What is t-sql? : Transact sql

712


Can I learn sql in a week?

756


What is sql catalog?

766