Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 64144 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 the use of & in pl sql?
What is the use of count (*) in sql?
Is left join inner or outer by default?
How to handle bulk data?
What is 19 null in sql?
Explain the types of joins in sql?
Why stored procedures are faster than query?
Is sql similar to python?
What is sql injection vulnerability?
What is a recursive stored procedure?
Why do we use triggers?
What is pl sql record in oracle?
What is oracle pl sql developer?
Write a sql query to get the third highest salary of an employee from employee_table?
How do sql databases work?
