Previous Year Paper From 2023-2019

Download as pdf or txt
Download as pdf or txt
You are on page 1of 54

SECTION B

[Only for candidates, who opted for Python]

1. (a) Differentiate between Syntax Error and Run-Time Error. Also, write
a suitable example in Python to illustrate both. 2

(b) Name the Python Library modules which need to be imported to


invoke the following functions : 1
(i) sin()
(ii) search()
(c) Rewrite the following code in Python after removing all syntax
error(s). Underline each correction done in the code. 2
Val = int(rawinput("Value:"))
Adder = 0

for C in range(1,Val,3)
Adder+=C
if C%2=0:
Print C*10
Else:
print C*
print Adder

(d) Find and write the output of the following Python code : 2
Data = ["P",20,"R",10,"S",30]
Times = 0
Alpha = ""
Add = 0
for C in range(1,6,2):
Times = Times + C
Alpha = Alpha + Data[C-1]+"$"
Add = Add + Data[C]
print Times,Add,Alpha
91 12
(e) Find and write the output of the following Python code : 3

class GRAPH:
def __init__(self,A=50,B=100):
self.P1=A
self.P2=B
def Up(self,B):
self.P2 = self.P2  B
def Down(self,B):
self.P2 = self.P2 + 2*B
def Left(self,A):
self.P1 = self.P1  A
def Right(self,A):
self.P1 = self.P1 + 2*A
def Target(self):
print "(",self.P1.":",self.P2,")"
G1=GRAPH(200,150)
G2=GRAPH()
G3=GRAPH(100)
G1.Left(10)
G2.Up(25)
G3.Down(75)
G1.Up(30)
G3.Right(15)
G1.Target()
G2.Target()
G3.Target()

91 13 P.T.O.
(f) What possible output(s) are expected to be displayed on screen at
the time of execution of the program from the following code ? Also
specify the maximum values that can be assigned to each of the
variables BEGIN and LAST. 2

import random
POINTS=[20,40,10,30,15];
POINTS=[30,50,20,40,45];

BEGIN=random.randint(1,3)
LAST=random.randint(2,4)
for C in range(BEGIN,LAST+1):
print POINTS[C],"#",

(i) 20#50#30# (ii) 20#40#45#

(iii) 50#20#40# (iv) 30#50#20#

2. (a) What is the advantage of super( ) function in inheritance ? Illustrate


the same with the help of an example in Python. 2

(b) class Vehicle: #Line 1 2


Type = 'Car' #Line 2
def __init__(self, name): #Line 3
self.Name = name #Line 4
def Show(self): #Line 5
print self.Name,Vehicle.Type #Line 6

V1=Vehicle("BMW") #Line 7
V1.Show() #Line 8
Vehicle.Type="Bus" #Line 9
V2=Vehicle("VOLVO") #Line 10
V2.Show() #Line 11

91 14
(i) What is the difference between the variable in Line 2 and
Line 4 in the above Python code ?

(ii) Write the output of the above Python code.

(c) Define a class CONTAINER in Python with the following


specifications : 4

Instance Attributes
- Radius,Height # Radius and Height of Container
- Type # Type of Container
- Volume # Volume of Container

Methods
- CalVolume() # To calculate volume
# as per the Type of container
# With the formula as given below :

Type Formula to calculate Volume

1 3.14 * Radius * Height

3 3.14 * Radius * Height/3

- GetValue() # To allow user to enter values of


# Radius, Height and Type.
# Also, this method should call
# CalVolume() to calculate Volume
- ShowContainer() # To display Radius, Height, Type
# Volume of the Container

91 15 P.T.O.
(d) Answer the questions (i) to (iv) based on the following : 4

Class Top1(object):
def __init__(self,tx): #Line 1
self.X=tx #Line 2
def ChangeX(self,tx):
self.X=self.X+tx
def ShowX(self):
print self.X

Class Top2(object):
def __init__(self,ty): #Line 3
self.Y=ty #Line 4
def ChangeY(self,ty):
self.Y=self.Y+ty
def ShowY(self):
print self.Y,

class Bottom(Top1,Top2):
def __init__(self,tz): #Line 5
self.Z=tz #Line 6
Top2.__init__(self,2*tz): #Line 7
Top1.__init__(self,3*tz): #Line 8
def ChangeZ(self,tz):
self.Z=self.Z+tz
self.ChangeY(2*tz)
self.ChangeX(3*tz)
def ShowZ(self):
print self.Z,
self.ShowY()
self.ShowX()
B=Bottom(1)
B.ChangeZ(2)
B.ShowZ()

91 16
(i) Write the type of the inheritance illustrated in the above.
(ii) Find and write the output of the above code.
(iii) What are the methods shown in Line 1, Line 3 and Line 5
known as ?
(iv) What is the difference between the statements shown in
Line 6 and Line 7 ?

3. (a) Consider the following randomly ordered numbers stored in a list : 3


786, 234, 526, 132, 345, 467
Show the content of the list after the First, Second and Third
pass of the bubble sort method used for arranging in ascending
order ?
Note : Show the status of all the elements after each pass very
clearly underlining the changes.

(b) Write the definition of a method ZeroEnding(SCORES) to add all


those values in the list of SCORES, which are ending with zero (0)
and display the sum. 3
For example :
If the SCORES contain [200, 456, 300, 100, 234, 678]
The sum should be displayed as 600

(c) Write AddClient(Client) and DeleteClient(Client) methods in Python


to add a new Client and delete a Client from a List of Client Names,
considering them to act as insert and delete operations of the queue
data structure. 4

(d) Write a definition of a method COUNTNOW(PLACES) to find and


display those place names, in which there are more than 5
characters. 2
For example :
If the list PLACES contains
["DELHI","LONDON","PARIS","NEW YORK","DUBAI"]
The following should get displayed :
LONDON
NEW YORK

(e) Evaluate the following Postfix notation of expression : 2


22,11,/,5,10,*,+,12,
91 17 P.T.O.
4. (a) Write a statement in Python to open a text file STORY.TXT so that
new contents can be added at the end of it. 1

(b) Write a method in Python to read lines from a text file INDIA.TXT,
to find and display the occurrence of the word ‘‘India’’. 2

For example :
If the content of the file is

‘‘India is the fastest growing economy.


India is looking for more investments around the globe.
The whole world is looking at India as a great market.
Most of the Indians can foresee the heights that India is
capable of reaching.’’

The output should be 4.

(c) Considering the following definition of class MULTIPLEX, write a


method in Python to search and display all the contents in a pickled
file CINEMA.DAT, where MTYPE is matching with the value
‘Comedy’. 3
class MULTIPLEX :
def __init__(self,mno,mname,mtype):
self.MNO = mno
self.MNAME = mname
self.MTYPE = mtype
def Show(self):
print self.MNO:"*",self.MNAME,"$",self.MTYPE

91 18
SECTION C
[For all the candidates]

5. (a) Observe the following tables VIDEO and MEMBER carefully and
write the name of the RDBMS operation out of (i) SELECTION
(ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which
has been used to produce the output as shown below. Also, find the
Degree and Cardinality of the final result. 2
TABLE : VIDEO
VNO VNAME TYPE
F101 The Last Battle Fiction
C101 Angels and Devils Comedy
A102 Daredevils Adventure

TABLE : MEMBER
MNO MNAME
M101 Namish Gupta
M102 Sana Sheikh
M103 Lara James

TABLE : FINAL RESULT


VNO VNAME TYPE MNO MNAME
F101 The Last Battle Fiction M101 Namish Gupta
F101 The Last Battle Fiction M102 Sana Sheikh
F101 The Last Battle Fiction M103 Lara James
C101 Angels and Devils Comedy M101 Namish Gupta
C101 Angels and Devils Comedy M102 Sana Sheikh
C101 Angels and Devils Comedy M103 Lara James
A102 Daredevils Adventure M101 Namish Gupta
A102 Daredevils Adventure M102 Sana Sheikh
A102 Daredevils Adventure M103 Lara James

91 19 P.T.O.
(b) Write SQL queries for (i) to (iv) and find outputs for SQL queries
(v) to (viii), which are based on the tables. 6

TABLE : ACCOUNT
ANO ANAME ADDRESS
101 Nirja Singh Bangalore
102 Rohan Gupta Chennai
103 Ali Reza Hyderabad
104 Rishabh Jain Chennai
105 Simran Kaur Chandigarh

TABLE : TRANSACT
TRNO ANO AMOUNT TYPE DOT
T001 101 2500 Withdraw 2017-12-21
T002 103 3000 Deposit 2017-06-01
T003 102 2000 Withdraw 2017-05-12
T004 103 1000 Deposit 2017-10-22
T005 101 12000 Deposit 2017-11-06

(i) To display details of all transactions of TYPE Deposit from


Table TRANSACT.
(ii) To display the ANO and AMOUNT of all Deposits and
Withdrawals done in the month of October 2017 from table
TRANSACT.
(iii) To display the last date of transaction (DOT) from the table
TRANSACT for the Accounts having ANO as 103.
(iv) To display all ANO, ANAME and DOT of those persons from
tables ACCOUNT and TRANSACT who have done
transactions less than or equal to 3000.
(v) SELECT ANO, ANAME FROM ACCOUNT
WHERE ADDRESS NOT IN ('CHENNAI', 'BANGALORE');
(vi) SELECT DISTINCT ANO FROM TRANSACT;
(vii) SELECT ANO, COUNT(*), MIN(AMOUNT) FROM TRANSACT
GROUP BY ANO HAVING COUNT(*)> 1;
(viii) SELECT COUNT(*), SUM(AMOUNT) FROM TRANSACT
WHERE DOT <= '2017-06-01';
91 20
6. (a) State any one Absorption Law of Boolean Algebra and verify it using
truth table. 2

(b) Draw the Logic Circuit of the following Boolean Expression : 2


(U + V).(V + W)

(c) Derive a Canonical POS expression for a Boolean function FN,


represented by the following truth table : 1
X Y Z FN(X,Y,Z)
0 0 0 1
0 0 1 1
0 1 0 0
0 1 1 0
1 0 0 1
1 0 1 0
1 1 0 0
1 1 1 1

(d) Reduce the following Boolean Expression to its simplest form using
K-Map : 3
G(U,V,W,Z) = (3,5,6,7,11,12,13,15)

7. (a) Differentiate between Bus Topology and Star Topology of Networks.


What are the advantages and disadvantages of Star Topology over
Bus Topology ? 2

(b) Classify each of the following Web Scripting as Client Side Scripting
and Server Side Scripting : 2
(i) Java Scripting
(ii) ASP
(iii) VB Scripting
(iv) JSP

(c) Write the expanded names for the following abbreviated terms used
in Networking and Communications : 2
(i) SMTP
(ii) VoIP
(iii) GSM
(iv) WLL
91 21 P.T.O.
(d) CASE STUDY BASED QUESTION :
Ayurveda Training Educational Institute is setting up its centre in
Hyderabad with four specialised departments for Orthopedics,
Neurology and Pediatrics along with an administrative office in
separate buildings. The physical distances between these
department buildings and the number of computers to be installed
in these departments and administrative office are given as follows.
You, as a network expert, have to answer the queries as raised by
them in (i) to (iv).

Shortest distances between various locations in metres :


Administrative Office to Orthopedics Unit 55
Neurology Unit to Administrative Office 30
Orthopedics Unit to Neurology Unit 70
Pediatrics Unit to Neurology Unit 50
Pediatrics Unit to Administrative Office 40
Pediatrics Unit to Orthopedics Unit 110
Number of Computers installed at various locations are as follows :
Pediatrics Unit 40
Administrative Office 140
Neurology 50
Orthopedics Unit 80

91 22
(i) Suggest the most suitable location to install the main server
of this institution to get efficient connectivity. 1

(ii) Suggest the best cable layout for effective network


connectivity of the building having server with all the other
buildings. 1

(iii) Suggest the devices to be installed in each of these buildings


for connecting computers installed within the building out of
the following : 1
 Gateway
 Modem
 Switch

(iv) Suggest the topology of the network and network cable for
efficiently connecting each computer installed in each of the
buildings out of the following : 1
Topologies : Bus Topology, Star Topology
Network Cable : Single Pair Telephone Cable, Coaxial Cable,
Ethernet Cable

91 23 00
P.T.O.
SECTION B
[Only for candidates, who opted for Python]

1. (a) Write the names of any four data types available in Python. 2

(b) Name the Python Library modules which need to be imported to


invoke the following functions : 1
(i) sqrt()
(ii) start()

(c) Rewrite the following code in python after removing all syntax
error(s). Underline each correction done in the code. 2
250 = Number
WHILE Number<=1000:
if Number=>750:
print Number
Number=Number+100
else
print Number*2
Number=Number+50

(d) Find and write the output of the following python code : 2
Msg1="WeLcOME"
Msg2="GUeSTs"
Msg3=""
for I in range(0,len(Msg2)+1):
if Msg1[I]>="A" and Msg1[I]<="M":
Msg3=Msg3+Msg1[I]
elif Msg1[I]>="N" and Msg1[I]<="Z":
Msg3=Msg3+Msg2[I]
else:
Msg3=Msg3+"*"
print Msg3
91 14
(e) Find and write the output of the following python code : 3

def Changer(P,Q=10):
P=P/Q
Q=P%Q
print P,"#",Q
return P
A=200
B=20
A=Changer(A,B)
print A,"$",B
B=Changer(B)
print A,"$",B
A=Changer(A)
print A,"$",B

(f) What possible output(s) are expected to be displayed on screen at


the time of execution of the program from the following code ? Also
specify the minimum values that can be assigned to each of the
variables BEGIN and LAST. 2

import random

VALUES=[10,20,30,40,50,60,70,80]
BEGIN=random.randint(1,3)
LAST=random.randint(BEGIN,4)

for I in range(BEGIN,LAST+1):
print VALUES[I],"-",

(i) 30 - 40 - 50 - (ii) 10 - 20 - 30 - 40 -

(iii) 30 - 40 - 50 - 60 - (iv) 30 - 40 - 50 - 60 - 70 -

91 15 P.T.O.
2. (a) Write four features of object oriented programming. 2

(b) class Box: #Line 1


L = 10 #Line 2
Type="HARD" #Line 3
def __init__(self,T,TL=30): #Line 4
self.Type = T #Line 5
self.L = TL #Line 6
def Disp(self): #Line 7
print self.Type,Box.Type #Line 8
print self.L,Box.L #Line 9
B1=Box("SOFT",20) #Line 10
B1.Disp() #Line 11
Box.Type="FLEXI" #Line 12
B2=Box("HARD") #Line 13
B2.Disp() #Line 14

Write the output of the above Python code. 2

OR

(b) class Target: #Line 1


def __init__(self): #Line 2
self.X = 20 #Line 3
self.Y = 24 #Line 4
def Disp(self): #Line 5
print self.X,self.Y #Line 6
def __del__(self): #Line 7
print "Target Moved" #Line 8
def One(): #Line 9
T=Target() #Line 10
T.Disp() #Line 11
One() #Line 12

91 16
(i) What are the methods/functions mentioned in Line 2 and
Line 7 specifically known as ?

(ii) Mention the line number of the statement, which will call
and execute the method/function shown in Line 2. 2

(c) Define a class HOUSE in Python with the following specifications : 4

Instance Attributes
- Hno # House Number
- Nor # Number of Rooms
- Type # Type of the House

Methods/function
- AssignType() # To assign Type of House
# based on Number of Rooms as follows :

Nor Type

<=2 LIG

==3 MIG

>3 HIG

- Enter() # To allow user to enter value of


# Hno and Nor. Also, this method should

# call AssignType() to assign Type

- Display() # To display Hno, Nor and Type

91 17 P.T.O.
(d) Answer the questions (i) to (iii) based on the following :
class Furniture(object): #Line 1
def __init__(self,Q): #Line 2
self.Qty = Q
def GetMore(self,TQ): #Line 3
self.Qty =self.Qty+TQ
def FRDisp(self): #Line 4
print self.Qty

class Fixture(object): #Line 5


def __init__(self,TQ): #Line 6
self.Qty=TQ
def GetMore(self,TQ): #Line 7
self.Qty =self.Qty+TQ
def FXDisp(self): #Line 8
print self.Qty

class Flat(Furniture,Fixture): #Line 9


def __init__(self,fno): #Line 10
self.Fno=fno
Q=0
if self.Fno<100:
Q=10
else:
Q=20
Furniture.__init__(self,Q): #Line 11
Fixture.__init__(self,Q): #Line 12
def More(self,Q): #Line 13
Furniture.GetMore(self,Q)
Fixture.GetMore(self,Q)
def FLDisp(self): #Line 14
print self.Fno,
Furniture.FRDisp(self)
Fixture.FXDisp(self)
FL=Flat(101) #Line 15
FL.More(2)
FL.FLDisp()

91 18
(i) Write the type of the inheritance illustrated in the above. 1
(ii) Find and write the output of the above code. 2
(iii) What is the difference between the statements shown in
Line 11 and Line 12 ? 1

OR

(d) Define inheritance. Show brief python example of Single Level,


Multiple and Multilevel Inheritance. 4

3. (a) Consider the following randomly ordered numbers stored in a list :


106, 104, 106, 102, 105, 10
Show the content of list after the First, Second and Third pass of
the selection sort method used for arranging in ascending
order. 3
Note : Show the status of all the elements after each pass very
clearly encircling the changes.

OR

(a) Consider the following randomly ordered numbers stored in a list :


106, 104, 106, 102, 105, 107
Show the content of list after the First, Second and Third pass
of the bubble sort method used for arranging in descending
order. 3
Note : Show the status of all the elements after each pass very
clearly encircling the changes.

(b) Write definition of a method/function AddOddEven(VALUES) to


display sum of odd and even values separately from the list of
VALUES. 3
For example :
If the VALUES contain [15, 26, 37, 10, 22, 13]
The function should display
Even Sum: 58
Odd Sum: 65
OR
91 19 P.T.O.
(b) Write definition of a method/function HowMany(ID,Val) to count
and display number of times the value of Val is present in the list ID. 3
For example :
If the ID contains [115,122,137,110,122,113] and Val contains
122
The function should display
122 found 2 Times

(c) Write QueueUp(Client) and QueueDel(Client) methods/functions


in Python to add a new Client and delete a Client from a List of
Clients names, considering them to act as insert and delete
operations of the Queue data structure. 4
OR
(c) Write PushOn(Book) and Pop(Book) methods/functions in Python
to add a new Book and delete a Book from a List of Book titles,
considering them to act as push and pop operations of the Stack data
structure. 4

(d) Write a python method/function Swapper(Numbers) to swap the


first half of the content of a list Numbers with second half of the
content of list Numbers and display the swapped values. 2
Note : Assuming that the list has even number of values in it.
For example :
If the list Numbers contains
[35,67,89,23,12,45]
After swapping the list content should be displayed as
[23,12,45,35,67,89]
OR
(d) Write a python method/function Count3and7(N) to find and
display the count of all those numbers which are between 1 and N,
which are either divisible by 3 or by 7. 2
For example :
If the value of N is 15
The sum should be displayed as
7
(as 3,6,7,9,12,14,15 in between 1 to 15 are either divisible by 3 or 7)
91 20
(e) Evaluate the following Postfix expression, showing the stack
contents : 2
250,45,9,/,5,+,20,*,-

OR

(e) Convert the following Infix expression to its equivalent Postfix


expression, showing the stack contents for each step of
conversion : 2
A + B * C ^ D - E

4. (a) Write a statement in Python to open a text file WRITEUP.TXT so


that new content can be written in it. 1

OR

(a) Write a statement in Python to open a text file README.TXT so


that existing content can be read from it. 1

(b) Write a method/function ISTOUPCOUNT() in python to read


contents from a text file WRITER.TXT, to count and display the
occurrence of the word ‘‘IS’’ or ‘‘TO’’ or ‘‘UP’’. 2

For example :
If the content of the file is

IT IS UP TO US TO TAKE CARE OF OUR SURROUNDING. IT


IS NOT POSSIBLE ONLY FOR THE GOVERNMENT TO TAKE
RESPONSIBILITY

The method/function should display


Count of IS TO and UP is 6

OR

(b) Write a method/function AEDISP() in python to read lines from a


text file WRITER.TXT, and display those lines, which are starting
either with A or starting with E. 2

91 21 P.T.O.
For example :
If the content of the file is

A CLEAN ENVIRONMENT IS NECESSARY FOR OUR GOOD HEALTH.


WE SHOULD TAKE CARE OF OUR ENVIRONMENT.
EDUCATIONAL INSTITUTIONS SHOULD TAKE THE LEAD.

The method should display


A CLEAN ENVIRONMENT IS NECESSARY FOR OUR GOOD HEALTH.
EDUCATIONAL INSTITUTIONS SHOULD TAKE THE LEAD.

(c) Considering the following definition of class STOCK, write a


method/function COSTLY() in python to search and display Name
and Price from a pickled file STOCK.DAT, where Price of the items
are more than 1000. 3
class Stock :
def __init__(self,N,P):
self.Name=N
self.Price=P
def Show(self):
print self.Name,"@",self.Price
OR
(c) Considering the following definition of class DOCTORS, write a
method/function SPLDOCS() in python to search and display all
the content from a pickled file DOCS.DAT, where Specialisation of
DOCTORS is ‘‘CARDIOLOGY’’. 3
class DOCTORS :
def __init__(self,N,S):
self.Name=N
self.Specialisation=S
def Disp(self):
print self.Name,"#",self.Specialisation

91 22
SECTION C
[For all candidates]

5. Write SQL queries for (i) to (iv) and write outputs for SQL queries (v) to
(viii), which are based on the table given below : 8

Table : TRAINS
TNO TNAME START END
11096 Ahimsa Express Pune Junction Ahmedabad Junction
12015 Ajmer Shatabdi New Delhi Ajmer Junction
1651 Pune Hbj Special Pune Junction Habibganj
13005 Amritsar Mail Howrah Junction Amritsar Junction
12002 Bhopal Shatabdi New Delhi Habibganj
12417 Prayag Raj Express Allahabad Junction New Delhi
14673 Shaheed Express Jaynagar Amritsar Junction
12314 Sealdah Rajdhani New Delhi Sealdah
12498 Shane Punjab Amritsar Junction New Delhi
12451 Shram Shakti Express Kanpur Central New Delhi
12030 Swarna Shatabdi Amritsar Junction New Delhi

Table : PASSENGERS
PNR TNO PNAME GENDER AGE TRAVELDATE
P001 13005 R N AGRAWAL MALE 45 2018-12-25
P002 12015 P TIWARY MALE 28 2018-11-10
P003 12015 S TIWARY FEMALE 22 2018-11-10
P004 12030 S K SAXENA MALE 42 2018-10-12
P005 12030 S SAXENA FEMALE 35 2018-10-12
P006 12030 P SAXENA FEMALE 12 2018-10-12
P007 13005 N S SINGH MALE 52 2018-05-09
P008 12030 J K SHARMA MALE 65 2018-05-09
P009 12030 R SHARMA FEMALE 58 2018-05-09

NOTE : All Dates are given in ‘YYY-MM-DD’ format.


91 23 P.T.O.
(i) To display details of all Trains which Start from New Delhi.
(ii) To display the PNR, PNAME, GENDER and AGE of all
Passengers whose AGE is below 50.
(iii) To display total number of MALE and FEMALE Passengers.
(iv) To display details of all Passengers travelling in Trains
whose TNO is 12015.
(v) SELECT MAX (TRAVELDATE), MIN(TRAVELDATE) FROM
PASSENGERS WHERE GENDER = 'FEMALE';
(vi) SELECT END, COUNT(*) FROM TRAINS
GROUP BY END HAVING COUNT(*)>1;
(vii) SELECT DISTINCT TRAVELDATE FROM PASSENGERS;
(viii) SELECT TNAME, PNAME FROM TRAINS T, PASSENGERS P
WHERE T.TNO = P.TNO AND AGE BETWEEN 50 AND 60;

6. (a) State any one Distributive Law of Boolean Algebra and verify it
using truth table. 2

(b) Draw the Logic Circuit of the following Boolean Expression : 2


A.B + A.C

(c) Derive a Canonical POS expression for a Boolean function F,


represented by the following truth table : 1
X Y Z F(X,Y,Z)
0 0 0 1
0 0 1 0
0 1 0 1
0 1 1 0
1 0 0 1
1 0 1 1
1 1 0 0
1 1 1 0

(d) Reduce the following Boolean Expression to its simplest form using
K-Map : 3
F(P,Q,R,S) = (0,1,2,3,5,6,7,10,14,15)
91 24
7. (a) Damodar Mohan has been informed that there had been a backdoor
entry to his computer, which has provided access to his system
through a malicious user/programs, allowing confidential and
personal information to be subjected to theft. It happened because
he clicked a link provided in one of the pop-ups from a website
announcing him to be winner of prizes worth 1 Million Dollars.
Which of the following has caused this out of the following ?
(i) Virus
(ii) Worm
(iii) Trojan Horse
Also, mention, what he should do to prevent this infection. 2

(b) Tarini Wadhawa is in India and she is interested in communicating


with her uncle in Australia. She wants to show one of her own
designed gadgets to him and also wants to demonstrate its working
without physically going to Australia. Which protocol out of the
following will be ideal for the same ? 1
(i) POP3
(ii) SMTP
(iii) VoIP
(iv) HTTP

(c) Give two differences between 3G and 4G telecommunication


technologies. 1

(d) Write the expanded names for the following abbreviated terms used
in Networking and Communications : 2
(i) MBPS
(ii) WAN
(iii) CDMA
(iv) WLL
91 25 P.T.O.
(e) Jonathan and Jonathan Training Institute is planning to set up its
centre in Amritsar with four specialised blocks for Medicine,
Management, Law courses alongwith an Admission block in
separate buildings. The physical distances between these blocks and
the number of computers to be installed in these blocks are given
below. You as a network expert have to answer the queries as raised
by their board of directors as given in (i) to (iv).

Shortest distances between various locations in metres :

Admin Block to Management Block 60


Admin Block to Medicine Block 40
Admin Block to Law Block 60
Management Block to Medicine Block 50
Management Block to Law Block 110
Law Block to Medicine Block 40

Number of Computers installed at various locations are as follows :

Admin Block 150


Management Block 70
Medicine Block 20
Law Block 50

91 26
(i) Suggest the most suitable location to install the main server
of this institution to get efficient connectivity. 1

(ii) Suggest the devices to be installed in each of these buildings


for connecting computers installed within the building out of
the following : 1
 Modem
 Switch
 Gateway
 Router

(iii) Suggest by drawing the best cable layout for effective


network connectivity of the blocks having server with all the
other blocks. 1

(iv) Suggest the most suitable wired medium for efficiently


connecting each computer installed in every building out of
the following network cables : 1
 Co-axial Cable
 Ethernet Cable
 Single Pair Telephone Cable

91 27 P.T.O.

You might also like