UGC NET CSE | August 2016 | Part 3 | Question: 11

Question

Consider the following ORACLE relations : One $(x, y) = {, , , , , }$ Two $(x, y) = {, , , , , , , }$ 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 ?

• A. 2 and 1 respectively
• B. 1 and 2 respectively
• C. 2 and 2 respectively
• D. 1 and 1 respectively

Answer 1

Option 4 is the answer.

Comments

 @ritu raj

One (x,y)=,,,,, Two (x,y)=,,,,,,,  ??????

what does it represents  ????