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

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / yashvant.chowdary

8 Answers
12968 Views
Flextronics, I also Faced
E-Mail Answers

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

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