UGC-NET JULY 2016 PAPER 3 QUESTIONS WITH EXPLANATION
Q:: 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
(1) M = 4, N = 2 (2) M = 5, N = 3
(3) M = 2, N = 2 (4) M = 3, N = 3
Answer:: (1)
Q:: 12 Semi-join strategies are techniques for query processing in distributed database system.
Which of the following is a semi-join technique ?
(1) Only the joining attributes 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 the required rows
are returned.
(3) Only the joining attributes are sent from one site to another and then only the
required rows are returned.
(4) All of the attributes are sent from one site to another and then only the required rows
are returned.
Answer:: (3)
Q:: 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 (xi, yi) and decision
parameter is pi then what will be the next point (xi + 1, yi + 1) and updated decision parameter pi + 1 for pi ≥ 0 ?
(1) xi + 1 = xi + 1
yi + 1 = yi
pi + 1 = pi + 4xi + 6
(2) xi + 1 = xi + 1
yi + 1 = yi – 1
pi + 1 = pi + 4 (xi – yi) + 10
(3) xi + 1 = xi
yi + 1 = yi – 1
pi + 1 = pi + 4 (xi – yi) + 6
(4) xi + 1 = xi – 1
yi + 1 = yi
pi + 1 = pi + 4xi + 10
Answer:: (2)
Q:: 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′ ?
(1) (3, 5) (2) (5, 3)
(3) (2, 4) (4) (1, 5)
Answer:: (1)
Q:: 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 ?
(1) AB (2) CD
(3) EF (4) AB and CD
Answer:: (4)
Q:: 16 In perspective projection, if a line segment joining a point which lies in front of the viewer to a point in back of the viewer is projected to a broken line of infinite extent. This is known as _______.
(1) View confusion (2) Vanishing point
(3) Topological distortion (4) Perspective foreshortening
Answer:: (3)
Q:: 17 Let us consider that the original point is (x, y) and new transformed point is (x′, y′).
Further, Shx and Shy are shearing factors in x and y directions. If we perform the y-direction shear relative to x = xref then the transformed point is given by _______.
(1) x′ = x + Shx ⋅ (y – yref)
y′ = y
(2) x′ = x
y′ = y ⋅ Shx
(3) x′ = x
y′ = Shy (x – xref) + y
(4) x′ = Shy ⋅ y
y′ = y ⋅ (x – xref)
Answer:: (3)
Q:: 18 Which of the following statement(s) is/are correct with reference to curve generation ?
I. Hermite curves are generated using the concepts of interpolation.
II. Bezier curves are generated using the concepts of approximation.
III. The Bezier curve lies entirely within the convex hull of its control points.
IV. The degree of Bezier curve does not depend on the number of control points.
(1) I, II and IV only (2) II and III only
(3) I and II only (4) I, II and III only
Answer:: (4)
Q:: 19 Given the following statements :
(A) To implement Abstract Data Type, a programming language require a syntactic unit
to encapsulate type definition.
(B) To implement ADT, a programming language requires some primitive operations
that are built in the language processor.
(C) C++, Ada, Java 5.0, C#2005 provide support for parameterised ADT.
Which one of the following options is correct ?
(1) (A), (B) and (C) are false.
(2) (A) and (B) are true; (C) is false.
(3) (A) is true; (B) and (C) are false.
(4) (A), (B) and (C) are true.
Answer:: (4)
Q:: 20 Match the following types of variables with the corresponding programming languages :
(a) Static variables (i) Local variables in Pascal
(b) Stack dynamic (ii) All variables in APL
(c) Explicit heap dynamic (iii) Fortran 77
(d) Implicit heap dynamic (iv) All objects in JAVA
Codes :
(a) (b) (c) (d)
(1) (i) (iii) (iv) (ii)
(2) (iv) (i) (iii) (ii)
(3) (iii) (i) (iv) (ii)
(4) (ii) (i) (iii) (iv)
Answer:: (3)
<<< 1 2 3 4 5 6 7 >>>
Q:: 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
(1) M = 4, N = 2 (2) M = 5, N = 3
(3) M = 2, N = 2 (4) M = 3, N = 3
Answer:: (1)
Q:: 12 Semi-join strategies are techniques for query processing in distributed database system.
Which of the following is a semi-join technique ?
(1) Only the joining attributes 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 the required rows
are returned.
(3) Only the joining attributes are sent from one site to another and then only the
required rows are returned.
(4) All of the attributes are sent from one site to another and then only the required rows
are returned.
Answer:: (3)
Q:: 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 (xi, yi) and decision
parameter is pi then what will be the next point (xi + 1, yi + 1) and updated decision parameter pi + 1 for pi ≥ 0 ?
(1) xi + 1 = xi + 1
yi + 1 = yi
pi + 1 = pi + 4xi + 6
(2) xi + 1 = xi + 1
yi + 1 = yi – 1
pi + 1 = pi + 4 (xi – yi) + 10
(3) xi + 1 = xi
yi + 1 = yi – 1
pi + 1 = pi + 4 (xi – yi) + 6
(4) xi + 1 = xi – 1
yi + 1 = yi
pi + 1 = pi + 4xi + 10
Answer:: (2)
Q:: 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′ ?
(1) (3, 5) (2) (5, 3)
(3) (2, 4) (4) (1, 5)
Answer:: (1)
Q:: 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 ?
(1) AB (2) CD
(3) EF (4) AB and CD
Answer:: (4)
Q:: 16 In perspective projection, if a line segment joining a point which lies in front of the viewer to a point in back of the viewer is projected to a broken line of infinite extent. This is known as _______.
(1) View confusion (2) Vanishing point
(3) Topological distortion (4) Perspective foreshortening
Answer:: (3)
Q:: 17 Let us consider that the original point is (x, y) and new transformed point is (x′, y′).
Further, Shx and Shy are shearing factors in x and y directions. If we perform the y-direction shear relative to x = xref then the transformed point is given by _______.
(1) x′ = x + Shx ⋅ (y – yref)
y′ = y
(2) x′ = x
y′ = y ⋅ Shx
(3) x′ = x
y′ = Shy (x – xref) + y
(4) x′ = Shy ⋅ y
y′ = y ⋅ (x – xref)
Answer:: (3)
Q:: 18 Which of the following statement(s) is/are correct with reference to curve generation ?
I. Hermite curves are generated using the concepts of interpolation.
II. Bezier curves are generated using the concepts of approximation.
III. The Bezier curve lies entirely within the convex hull of its control points.
IV. The degree of Bezier curve does not depend on the number of control points.
(1) I, II and IV only (2) II and III only
(3) I and II only (4) I, II and III only
Answer:: (4)
Q:: 19 Given the following statements :
(A) To implement Abstract Data Type, a programming language require a syntactic unit
to encapsulate type definition.
(B) To implement ADT, a programming language requires some primitive operations
that are built in the language processor.
(C) C++, Ada, Java 5.0, C#2005 provide support for parameterised ADT.
Which one of the following options is correct ?
(1) (A), (B) and (C) are false.
(2) (A) and (B) are true; (C) is false.
(3) (A) is true; (B) and (C) are false.
(4) (A), (B) and (C) are true.
Answer:: (4)
Q:: 20 Match the following types of variables with the corresponding programming languages :
(a) Static variables (i) Local variables in Pascal
(b) Stack dynamic (ii) All variables in APL
(c) Explicit heap dynamic (iii) Fortran 77
(d) Implicit heap dynamic (iv) All objects in JAVA
Codes :
(a) (b) (c) (d)
(1) (i) (iii) (iv) (ii)
(2) (iv) (i) (iii) (ii)
(3) (iii) (i) (iv) (ii)
(4) (ii) (i) (iii) (iv)
Answer:: (3)
<<< 1 2 3 4 5 6 7 >>>
No comments:
Post a Comment