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

how to find 5th row ?

10 Answers  


how to increment dates by 1 in mysql? : Sql dba

0 Answers  


What are variables in pl sql?

0 Answers  


What is sql stand for?

0 Answers  


What is differance unique key and primary key.

7 Answers   EDS,






What is the purpose of my sql?

0 Answers  


What is cartesian join in sql?

0 Answers  


What is an Integrity Constraint?

4 Answers  


Is it possible to pass parameters to triggers?

0 Answers  


Is primary key an index?

0 Answers  


What is the difference between delete and truncate commands?

0 Answers  


table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,


Categories