If we talk about theory -, then the Codd's rules say that RDBMS must tread NULLtreat NULL
values in a special way.
How exactly that is used is up to DB Architectsdatabase architects, depending on actual domain - task - project - application - area.