Register

Finding output of given SQL query

• retagged by
1,067 views

1 Answer

3 votes
3 votes

NULL = unknown 
unknown AND True = unknown
unknown AND False = False
unknown AND unknown = unknown

unknown OR True = True
unknown OR False = unknown
unknown OR unknown = unknown

So according to me answer is
option B) A and C are selected.

 

User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
shikharV asked Dec 8, 2015
403 views
Finding output of given SQL query
Given answer: B I don't know how to deal with NULL in such query operations. Please explain.
Given answer: BI don't know how to deal with NULL in such query operations. Please explain.
User Avatar
3 votes
3 votes
2 answers
3
shikharV asked Dec 8, 2015
1,181 views
Output of given sql query
Use the following tables for the below queries wherever table $1$ and table $2$ are used: Select * From Table 1 Where not exists (Select $T_{2}B$ From Table 2 where $T_{2}B < > T_{1}B$) How many number of rows will be there in the output ? $1$ $2$ $3$ $0$
Use the following tables for the below queries wherever table $1$ and table $2$ are used:Select *From Table 1Where not exists (Select $T_{2}B$ From Table 2 where $T_{2}B ...
User Avatar
Link Copied!