11.
Given two relations R

_{1}(A, B) and R_{2}(C, D), the result of following query
Select
distinct A, B from R

_{1}, R_{2}
is
guaranteed to be same as R

_{1}provided one of the following condition is satisfied.
(1) R

_{1}has no duplicates and R_{2}is empty.
(2) R

_{1}has no duplicates and R_{2}is non - empty.
(3) Both R

_{1}and R_{2}have no duplicates.
(4) R

_{2}has no duplicates and R_{1}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 R

_{1}(A, B), R_{2}(B, C) and R_{3}(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 x

^{2}+y^{2}=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