How does DB2 store NULL physically?

Question Posted / guest

Answers were Sorted based on User's Feedback

How does DB2 store NULL physically?..

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

More DB2 Interview Questions

What is an inner join, and an outer join ?

what is the difference between declaring the cursor in WS section and Procedure division?

Which command is used to remove all rows from a table?

Can any one tell me about Restart logic in DB2.

What does db2 blu stand for?

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

How do I connect my db2 database to ibm?

What is lock escalation in db2?

Can we declare DB2 HOST variable in COBOL COPY book?

What happens to the PLAN if index used by it is dropped?

Q4. How will you get the count of record without using COUNT verb in query?

How is deadlock resolved?

For more DB2 Interview Questions Click Here