How does DB2 store NULL physically ?
As an extra-byte prefix to the column value. Physically, the null prefix is Hex ‘00′ if the value is present and Hex ‘FF’ if it is not.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Explain about null? 17.11.08
Null represents a variable with no value inside. There doesn’t exist any value for type Null. Null is defined to be null if and only if it is assigned a const...What is a null pointer? 07.11.08
There are times when it’s necessary to have a pointer that doesn’t point to anything. The macro NULL, defined in , has a value that’s guaranteed to be dif...Why cant one make an object of abstract class?Give compiler view of statement 27.10.08
we cant make object of abstract class becoz, in the vtable the vtable entry for the abstract class functions will be NULL, which ever are defined as pure vi...What does javascript null mean? 07.10.08
The null value is a unique value representing no value or no object. It implies no object,or null string,no valid boolean value,no number and no array object....Diff type of Datatypes? 22.04.07
LOB (Large Object Data type). CLOB (Stores Character Objects). BLOB ( Store Binary Objects such as Graphic, Video Chips and Sound files). BFILE(Store file po...What is the difference bitween NULL AND VOID pointer? 11.12.06
NULL can be value for pointer type variables. VOID is a type identifier which has not size. NULL and void are not same. Example: void* ptr = NULL;...What does javascript null mean? 06.07.06
The null value is a unique value representing no value or no object. It implies no object,or null string,no valid boolean value,no number and no array object....What is the difference between NULL and NUL? 22.03.06
NULL is a macro defined in for the null pointer. NUL is the name of the first character in the ASCII character set. It corresponds to a zero value. Thereâ...What is a null pointer? 22.03.06
There are times when it’s necessary to have a pointer that doesn’t point to anything. The macro NULL, defined in , has a value that’s guaranteed to be d...What’s the difference between a null pointer, a NULL macro, the ASCII NUL character and a null string? 12.03.06
A null pointer is a pointer which doesn't point anywhere. A NULL macro is used to represent the null pointer in source code. It has a value 0 associated with it...