The figure below shows results of predicates on which logical operations are performed.

The result of a predicate (other than the NULL predicate) that contains the null value is undefined.

A predicate that produces the null value is ineligible for retrieval.

Figure 2-4 Results of predicates on which logical operations are performed