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
What is the syntax for FETCH in DB2 ?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What does reorg do in db2?
What is the difference between oracle and db2?
What types of tables are there in the db2 database?
What is a trigger in the db2 database?
How to resolve deadlock issue
What is performance tuning db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is the difference between using bind () and rebind () methods of naming class?
Which component is used to execute the sql statements?
How to compare data between two tables in db2?
How does a cursor work?