Aug2016 cs Q11

0. Consider the following ORACLE relations :
One (x, y) = {<2, 5>, <1, 6>, <1, 6>, <1, 6>, <4, 8>, <4, 8>}
Two (x, y) = {<2, 55>, <1, 1>, <4, 4>, <1, 6>, <4, 8>, <4, 8>, <9, 9>, <1, 6>}
Consider the following two SQL queries SQ1 and SQ2 :
SQ1 : SELECT * FROM One)
EXCEPT
(SELECT * FROM Two);
SQ2 : SELECT * FROM One)
EXCEPT ALL
(SELECT * FROM Two);
For each of the SQL queries, what is the cardinality (number of rows) of the result obtained when applied to the instances above ?

Answer
Comment
Array

Option : B
Explanation :
SQ1 : SELECT * FROM One) EXCEPT (SELECT * FROM Two); It will result into single tuple (2, 5) because all duplicate tuples will be removed.
SQ2 : SELECT * FROM One) EXCEPT ALL (SELECT * FROM Two); It will result into 2 tuples because it will not remove duplicate.
So, option (B) is correct.

Forgot your password?

I agree with the Terms.