Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Can a unique index have more than one null value? If not,
what error code is given if an attempt is made to insert
more than one null value?

Answer Posted / mani

Unique index can have null values and no null value is equal
to another null value.

i don't know if it raises an error or not when you insert a
null value.
Null value acceptance in the column is again based on the
definition given for the column whether it can accept null
values or not.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax for FETCH in DB2 ?

1267


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1246


What does reorg do in db2?

1074


What is the difference between oracle and db2?

1173


What types of tables are there in the db2 database?

1101


What is a trigger in the db2 database?

1141


How to resolve deadlock issue

20318


What is performance tuning db2?

1109


What is the cobol picture clause of the db2 data types date, time, timestamp?

1121


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2268


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1234


What is the difference between using bind () and rebind () methods of naming class?

1457


Which component is used to execute the sql statements?

1145


How to compare data between two tables in db2?

1138


How does a cursor work?

1040