How many null values can be inserted in a coulmn whihc is unique constraint

Answers were Sorted based on User's Feedback



How many null values can be inserted in a coulmn whihc is unique constraint..

Answer / sumit

Any number of Null values can be inserted in such a column.

Is This Answer Correct ?    33 Yes 7 No

How many null values can be inserted in a coulmn whihc is unique constraint..

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

How many null values can be inserted in a coulmn whihc is unique constraint..

Answer / ajay badola

Any number of null values can be inserted.

Is This Answer Correct ?    4 Yes 2 No

How many null values can be inserted in a coulmn whihc is unique constraint..

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

How many null values can be inserted in a coulmn whihc is unique constraint..

Answer / veerapandian muthupandi

Only one null

Is This Answer Correct ?    0 Yes 0 No

How many null values can be inserted in a coulmn whihc is unique constraint..

Answer / sheea pruthi

12

Is This Answer Correct ?    0 Yes 7 No

How many null values can be inserted in a coulmn whihc is unique constraint..

Answer / bhargav

single NULL

Is This Answer Correct ?    0 Yes 10 No

How many null values can be inserted in a coulmn whihc is unique constraint..

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

Post New Answer

More SQL PLSQL Interview Questions

what is the order of pre-defined exceptions.

6 Answers   TCS,


What is the relation b/w view and trigger

3 Answers   Accenture, TCS,


What is the difference between a database and a relational database?

0 Answers  


What happens when a trigger is associated to a view?

0 Answers  


Why do we use cursors?

0 Answers  






Is coalesce faster than isnull?

0 Answers  


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

2 Answers  


What are the limitations of sql express?

0 Answers  


What are literals in sql server?

0 Answers  


Explain foreign key in sql?

0 Answers  


What is faster join or subquery?

0 Answers  


Categories