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
0 Comments