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

## Thursday, 4 February 2016

61.       Consider the following three SQL queries (Assume the data in the people table) :
(a) Select Name from people where Age>21;
(b) Select Name from people where Height>180;
(c) Select Name from people where (Age>21) or (Height>180);
If the SQL queries (a) and (b) above, return 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query (c) ? (A) 3   (B) 7
(C) 10     (D) 21
62.       The distributed system is a collection of (P) and communication is achieved in distributed system by (Q) , where (P) and (Q) are :
(A) Loosely coupled hardware on tightly coupled software and disk sharing, respectively.
(B) Tightly coupled hardware on loosely coupled software and shared memory, respectively.
(C) Tightly coupled software on loosely coupled hardware and message passing,
respectively.
(D) Loosely coupled software on tightly coupled hardware and file sharing, respectively.
63.       Consider the following three tables R, S and T. In this question, all the join operations are natural joins (). (Ï€) is the projection operation of a relation :
Possible answer tables for this question are also given as below :
What is the resulting table of Ï€A,B(RT)Ï€B,C(ST) ?
(A) (a)                 (B) (b)
(C) (c)                 (D) (d)
64.       Consider the two class classification task that consists of the following points :
Class C1: [-1, -1], [-1, 1], [1, -1]
Class C2: [1, 1]
The decision boundary between the two classes C1 and C2 using single perceptron is given by :
(A) x1-x2-0.5=0              (B) -x1+x2-0.5=0
(C) 0.5(x1+x2)-1.5=0     (D) x1+x2-0.5=0
65.       Consider a standard additive model consisting of rules of the form of
If x is Ai AND y is Bi THEN z is Ci.
Given crisp inputs x=x0, y=y0, the output of the model is :

66.       A bell-shaped membership function is specified by three parameters (a, b, c) as follows:

67.       Which of the following is/are the principle components of a memory-tube display ?
(a) Flooding gun                      (b) Collector
(c) Phosphorus grains            (d) Ground
Codes :
(A) (a) and (b)               (B) (c) only
(C) (d) only                    (D) All the above
68.       Which of the following steps is/are not required for analog to digital conversion ?
(a) Sensing                  (b) Conversion         (c) Amplification
(d) Conditioning          (e) Quantization
Codes :
(A) (a) and (b)               (B) (c) and (d)
(C) (a), (b) and (e)        (D) None of the above
69.       Which raster locations would be chosen by Bresenham’s algorithm when scan converting a line from (1, 1) to (8, 5) ?