How does DB2 store NULL physically?

Answers were Sorted based on User's Feedback



How does DB2 store NULL physically?..

Answer / s

DB2 stores an additional byte for every nullable column to
indicate whether the column contains an actual value or
null.

Is This Answer Correct ?    9 Yes 0 No

How does DB2 store NULL physically?..

Answer / sachin

db2 every coloumn have prefix .
if its hexa = '00' then coloumn have the null value
and if its other than null then it containx 'ff'

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

Can you Average the Characters ?

3 Answers  


What is the latest version of ibm db2?

0 Answers  


How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,


What are the disadvantages of using VARCHAR?

3 Answers  


What is dbrm? What it contains? When it will be created?

0 Answers  


can i code union in cobol-db2 pgm ?

4 Answers   Patni,


What are catalog tables in db2?

0 Answers  


Which catalog table stores referential constraints?

1 Answers  


What is REORG? When is it used?

4 Answers  


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,


What is a clustering index?

2 Answers  


Can I use LOCK TABLE on a view?

1 Answers  


Categories