UGC Net Computer Science Paper 3 July-16 Page 2
11. Consider the following ORACLE relations :
R {A,B,C}={<1,2,3>,<1,2,0>,<1,3,1>,<6,2,3>,<1,4,2>,<3,1,4>}
S (B,C,D)= {<2,3,7>,<1,2,3>,<2,3,4>,<3,1,4}
Consider the following two SQL queries SQ1 and SQ2:
SQ1 : SELECT R.B,AVG(S.B) FROM R,S
WHERE R.A=S.C AND S.D<7
GROUP BY R.B :
SQ2 : SELECT DISTICT S.B, MIN (S.C)
FROM S
GROUP BY S.B
HAVING COUNT (DISTINCT S.D)>1 :
If M is the number of tuples returned by SQ1 and N is the number of tuples return by SQ2 then
(1) M=4,N=2
(2) M=5,N=3
(3) M=2,N=2
(4) M=3,N=3
Answer : 1
12. Semi join strategies are technique for query processing in distributed database system.
(1) Only the joining attribute are sent from one site to another and then all of the rows are returned.
(2) All of the attributes are sent from one site to another and then only require rows are
Returned.
(3) Only the joining attribute are sent from one site to another and then only the required rows are returned.
(4) All of the attribute are sent from one site to another and then only the required rows are returned.
Answer : 4