July 2016 - Paper 3

1. Home
2. UGC NET Computer Science Solved Papers
3. July 2016
4. Paper 3

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, 4, 5>, <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 DISTINCT 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 returned by SQ2 then

A.	M = 4, N = 2
B.	M = 5, N = 3
C.	M = 2, N = 2
D.	M = 3, N = 3
	Answer Report Discuss
	Option: A Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

12:   Semi-join strategies are techniques for query processing in distributed database system.
Which of the following is a semi-join technique ?

A.	Only the joining attributes are sent from one site to another and then all of the rows are returned.
B.	All of the attributes are sent from one site to another and then only the required rows are returned.
C.	Only the joining attributes are sent from one site to another and then only the required rows are returned.
D.	All of the attributes are sent from one site to another and then only the required rows are returned.
	Answer Report Discuss
	Option: C Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

13:  

Consider the Breshenham’s circle generation algorithm for plotting a circle with centre (0, 0) and radius ‘r’ units in first quadrant.If the current point is (x_i, y_i ) and decision parameter is p_i then what will be the next point (x_i+1, y_{i + 1}) and updated decision parameter p_{i + 1} for p_i ≥ 0 ?

A.	xi + 1 = xi+ 1 yi + 1 = yi pi + 1 = pi+ 4xi+ 6
B.	xi + 1 = xi+ 1 yi + 1 = yi – 1 pi + 1 = pi+ 4 (xi– yi) + 10
C.	xi + 1 = xi yi + 1 = yi – 1 pi + 1 = pi + 4 (xi – yi ) + 6
D.	xi + 1 = xi– 1 yi + 1 = yi pi + 1 = pi + 4xi + 10
	Answer Report Discuss
	Option: B Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

14:  

A point P(5, 1) is rotated by 90° about a pivot point (2, 2). What is the coordinate of new transformed point P′ ?

A.	(3, 5)
B.	(5, 3)
C.	(2, 4)
D.	(1, 5)
	Answer Report Discuss
	Option: A Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

15:  

Let R be the rectangular window against which the lines are to be clipped using 2D Sutherland-Cohen line clipping algorithm. The rectangular window has lower left-hand corner at (– 5, 1) and upper right-hand corner at (3, 7). Consider the following three lines for clipping with the given end point co-ordinates :

 

Line AB : A (– 6, 2) and B (–1, 8)

 

Line CD : C (– 1, 5) and D (4, 8)

 

Line EF : E (–2, 3) and F (1, 2)

 

Which of the following line(s) is/are candidate for clipping ?

A.	AB
B.	CD
C.	EF
D.	AB and CD
	Answer Report Discuss
	Option: D Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• »