Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 66473 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / millerdq
The argument that no two nulls are equal does not prove
anything because it's also true that no two nulls are
different.
if null <> null ..... is false
So, one could also claim that a unique key requires that
all values are unique, given that two nulls are not unique,
it is therefore not allowed.
The fact is, ansi standard says multiple nulls are
permitted in a unique key. However, not all dbms's are
compliant. Oracle permits it; SQL Server does not.
So, best answer...it depends on the dbms
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is trigger explain it?
Name the different types of indexes in sql and define them.
What are all different types of collation sensitivity?
What is a subquery in sql?
what is datawarehouse? : Sql dba
What is a join query?
What is difference between mysql and postgresql?
What is sqlcommand?
What is numeric function sql?
How can we make an if statement within a select statement?
What are pl sql data types?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
Which join is like an inner join?
How do you respond to dementia behavior?
