aglasem.com
Schools Admission Mock Test Playground
ClassChoose class
StateSelect state

CBSE Class 12 Computer Science Question Paper 2019

CBSE Previous Year Question Papers for Class 12 for Computer Science are given here for Year 2019. You can download CBSE Class 12 Question Papers 2019 from AglaSem for Free. More Detail
CBSE Class 12 Computer Science Question Paper 2019 - Page 1 of 27

Finished viewing? Save it for later —

Download CBSE Class 12 Computer Science Question Paper 2019 (PDF · 27 pages)
Downloaded 66 times

About CBSE Class 12 Computer Science Question Paper 2019

CBSE Class 12 Computer Science Question Paper 2019 is available here for free download. Published by CBSE for Class 12, this question paper can be viewed online or downloaded as a PDF (27 pages). Candidates preparing for Class 12 can use CBSE Class 12 Computer Science Question Paper 2019 to understand the exam pattern, the type of questions asked, and the overall difficulty level.

Frequently Asked Questions

How can I download CBSE Class 12 Computer Science Question Paper 2019?

Open this page and click the Download button to save CBSE Class 12 Computer Science Question Paper 2019 as a PDF. It is completely free on AglaSem Docs.

Is CBSE Class 12 Computer Science Question Paper 2019 free to download?

Yes. CBSE Class 12 Computer Science Question Paper 2019 can be viewed online and downloaded as a PDF free of cost on AglaSem Docs.

How many pages does CBSE Class 12 Computer Science Question Paper 2019 have?

CBSE Class 12 Computer Science Question Paper 2019 contains 27 pages, which you can read online or download together as a single PDF.

Where can I find more Class 12 study material?

You can find more Class 12 question papers, sample papers, syllabus, and answer keys on AglaSem Docs.

CBSE Class 12 Computer Science Question Paper 2019 – Text

Read the full text of this question paper below — useful to quickly search, copy and reference the content online without downloading the PDF.

📄 View text version (27 pages)

Page 1

SET-4
Series BVM Code No. 91
Candidates must write the Code on the
Roll No.
title page of the answer-book.

 Please check that this question paper contains 27 printed pages.
 Code number given on the right hand side of the question paper should be
written on the title page of the answer-book by the candidate.
 Please check that this question paper contains 7 questions.
 Please write down the Serial Number of the question before
attempting it.
 15 minute time has been allotted to read this question paper. The question
paper will be distributed at 10.15 a.m. From 10.15 a.m. to 10.30 a.m., the
students will read the question paper only and will not write any answer on the
answer-book during this period.

COMPUTER SCIENCE

Time allowed : 3 hours Maximum Marks : 70

General Instructions :
(i) SECTION A refers to programming language C++.
(ii) SECTION B refers to programming language Python.
(iii) SECTION C is compulsory for all.
(iv) Answer either SECTION A or SECTION B.
(v) It is compulsory to mention on the page 1 in the answer-book whether you
are attempting SECTION A or SECTION B.
(vi) All questions are compulsory within each section.
(vii) Questions 2(b), 2(d), 3 and 4 have internal choices.

91 1 P.T.O.

Page 2

SECTION A
[Only for candidates, who opted for C++]
1. (a) Write the names of any four fundamental data types of C++. 2
(b) Write the names of the correct header files, which must be included
in the following C++ code to compile the code successfully : 1
void main()
{
char L[]="CS 2018";
int N=strlen(L);
cout<<L[N-1];
}
(c) Rewrite the following C++ program after removing any/all
syntactical error(s). Underline each correction done in the code : 2
Note : Assume all required header files are already included in the
program.
#define Area(L,B) = L*B
structure Recta
{
int Length,Breadth;
};
void main()
{
Recta R = [10,15];
cout<<Area(Length.R,Breadth.R);
}
(d) Find and write the output of the following C++ program code : 2
Note : Assume all required header files are already included in the
program.
void Alter(char *S1, char *S2)
{
char *T;
T=S1;
S1=S2;
S2=T;
cout<<S1<<"&"<<S2<<end1;
}
void main()
{
char X[]="First", Y[]="Second";
Alter(X,Y);
cout<<X<<"*"<<Y<<end1;
}
91 2

Page 3

(e) Find and write the output of the following C++ program code : 3
Note : Assume all required header files are already included in the
program.

void Convert(float &X, int Y=2)
{
X=X/Y;
Y=X+Y;
cout<<X<<"*"<<Y<<endl;
}
void main()
{
float M=15, N=5;
Convert(M,N);
Convert(N);
Convert(M);
}

(f) Observe the following C++ code and find the possible output(s) from
the options (i) to (iv) following it. Also, write the minimum and
maximum values that can possibly be assigned to the variable End. 2
Note :
 Assume all the required header files are already being included in
the code.
 The function random(N) generates any possible integer between
0 and N-1 (both values included).

void main()
{
randomize();
int A[]={10,20,30,40,50,60,70,80};
int Start = random(2) + 1;
int End = Start + random(4);
for(int I=Start; I<=End, I++)
cout<<A[I]<<"$";
}

(i) 10$20$30$ (ii) 20$30$40$50$60$

(iii) 30$40$50$60$ (iv) 40$50$60$70$
91 3 P.T.O.

Page 4

2. (a) Given the following class Test and assuming all necessary header
file(s) included, answer the questions that follow the code :
class Test
{
int Marks; char TName[20];
public:
Test(int M) //Function 1
{
Marks = M;
}
Test(char S[]) //Function 2
{
strcpy(TName,S);
}
Test(char S[], int M) //Function 3
{
Marks = M;
strcpy(TName,S);
}
Test(Test &T) //Function 4
{
Marks = T.Marks + 10;
strcpy(TName,T.TName);
}
};

void main()
{
Test T1(10); //Statement I
Test T2(70); //Statement II
Test T3(30, "PRACTICAL"); //Statement III
_______________; //Statement IV
}

(i) Which of the statement(s) out of (I), (II), (III), (IV) is/are
incorrect for object(s) of the class Test ? 1

(ii) What is Function 4 known as ? Write the Statement IV,
that would execute Function 4. 1

91 4

Page 5

(b) Observe the following C++ code and answer the questions (i) and (ii).
Note : Assume all necessary files are included.

class Point
{
int X,Y;
public:
Point(int I=10, int J=20) //Function 1
{
X = J;
Y = I;
}
void Show() //Function 2
{
cout<< " Points are " << X << " & " << Y <<endl;
}
~Point() //Function 3
{
cout<<"Points Erased"<<endl;
}
};

void main()
{
Point P(5);
P.Show();
}

(i) For the class Point, what is Function 3 known as ? When is
it executed ? 1

(ii) What is the output of the above code, on execution ? 1

OR

(b) Explain Polymorphism in context of Object Oriented Programming.
Also give a supporting example in C++. 2

91 5 P.T.O.

Page 6

(c) Write the definition of a class GRAPH in C++ with following
description : 4

Private Members

 XUnit // integer

 YUnit // integer

 Type // char array of size 20

 AssignType() /* Member function to assign value of

Type based upon XUnit and YUnit as

follows : */

Condition Type

XUnit = 0 Or YUnit = 0 None

XUnit is more than YUnit Bar

XUnit is less than or equal to YUnit Line

Public Members

 InXY() /* Function to allow user to enter values

of XUnit and YUnit and then invoke

AssignType() to assign value of Type */

 OutXY() // Function to display XUnit, Yunit and Type

91 6

Page 7

(d) Answer the questions (i) to (iv) based on the following : 4
class Ground
{
int Rooms;
protected:
void Put();
public:
void Get();
};

class Middle : private Ground
{
int Labs;
public:
void Take();
void Give();
};

class Top : public Middle
{
int Roof;
public:
void In();
void Out();
};

void main()
{
Top T;
}
(i) Which type of Inheritance out of the following is illustrated
in the above example ?
 Single Level Inheritance, Multilevel Inheritance,
Multiple Inheritance
(ii) Write the names of all the members, which are directly
accessible by the member function Give() of class Middle.
(iii) Write the names of all the members, which are directly
accessible by the member function Out() of class Top.
(iv) Write the names of all the members, which are directly
accessible by the object T of class Top declared in the main()
function.
OR
91 7 P.T.O.

Page 8

(d) Consider the following class HeadQuarter 4
class HeadQuarter
{
int Code;
char Des[20];
protected :
char Address[40];
public:
void Get(){cin>>Code;gets(Des);gets(Address);}
void Put(){cout<<Code<<Des<<Address<<endl;}
};
Write a code in C++ to protectedly derive another class FrontOffice
from the base class HeadQuarter with following members.
Data Members
Location of type character of size 10
Budget of type double
Member Functions
A constructor function to assign Budget as 100000
Assign() to allow user to enter Location and Budget
Display() to display Location and Budget

3. (a) Write a user-defined function NoTwoThree(int Arr[], int N) in
C++, which should display the value of all such elements and their
corresponding locations in the array Arr (i.e. the array index), which
are not multiples of 2 or 3. N represents the total number of
elements in the array Arr, to be checked. 3
Example : If the array Arr contains

0 1 2 3 4
25 8 12 49 9

Then the function should display the output as :
25 at location 0
49 at location 3

OR

91 8

Page 9

(a) Write a user-defined function ReArrange(int Arr[], int N) in C++,
which should swap the contents of the first half locations of the
array Arr with the contents of the second half locations. N (which is
an even integer) represents the total number of elements in the
array Arr. 3
Example :
If the array Arr contains the following elements (for N = 6)

0 1 2 3 4 5
12 5 7 23 8 10

Then the function should rearrange the array to become

0 1 2 3 4 5
23 8 10 12 5 7
NOTE :
 DO NOT DISPLAY the Changed Array contents.
 Do not use any other array to transfer the contents of array Arr.

(b) Write definition for a function XOXO(char M[4][4]) in C++, which
replaces every occurrence of an X with an O in the array, and vice
versa. 2
For example :

ORIGINAL ARRAY M CHANGED ARRAY M

X X O X O O X O

O X O O X O X X

O O X X X X O O

X X O O O O X X

NOTE :
 DO NOT DISPLAY the Changed Array contents.
 Do not use any other array to transfer the contents of array M.

OR
91 9 P.T.O.

Page 10

(b) Write definition for a function ColSwap(int A[4][4]) in C++, which
swaps the contents of the first column with the contents of the third
column. 2
For example :

ORIGINAL ARRAY A CHANGED ARRAY A

10 15 20 25 20 15 10 25

30 35 40 45 40 35 30 45

50 55 60 65 60 55 50 65

70 75 80 85 80 75 70 85

NOTE :
 DO NOT DISPLAY the Changed Array contents.

 Do not use any other array to transfer the contents of array A.

(c) Let us assume P[20][10] is a two-dimensional array, which is stored
in the memory along the row with each of its elements occupying
2 bytes, find the address of the element P[10][5], if the address of the
element P[5][2] is 25000. 3

OR

(c) Let us assume P[20][30] is a two-dimensional array, which is stored
in the memory along the column with each of its elements occupying
2 bytes. Find the address of the element P[5][6], if the base address
of the array is 25000. 3

91 10

Page 11

(d) Write a user-defined function Pop(Book B[], int &T), which pops
the details of a Book, from the static stack of Book B, at the location
T (representing the Top end of the stack), where every Book of the
stack is represented by the following structure : 4
struct Book
{
int Bno;
char Bname[20];
};
OR
(d) For the following structure of Books in C++
struct Book
{
int Bno;
char Bname[20];
Book *Link;
};
Given that the following declaration of class BookStack in C++
represents a dynamic stack of Books :
class BookStack
{
Book *Top; //Pointer with address of Topmost Book
of Stack
public:
BookStack()
{
Top = NULL;
}
void Push(); //Function to push a Book into the
dynamic stack
void Pop(); //Function to pop a Book from the
dynamic stack
~BookStack();
};
Write the definition for the member function void
BookStack::Push(), that pushes the details of a Book into the
dynamic stack of BookStack. 4
91 11 P.T.O.

Page 12

(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) A text file named MESSAGE.TXT contains some text. Another text
file named SMS.TXT needs to be created such that it would store
only the first 150 characters from the file MESSAGE.TXT.
Write a user-defined function LongToShort() in C++ that would
perform the above task of creating SMS.TXT from the already
existing file MESSAGE.TXT. 3
OR
(a) A text file named CONTENTS.TXT contains some text. Write a
user-defined function LongWords() in C++ which displays all
such words of the file whose length is more than 9 alphabets. For
example : if the file CONTENTS.TXT contains :
"Conditional statements of C++ programming language
are if and switch" 3
Then the function LongWords() should display the output as :
Conditional
statements
programming
(b) Write a user-defined function TotalPrice() in C++ to read each object
of a binary file STOCK.DAT, and display the Name from all such
records whose Price is above 150. Assume that the file STOCK.DAT
is created with the help of objects of class Stock, which is defined
below : 2
class Stock
{
char Name[20]; float Price;

public:
char* RName() { return Name; }
float RPrice() { return Price; }
};
OR

91 12

Page 13

(b) A binary file DOCTORS.DAT contains records stored as objects of
the following class :
class Doctor
{
int DNo; char Name[20]; float Fees;
public:
int *GetNo() { return DNo; }
void Show()
{ cout<<Dno<<" * " <<Name<< " * " <<Fees<<endl;}
};
Write definition for function Details(int N) in C++, which displays
the details of the Doctor from the file DOCTORS.DAT, whose DNo
matches with the parameter N passed to the function. 2
(c) Find the output of the following C++ code considering that the
binary file STOCK.DAT exists on the hard disk with the following
5 records for the class STOCK containing Name and Price. 1
Name Price
Rice 110
Wheat 60
Cheese 200
Pulses 170
Sauce 150
void main()
{ fstream File
File.open("STOCK.DAT",ios::binary|ios::in);
Stock S;
for (int I=1; I<=2; I++)
{
File.seekg((2*I-1)*sizeof(S));
File.read((char*)&S, sizeof(S));
cout << "Read : " << File.tellg()/sizeof(S)<< endl;
}
File.close();
}
OR

(c) Differentiate between seekg() and tellg(). 1

91 13 P.T.O.

Page 14

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

Page 15

(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.

Page 16

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

Page 17

(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.

Page 18

(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

Page 19

(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.

Page 20

(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

Page 21

(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.

Page 22

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

Page 23

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.

Page 24

(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

Page 25

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.

Page 26

(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

Page 27

(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.

Document Details

Board / OrgCBSE
ExamClass 12
TypeQuestion Paper
Pages27
Updated30 Apr 2026