Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 65387 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 is sql and how does it work?
What does desc stand for?
explain the advantages and disadvantages of stored procedure? : Sql dba
which operator is used in query for pattern matching? : Sql dba
what is the difference between char and varchar data types? : Sql dba
Is record in oracle pl sql?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Can we join more than 2 tables in sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
Which language is used in sql?
What is left join example?
What is online transaction processing (oltp)?
How to Execute a Package in PL/SQL.?
Why is theta join required?
What is the difference between pl and sql?
