UGC Net Computer Science Paper 3 July-16 Page 2

UGC Net Computer Science Paper 3 July-16 Page 2

11. Consider the following ORACLE relations :
R {A,B,C}={<1,2,3>,<1,2,0>,<1,3,1>,<6,2,3>,<1,4,2>,<3,1,4>}
S (B,C,D)= {<2,3,7>,<1,2,3>,<2,3,4>,<3,1,4}
Consider the following two SQL queries SQ1 and SQ2:
SQ1 : SELECT R.B,AVG(S.B) FROM R,S
WHERE R.A=S.C AND S.D<7
GROUP BY R.B :
SQ2 : SELECT DISTICT S.B, MIN (S.C)
FROM S
GROUP BY S.B
HAVING COUNT (DISTINCT S.D)>1 :
If M is the number of tuples returned by SQ1 and N is the number of tuples return by SQ2 then
(1) M=4,N=2
(2) M=5,N=3
(3) M=2,N=2
(4) M=3,N=3
Answer : 1

12. Semi join strategies are technique for query processing in distributed database system.
(1) Only the joining attribute are sent from one site to another and then all of the rows are returned.
(2) All of the attributes are sent from one site to another and then only require rows are
Returned.
(3) Only the joining attribute are sent from one site to another and then only the required rows are returned.
(4) All of the attribute are sent from one site to another and then only the required rows are returned.
Answer : 4

UGC Net Computer Science Paper 3 Page 1

1. Which of the following is a sequential circuit?
(1)  Multiplexer
(2) Decoder
(3) Counter
(4) Full Adder
Answer : 2

2. 8085 microprocessor has_______ hardware interrupts.
(1) 2
(2) 3
(3) 4
(4) 5
Answer : 1

July, 2010 M4.1-R4: APPLICATION OF .NET TECHNOLOGY

July, 2010

M4.1-R4: APPLICATION OF .NET TECHNOLOGY

NOTE:
1. There are TWO PARTS in this Module/Paper. PART ONE contains FOUR questions and
PART TWO contains FIVE questions.
2. PART ONE is to be answered in the TEAR-OFF ANSWER SHEET only, attached to the
question paper, as per the instructions contained therein. PART ONE is NOT to be answered in
the answer book.
3. Maximum time allotted for PART ONE is ONE HOUR. Answer book for PART TWO will be
supplied at the table when the answer sheet for PART ONE is returned. However, candidates,
who complete PART ONE earlier than one hour, can collect the answer book for PART TWO
immediately after handing over the answer sheet for PART ONE.
TOTAL TIME: 3 HOURS TOTAL MARKS: 100
(PART ONE – 40; PART TWO – 60)

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 In C#, a statement “a ? b : c” means
A) If a is true, returns the value of b, otherwise c
B) If b is true, returns the value of a, otherwise c
C) If a is true, returns the value of c, otherwise b
D) If c is true, returns the value of b, otherwise a

1.2 In C#, a statement “a ?? b” means
A) If a is null and b is null, returns a
B) If a is null, returns a, otherwise returns b
C) If a is null, returns b, otherwise returns a
D) None of the above

July, 2011 M4.1-R4: APPLICATION OF .NET TECHNOLOGY

July, 2011

M4.1-R4: APPLICATION OF .NET TECHNOLOGY

NOTE:
1. There are TWO PARTS in this Module/Paper. PART ONE contains FOUR questions and
PART TWO contains FIVE questions.
2. PART ONE is to be answered in the TEAR-OFF ANSWER SHEET only, attached to the
question paper, as per the instructions contained therein. PART ONE is NOT to be answered in
the answer book.
3. Maximum time allotted for PART ONE is ONE HOUR. Answer book for PART TWO will be
supplied at the table when the answer sheet for PART ONE is returned. However, candidates,
who complete PART ONE earlier than one hour, can collect the answer book for PART TWO
immediately after handing over the answer sheet for PART ONE.

TOTAL TIME: 3 HOURS TOTAL MARKS: 100
(PART ONE – 40; PART TWO – 60)

PART ONE

(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1. What are the 4 pillars of any object oriented programming language?
A) Abstraction, Inheritance, Encapsulation, Constructor
B) Abstraction, Inheritance, Encapsulation, Polymorphism
C) Abstraction, Object of a class, Inheritance, Polymorphism
D) Abstraction, Constructor, Encapsulation, Polymorphism

1.2. Is the following code legal?
class ChildClass : ParentClassA, ParentClassB
{
}
A) Yes, a child class can have 2 base classes at the same time and it does also allow multiple
interface inheritance.
B) No, you cannot specify 2 base classes at the same time. You can specify only one base class to
inherit from. However, it does allow multiple interface inheritance.
C) Yes, C# supports multiple class inheritance and it does not allow multiple interface inheritance.
D) No, you can specify only one base class at the same time to inherit from. However, it does not
allow multiple interface inheritance.