The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is_______ false and unknown is _____ while unknown and unknown is _____
(a) Unknown, unknown, false
(b) True, false, unknown
(c) True, unknown, unknown
(d) Unknown, false, unknown
I have been asked this question in an online quiz.
This intriguing question comes from Null Values Operations topic in section SQL : Queries, Constraints and Triggers of Database Management