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

  • 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.
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


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

  • 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.
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


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:

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


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

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


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:

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


Related Quiz.
December 2015 Paper 3