MCQOPTIONS
Saved Bookmarks
| 1. |
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» C. 2 and 2 respectively | |