Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 65452 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / hassan khan
A unique key constraint does not imply the NOT NULL
constraint in practice. Because NULL is not an actual value
(it represents the lack of a value), when two rows are
compared, and both rows have NULL in a column, the column
values are not considered to be equal. Thus, in order for a
unique key to uniquely identify each row in a table, NULL
values must not be used. According to the SQL standard and
Relational Model theory, a unique key (unique constraint)
should accept NULL in several rows/tuples — however not all
RDBMS implement this feature correctly.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the 'mysql' command line options? : Sql dba
what is the difference between myisam static and myisam dynamic? : Sql dba
Why is theta join required?
What is ttitle and btitle?
Show the two pl/sql cursor exceptions.
How many clustered indexes can you have?
Is and as keyword in pl sql?
How to return multiple rows from the stored procedure?
How do I enable sql encryption?
What do you understand by pl/sql cursors?
how to drop an existing index in mysql? : Sql dba
What are the 3 types of behavioral triggers?
What is the largest value that can be stored in a byte data field?
What is replication id?
What is a scalar value in sql?
