If we talk about theory - then the Codd's rules say that RDBMS must tread NULL values in a special way.

How exactly that is used is up to DB Architects, depending on actual domain - task - project - application - area.