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

Where can you declare a cursor in a cobol-db2 program?

0 Answers  


what is the use of cursors?

3 Answers   iGate,


Can one database have multiple instances?

0 Answers  


In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,


What does DSNDB07 database do?

2 Answers  


What is multi row fetch in db2?

0 Answers  


Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  


How to rename a table in DB2 ?

0 Answers   MCN Solutions,


How many buffer pools are there in DB2?

2 Answers  


On the create tablespace, what does the CLOSE parameter do?

1 Answers  


If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,


What is the difference between base table and view?

7 Answers  


Categories