Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?
A. Both I and II
B. I only
C. II only
D. Neither I nor I
Answer:A
Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?
A. Both I and II B. I only C. II only D. Neither I nor I
Explanation:The query can be satisfied by any of the two options. 8. Suppose relation R(A,B) currently has tuples {(1,2), (1,3), (3,4)} and relation S(B,C) currently has {(2,5), (4,6), (7,8)}. Then the number of tuples in the result of the SQL query: