Register

Finding output of given SQL query

• retagged by
1,480 views
0 0 votes

Given answer: B
I don't know how to deal with NULL in such query operations. Please explain.

1 Answer

3 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.

 

Voting & Accepting an answer helps improve the community
← Previous · How to approach this...Next → · Finding output of gi...
← Previous in category · How to approach this...Next in category → · Finding output of gi...
Position:
Show:

Related questions

0 0 votes
1 1 answer
646
646 views
shikharV asked Dec 8, 2015
646 views
Finding output of given SQL query
Given answer: BI don't know how to deal with NULL in such query operations. Please explain.
3 3 votes
2 2 answers
2.5k
2.5k views
sh!va asked Nov 14, 2016
2,548 views
Predict the output of given SQL query
Tables are : COUNTRY (CODE, NAME) and MEMBER (ORGANIZATION, COUNTRY_code). primary keys are in blod letters and foreign key is in italics.SELECT COUNTRY.nameFROM COUNTRYJ...
3 3 votes
2 answers 2 answers
1.9k
1.9k views
shikharV asked Dec 8, 2015
1,869 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 1Where not exists (Select $T_{2}B$ From Table 2 where $T_{2}B ...
1 1 vote
1 answers 1 answer
1.2k
1.2k views
tishhaagrawal asked Dec 16, 2023
1,201 views
MadeEasy Test Series: How many tuples will be present in the output of the following SQL query.
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right?For example, in the...