PREVIOUS YEAR SOLVED PAPERS - December 2015 Paper 3

Avatto > > UGC NET COMPUTER SCIENCE > > PREVIOUS YEAR SOLVED PAPERS > > December 2015 Paper 3

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) ?

Answer
Comment
Array

Option : C
Explanation :
According to question: Select Name from people where Age > 21; will return 10 rows. Select Name from people where Height > 180; will return 7 rows. Then Select Name from people where (Age > 21) or (Height > 180); will return 10 rows. Since there is or between the condition. That's why it will return 10 rows. So, option (C) is correct.

You must be logged in to post a comment.

You must be logged in to post a comment.

62. The distributed system is a collection of (P)and communication is achieved in distributed system by(Q), where (P) and (Q) are:

Answer
Comment
Array

Option : C
Explanation :
The distributed system is a collection of (P)and communication is achieved in distributed system by(Q), where (P) and (Q) are tightly coupled software on loosely coupled hardware and message passing, respectively. So, option (C) is correct.

You must be logged in to post a comment.

You must be logged in to post a comment.

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:

A
B
C
D

Answer
Comment
Array

Option : A
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

64. Consider the two class classification task that consists of the following points: Class C₁ : [21, 21], [21, 1], [1, 21] Class C₂ : [1, 1] The decision boundary between the two classes C₁ and C₂ using single perceptron is given by:

Answer
Comment
Array

Option : D
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

65. Consider a standard additive model consisting of rules of the form of If x is A_i AND y is B_i THEN z is C_i. Given crisp inputs x = x₀, y = y₀, the output of the model is:

Answer
Comment
Array

Option : C
Explanation :

You must be logged in to post a comment.

You must be logged in to post a comment.

Related Quiz.
December 2015 Paper 3

Forgot your password?

I agree with the Terms.