How many null values can be inserted in a coulmn whihc is unique constraint
Answers were Sorted based on User's Feedback
Answer / sumit
Any number of Null values can be inserted in such a column.
Is This Answer Correct ? | 33 Yes | 7 No |
Answer / amit
Any no. of times you can insert null values in a coulmn
whihc is unique constraint because a Null value is
undefined,unassigned,and unapplicable value so thats why we
cannot compaire with any other null value or other value.
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / john bershan
any number of null value can be inserted into table for a
column which is declared as unique.coz null vale s either
not equal to any value or not equal to another null;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / manish kumar
Single null Value
B'cse Unique Constraint contain unique value and single
null is also a unique value.
Is This Answer Correct ? | 7 Yes | 29 No |
what is the order of pre-defined exceptions.
What is the relation b/w view and trigger
What is the difference between a database and a relational database?
What happens when a trigger is associated to a view?
Why do we use cursors?
Is coalesce faster than isnull?
what is difference b/w pravite procedures and public procedures?
3 Answers Steria, Wipro, Zensar,
Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN
What are the limitations of sql express?
What are literals in sql server?
Explain foreign key in sql?
What is faster join or subquery?