1.

Are NULL values in a database the same as that of blank space or zero?

Answer»

No, a NULL value is very different from that of ZERO and blank space as it represents a value that is ASSIGNED, unknown, unavailable, or not applicable as COMPARED to blank space which represents a character and zero represents a number.

Example: NULL value in “number_of_courses” taken by a student represents that its value is unknown WHEREAS 0 in it MEANS that the student hasn’t taken any courses.



Discussion

No Comment Found