Sample Questions, Previous Year Solved Papers, Study Materials For Competitive Examinations Like UGC NET, SET And GATE Computer Science.

## Sunday, 26 November 2017

11.       Given two relations R1(A, B) and R2(C, D), the result of following query
Select distinct A, B from R1, R2
is guaranteed to be same as R1 provided one of the following condition is satisfied.
(1) R1 has no duplicates and R2 is empty.
(2) R1 has no duplicates and R2 is non - empty.
(3) Both R1 and R2 have no duplicates.
(4) R2 has no duplicates and R1 is non - empty.
Answer: 2
12.       Consider a schema R(A, B, C, D) and following functional dependencies.
A → B
B → C
C → D
D → B
Then decomposition of R into R1(A, B), R2(B, C) and R3(B, D) is ..................
(1) Dependency preserving and lossless join.
(2) Lossless join but not dependency preserving.
(3) Dependency preserving but not lossless join.
(4) Not dependency preserving and not lossless join.
Answer: 1
13.       Which of the following is not a component of Memory tube display?
(1) Flooding gun
(2) Collector
(3) Ground
(4) Liquid Crystal
Answer: 4
14.       Which of the following is not true in case of Oblique Projections?
(1) Parallel projection rays are not perpendicular to the viewing plane.
(2) Parallel lines in space appear parallel on the final projected image.
(3) Used exclusively for pictorial purposes rather than formal working drawings.
(4) Projectors are always perpendicular to the plane of projection.
Answer: 4
15.       With respect to CRT, the horizontal retrace is defined as :
(1) The path an electron beam takes when returning to the left side of the CRT.
(2) The path an electron beam takes when returning to the right side of the CRT.
(3) The technique of turning the electron beam off while retracing.
(4) The technique of turning the electron beam on/off while retracing.
Answer: 1
16.       Find the equation of the circle x2+y2=1 in terms of x'y' coordinates, assuming that the xy coordinate system results from a scaling of 3 units in the x' direction and 4 units in the y' direction.
(1) 3(x')2 + 4(y')2 = 1
(2) (x'/3)2 + (y'/4)2 = 1
(3) (3x')2 + (4y')2 = 1
(4) 1/3(x')2 + 1/4(y')2 = 1
Answer: 2
17.       Find the normalization transformation that maps a window whose lower left corner is at (1, 1) and upper right corner is at (3, 5) onto a viewport that is the entire normalized device screen.
Answer: 1
18.       The three aspects of Quantization, programmers generally concerned with are:
(1) Coding error, Sampling rate and Amplification
(2) Sampling rate, Coding error and Conditioning
(3) Sampling rate, Aperture time and Coding error
(4) Aperture time, Coding error and Strobing
Answer: 3
19.       The logic of pumping lemma is an example of ....................
(1) iteration
(2) recursion
(3) the divide and conquer principle
(4) the pigeon - hole principle
Answer: 4
20.    Heap allocation is required for languages that :
(1) use dynamic scope rules
(2) support dynamic data structures
(3) support recursion
(4) support recursion and dynamic data structures
Answer: 2