Sample Papers 230-311 PDF

KENDRIYA VIDYALAYA SANGHATHAN – ERNAKULAM REGION
SAMPLE PAPER-1(SOLVED) – COMPUTER SCIENCE (083)
MAX MARKS: 70 TOTAL TIME : 3 hrs
General Instructions:
1.This question paper contains five sections, Section A to E.
2. All questions are compulsory.

3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q34 against part
c only.
8. All programming questions are to be answered using Python Language only.
Part A
Section 1 [18 marks] (1x18)( attempt any 18)
1. Which of the following symbols are used for comments in Python? 1
(A) // (B) & (C) /**/ (D) #

2. Suppose str=”computer science with python” .What will be the output of 1
print(type(str))
(a)int (b) bool (c) string (d)str
3. The RDBMS terminology for a row is 1
(a) Tuple (b) relation (c) attribute (d) degree
4. ____________Spans over less than a Kilometer 1

a)MAN b)LAN c)WAN d)All of the above
5. The act which governs the cyber transactions in India is_______________ 1

a)IT act 2000 b)IT act 2008 c)IT act 2003 d)None of these
6. A network device used to divide a single computer network into various sub- 1
networks . i)router ii)switch ii)hub iv)R
7. With SQL, how do you select all the records from a table named “Persons” 1
where the value of the column “FirstName” ends with an “a”?
a) SELECT * FROM Persons WHERE FirstName=’a’
b) SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
c) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
d) SELECT * FROM Persons WHERE FirstName=’%a%’.
KVS RO EKM - STUDENT SUPPORT MATERIAL (COMPUTER SCIENCE-083) FOR THE ACADEMIC YEAR 2022-23 223
8. Which of the following is not a DDL command? 1
a) UPDATE b) TRUNCATE c) ALTER d) None of the Mentioned
9. To include the use of functions which are present in the random library, we 1
must use the option:
a) import random
b) random.h
c) import.random
d) random.random
10. How many values can be returned by a function in python? 1

a) 0 b) 1 c) more than one d) 2
11. print (id(x)) will print_______. 1

1. Value of x 2. Datatype of x 3. Size of x 4. Memory address of x
12. Which of the following command is used to change the VALUES OF rows that 1
already exist in a table?
1. Insert. 2. Union. 3. Update. 4. Select
13. Give the output: my_data = (1, 2, "Kevin", 8.9) print (my_data[-3]) 1
1. 8.9 2. “Kevin”. 3. 1 4. 2
14. Suppose list1 is [1, 3, 2], What is list1 * 2 ? 1

a) [2, 6, 4]. b) [1, 3, 2, 1, 3]. c) [1, 3, 2, 1, 3, 2] . d) [1, 3, 2, 3, 2, 1]
15. The readlines() method returns 1

a) str b) a list of lines c) a list of single characters d) a list of
integers
16 To write data into CSV from python console, which of the following function is 1
correct?
a) csv.write(file) b) csv.writer(file)
c) csv.Write(file) d) csv.writerow()
Statement (A) : A function can perform certain functionality 1

17 Statement (B) : A function must return a result value
a) Statement A is correct
b) Statement B is correct
c) Statement A is correct but Statement B is not correct
d) Both are incorrect
18 Ms. Suman is working on a binary file and wants to write data from a list to a 1
binary file. Consider list object as l1, binary file suman_list.dat, and file object as
f. Which of the following can be the correct statement for her?
a) f = open(‘sum_list’,’wb’); pickle.dump(l1,f)
b) f = open(‘sum_list’,’rb’); l1=pickle.dump(f)
c) f = open(‘sum_list’,’wb’); pickle.load(l1,f)
d) f = open(‘sum_list’,’rb’); l1=pickle.load(f)
Section B [14 marks] [2x7=14]

Answer All questions
19 Evaluate the following expressions: 2
a) 6+7*4+2**3//5-8
b) 8<5 or no 19<=20 and 11<4
20 Write down the fullform of : 2

POP b) TCP/IP c) WWW d) HTTPS
21 Differentiate between Candidate Key and Primary Key in the context Relational 2
Database Mode
22 What will be the output of the following code? 2

a=[1,2,3,4]
s=0
for a[-1] in a:
print(a[-1])
s+=a[-1]
print(‘sum=’,s)
23 Difference between ALTER & UPDATE commands. 2

24 Smridh has recently changed his school so he is not aware of the people, but 2
someone is posting negative , demeaning comments on his social media profile.
He is also getting repeated mails from unknown people. Every time he goes
online, he finds someone chasing him online.
i. Smridh is a victim of …………

ii. The act of fraudulently acquiring someone’s personal and private information,
such as online account names, login information and passwords is called as
……………
25 In the table Loan below 2
(a) Identify the candidate key(s) from the table Garment.
(b) What is the cardinality and degree of the table?
Section C [15 Marks] [3x5]

26 Vedika has created a dictionary containing names and marks as key-value pairs 3
of 5 students. Write a program, with separate user-defined functions to perform
the following operations:
Push the keys (name of the student) of the dictionary into a stack, where the
corresponding value (marks) is greater than 70.
Pop and display the content of the stack.
The dictionary should be as follows:
d={“Ramesh”:58, “Umesh”:78, “Vishal”:90, “Khushi”:60, “Ishika”:95}
Then the output will be: Umesh Vishal Ishika
27. A department is considering to maintain their worker data using SQL to store the 3
data. As a database administer, Karan has decided that :
Name of the database - Department

Name of the table - WORKER
The attributes of WORKER are as follows:

WORKER_ID - character of size 3
FIRST_NAME – character of size 10
LAST_NAME– character of size 10
SALARY - numeric
JOINING_DATE – Date
DEPARTMENT – character of size 10
I)Identify the attribute best suitable to be declared as a primary key

II) Karan wants to increase the size of the FIRST_NAME column from 10 to 20
characters. Write an appropriate query to change the size.
III) Karan wants to remove all the data from table WORKER from the database
Department.
Which command will he use from the following:
i) DELETE FROM WORKER;

ii) DROP TABLE WORKER;
iii) DROP DATABASE Department;
iv) DELETE * FROM WORKER
28. Ashok Kumar of class 12 is writing a program to create a CSV file “cust.csv” with 3
custid, custname and mobile no and search custname and delete the record. He
has written the following code. As a programmer, help him to successfully
execute the given task.
import _______ # LINE1
record = list()
custname= input("Please enter a customer name to delete:")
with open('cust.csv', 'r') as f:
data = csv._______(f) # LINE2
for row in data:
record.append(row)
for field in row:
if field == custname:
record.____(row) #LINE3
with open('cust.csv', 'w') as f:
writer = csv.writer(f)
writer.writerows(record
A) Name the module he should import in Line 1.

b) Write a code to read the fields (column heading) once from fields list in
Line2.
(c) Write a code to delete the row from row list in Line3.
29. Write SQL commands for(a) to (b) and write the outputs for (C) on the basis of 2+1
table GRADUATE
a) List the names of those students who obtained DIV 1 sorted by NAME .
b )Display a report, listing NAME , STIPEND , SUBJCT and amount of stipend
received in a year assuming that the STIPEND is paid every month.
C.) Give the output of the following SQL statements based on table GRADUATE :
(i) Select MIN(AVERAGE ) from GRADUATE where SUBJECT=”PHYSICS”;
(ii)Select SUM(STIPEND) from GRADUATE where DIV=1;
30 A) Write a function countmy() in Python to read the text file "DATA.TXT" and 3
count the number of times "my" occurs in the file.
For example, if the file "DATA.TXT" contains "This is my website. I have displayed
my preferences in the CHOICE section." - the countmy() function should display
the output as: "my occurs 2 times"Or
Write a method/function DISPLAYWORDS() in python to read lines from a text
file STORY.TXT, and display those words, which are less than 4 characters.
Or
A) Write a method/function DISPLAYWORDS() in python to read lines

from a text file STORY.TXT,and display those words, which are less than 4
characters
Section D [15 Marks]

[5x3]
31. Indian School, in Mumbai is starting up the network between its different wings. 5
There are four Buildings named as SENIOR, JUNIOR, ADMIN and HOSTEL as
shown below:
The distance between various buildings is as follows
1. Suggest the cable layout of connections between the buildings. (1)

2. Suggest the most suitable place (i.e., building) to house the server of this
school, provide a suitable reason. (1)
3. Suggest the placement of the following devices with justification. (2)
a. Repeater b.Hub/Switch
4. The organisation also has inquiry office in another city about 50-60 km
away in hilly region. Suggest the suitable transmission media to interconnect
to school and inquiry office out of the following : (1)
a) Fiber optic cable

b) Microwave
c) Radiowave
32. Give Output of : 5

(2+3)
def Change (P, Q = 30) :

P=P+Q
Q=P-Q
print (P,"@",Q)
return P
R =150
S= 100
R=Change(R, S)
print(R,"@",S)
S=Change (S)
1. The books table of test database contains the records shown below:-
Title ISBN
Die to Live 78127873915
Again? 23686286243
Ushakaal 12678987036
Ushakiran 42568987036
What will be the output produced by following code:
import mysql.connector as sqltor.

conn = sqltor.connect (host = "localhost", user = "learner", passwd = "fast",
database = "test")
cursor = conn.cursor()
cursor.execute("SELECT * FROM books")
row = cursor.fetchone()
while row is not None:
print (row)
row = cursor.fetchone()
33 A. Considering the following definition of dictionary MULTIPLEX, write a method 5
in python to search and display all the content in a pickled file CINEMA.DAT,
where MTYPE key of the dictionary is matching with the value "Comedy".
MULTIPLEX = {'MNO': _____, 'MNAME": _____, 'MTYPE': _____}
Or
Following is the structure of each record in a data file named "phonebook.DAT".
{“name”: value, "phone": value}
Write a program to edit the phone number of “Arvind” infile “phonebook.dat”. If
there is no record for “Arvind”, report error.
34 Write SQL commands for the queries (i) to (iii) and output for (iv) & (vii) based 4
on a
table COMPANY and CUSTOMER
I) Identify the most appropriate Primary key for Tables Company and Customer.
Ii) To display those company name which are having prcze less than 30000.
iii a.To increase the price by 1000 for those customer whose name starts with S?
b) What is the cardinality and degree of table customer?
Or
Iii)a) Delete the records from table customer whose name has KUMAR.
B. Insert a new record in table COmpany where CID : 777, Name : APPLE City
KOCHI and PRODUCTNAME is LAPTOP
35 Aradhana is creating a binary file student.dat that has structure 4
(rollno,name,class,percentage). She wrote a program to updating a record in
the file requires roll number to be fetched from the user whose name is to be
updated. She has few doubts in the code. Help her to complete the task. She
uses intermediate file for working temp.dat
Import______ #STATEMENT 1
import os
f1 = open(‘student.dat','rb')
f2=open(“temp.dat”,”______”) #Statement2
r=int(input(“enter rollno which you want to search”))
try:
while True:
e = pickle.load(f1)
if e[0]==r:
e[1]=input(“enter name”)
pickle.dump(____) #Statement3
else:
pickle.dump(e,f2)
except:
f1.close()
f2.close()
os.remove(“student.dat”)
os._______(“temp.dat”,”student,dat”) #Statement4
(i) Which module should be imported in the program? (Statement 1)

(ii) Write the correct statement required to open a temporary file named
temp.dat. (Statement 2)
(iii) ) Which statement should Aradhana fill in Statement 3 to write the data
to the binary filedat
(iv) Statement 4 to write the rename temp.dat to student.dat?
SAMPLE PAPER-1(SOLUTION) – COMPUTER SCIENCE (083)
Part A
Section 1 [18 marks] (1x18)
1. (a) // 1
2. (d)str 1
3. (a) Tuple 1
4. b)LAN 1
5. a)IT act 2000 1
6. ii)switch 1
7. c) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’ 1
8. a) UPDATE 1
9. a) import random 1
10. c) more than one 1
11. 4. Memory address of x 1
12 3. Update. 1
13. 4. 2 1
14. c) [1, 3, 2, 1, 3, 2] . 1
15. b) a list of lines 1
16. 1
b) csv.writer(file)
17 1
c) Statement A is correct but Statement B is not correct
18 1
a) f = open(‘sum_list’,’wb’); pickle.dump(l1,f)
Section B [2x7=14]
19 a) 27 b) False 2
20 a) Post Office Protocol b)Transmission Control Protocol/Internet 2
Protocol c) World Wide Web
d) Hypertext Transfer Protocol Secure
21 Candidate Key: The columns which can serve as primary key of a table 2
is known as candidate keys. There can be multiple candidate for a
relation.
Primary Key: Primary key is a field name which identifies rows
uniquely. There can be only one primary key for a relation.
22 1 2
2
3
3
Sum=9
23 ALTER Command is used to add, delete, modify the attributes of the 2
relations (tables) in the database. UPDATE Command is used to update
existing records in a database.
24 i)Cyber stalking ii)Phishing 2
25 a) GCODE, GNAME, b) Degree=5 & Cardinality=6 2
26 def push(stk,item): 3
stk.append(item)
def Pop(stk):
if stk==[]:
return None
else:
return stk.pop()
stk=[]
d={"Ramesh":58, "Umesh":78, "Vishal":90, "Khushi":60, "Ishika":95}
for i in d:
if d[i]>70:
push(stk,i)
while True:
if stk!=[]:
print(Pop(stk),end=" ")
else:
break
27 I) WORKER_ID 3
II)alter table worker modify FIRST_NAME varchar(20);
lll)DELETE FROM WORKER;
28. a) csv 3
.b) reader
.c) remove
29 A. List the names of those students who obtained DIV 1 sorted by 2+1
NAME .
Ans.: SELECT name FROM graduate WHERE div=1 ORDER BY name;
(b )Display a report, listing NAME , STIPEND , SUBJCT and amount of
stipend received in a year
assuming that the STIPEND is paid every month.
Ans.: SELECT name, stipend, subject, stipend *12 FROM graduate;
(C) Give the output of the following SQL statements based on table
GRADUATE :
(i) Select MIN(AVERAGE ) from GRADUATE where SUBJECT=”PHYSICS”;
Ans. MIN(AVERAGE)
----------------------
63
(ii)Select SUM(STIPEND) from GRADUATE where DIV=1;
Ans.: SUM(STIPEND)
---------------------
1000
30 A) 3
def countmy ():
f = open("DATA.txt", "r")
count = 0
x = f.read()
word = x.split()
for i in word :
if (i == "my") :
count = count + 1
print ("my occurs", count, "times")
A. close()
Or
ii) )
def DISPLAYWORDS() :
file = open("story.txt", "r")
lst = file.readlines()
for i in lst :
word = i.split()
for j in word :
if len( j ) < 4 :
print( j )
file.close()
print("Word with length smaller than 3 :- \n")
DISPLAYWORDS()
SectionD [15 Marks]

[5x3]
31. 5
1.
2. Server can be placed in the ADMIN building as it has the maxium
number of computer.
3. (a) Repeater can be placed between ADMIN and SENIOR and
ADMIN and JUNIOR building as the distance is more than 80 m.
(b) Hub/Switch : can be placed in all building in order to connect the
computer within
4. Radiowaves can be used in hilly regions as they can travel through
obstacles
32 b) 2+3
250 @ 150
250 @ 100
130 @ 100
c)
(Die to Live 78127873915)
(Again? 23686286243)
(Ushakaal 12678987036)
(ushakiran 42568987036)
33. A.) def Search(): 5

file = open('CINEMA.DAT', "rb")
try:
while True:
MULTIPLEX = pickle.load(file)
if MULTIPLEX ["MTYPE"] == "Comedy":
print (MULTIPLEX)
except EOFError:
file.close()
Or
B.) Try = 0
f = open("phonebook.det","r")
data = f.readlines()
f.close()
f = open("phonebook.det","w")
name = input("Enter name which you want search :-")
for i in range(len(data)) :
line = data[ i ] . split()
if line[0] == name :
phone = input("Enter new Phone :-")
data[ i ] = name + " " + phone
Try = 1
if Try != 1 :
print("Try again !!!!! ")
for i in range(len(data)) :
line = data[ i ] . split()
for j in line :
f.write( j + "\t")
f.write("\n")
f.close()
print("Thankyou")
Section E [8 Marks]
[4x2]
34 1)CID for Company and CUSTID for CUtomer 4
II) Select company.Name from company , Customer where

company.cid=customer.cid and price <30000
III) a. update customer set price=price+1000 where name like ‘S%’
b) cardinality : 7 degree : 5
Or
III a. delete from Customer where name like “ %Kumar%’
B) Insert into COMPANY values( 777,’APPLE’, ‘OCI’,”LAPTOP’)
35 (v) pickle 4
(vi) Wb
(vii) pickle.dump(e,f2)
(viii) .rename()
KENDRIYA VIDYALAYA SANGATHAN ERNAKULAM REGION
CLASS XII SAMPLE PAPER-2 2022-23 (SOLVED)
Subject: COMPUTER SCIENCE (083)

Time Allotted: 3 HRS Max Marks: 70
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is
given in Q35 against part c only.
QNo. Section-A Marks
1 Find the invalid identifier from the following 1
a) sub%marks b)age c)_subname_ d)subject1
2 Given the list L=[“A”, “E”, “I”, “O”, “U”] , write the output of print(L[2:5]) 1
3 Which module is required to work with CSV files in Python? 1
4 Identify the invalid logical operator in Python from the following. 1
a) and b) or c) by d) not
5 Suppose a tuple K is declared as K = (100, 102, 143, 309), which of the 1
following is incorrect?
a)print(K[-1])
b) K[3] =405
c) print(min(K))
d) print(max(K))
6 Write a statement in Python to declare a dictionary whose keys are 1
Sub1, Sub2, Sub3 and values are Physics, Chemistry, Math
respectively.
7 A List is declared as 1
List1=[2,3,5,7,9,11,13]
What will be the value of len(List1)
8 Name the built-in mathematical function / method that is used to 1
return the smallest integer less than or equal to N.
9 Name the protocol that is used to transfer files. 1
10 Ms. Priya is an IT expert. She recently used her skills to access the Admin 1
password for the network server of Happiest Minds Technology Ltd.
and provided confidential data of the organization to its CEO, informing
him about the vulnerability of their network security. Out of the
following options which one most appropriately defines Ms. Priya?
a) Cracker b) Operator c) Hacker d) Network Admin
11 In SQL, name the clause that is used to sort the records in 1
ascending/descending order of an attribute.
12 In SQL, what is the use of IS NOT NULL operator? 1
13 Name the aggregate function to find the average value in SQL. 1
14 Which of the following is not a DDL command? 1
a) UPDATE b)ALTER TABLE c)CREATE TABLE d)DROP TABLE
15 Name the transmission media best suitable for difficult terrain like hilly 1
areas.
16 Identify the data type of INFO: 1
INFO = ['hello',203,'9',[5,6]]
a. Dictionary b. String c. Tuple d. List
17 Assertion (A):- If the arguments in function call statement match 1
the number and order of arguments as defined in the function
definition, such arguments are called positional arguments.
Reasoning (R):- During a function call, the argument list first contains
default argument(s) followed by positional argument(s).
Mark the correct choice as
(a) Both A and R are true and R is the correct explanation for A
(b) Both A and R are true and R is not the correct explanation for A
(c) A is True but R is False
(d) A is false but R is True
18 Assertion (A):- If the arguments in function call statement match the 1
number and order of arguments as defined in the function definition,
such arguments are called positional arguments.
Reasoning (R):- During a function call, the argument list first contains
default argument(s) followed by positional argument(s).
Mark the correct choice as
SECTION-B
a) 16 // 3 + 3 ** 3 + 15 / 4 - 9
b) x>y or y<z and not x!=z If x, y, z=25, 16, 9
20 Differentiate between WiFi and WiMax in context of wireless 2
communication technologies.
OR
Differentiate between Domain name and URL. Illustrate with the help of
suitable example.
21 Expand the following terms: 2
a. GPRS b. GSM c. WLL d. PPP
22 Differentiate between positional parameters and default parameters 2

with suitable example program for each.
OR
How can a function return multiple values? Illustrate with an
example program.
23 Rewrite the following code in Python after removing all syntax error(s). 2
Underline each correction done in the code.
for Name in [Aakash, Sathya, Tarushi]

IF Name[0]= 'S':
print(Name)
24 What are the incorrect output(s) from the given options when the following 2
code is executed? Also specify the minimum and maximum values that can
be assigned to the variable VALUE.
import random
VALUE = random.randint (0,3)
SUBJECT=[“PHY”,”CHEM”,”MATHS”,”COMP”];
for I in SUBJECT:
for J in range(1, VALUE):
print(I, end=””)
print()
Options:
i) PHYPHY ii) PHY

CHEMCHEM PHYCHEM
MATHSMATHS PHYCHEMMATHS
COMPCOMP
iii) PHY iv) PHY
CHEMCHEM CHEM
COMPCOMPCOMP MATHS
COMP
25 What do you understand by Alternate Keys in a table? Give a suitable 2

example of Alternate Keys from a table containing some meaningful data.
Section- C
26 Write a function Interchange (num) in Python, which accepts a list num of 3
integers, and interchange the adjacent elements of the list and print the
modified list as shown below: (Number of elements in the list is assumed as
even)
Original List:
num = [5,7,9,11,13,15]
After Rearrangement
num = [7,5,11,9,15,13]
27 Write a function in Python that displays the words, starting with uppercase 3
letter in a file ‘legend.txt’.
Example: If the “legend.txt” contents are as follows:
Diego Maradona, Argentinian soccer legend and celebrated Hand of God
scorer dies at 60.
The output of the function should be:
Diego
Maradona,
Argentinian
Hand
God
OR
Write a function countdigits() in Python, which should read each character
of a text file “marks.txt”, count the number of digits and display the file
content and the number of digits.
Example: If the “marks.txt” contents are as follows:
Harikaran:40,Atheeswaran:35,Dahrshini:30,Jahnavi:48
The output of the function should be:
Harikaran:40,Atheeswaran:35,Dahrshini:30,Jahnavi:48
('Total number of digits in the file:', 8)
28 Write the outputs of the SQL queries (i) to (iii) based on the relations Car 3
and Customer given below:
Car
Ccode Cname Make Colour Capacity Charges
201 Triber Renault Yellow 7 1000
203 Altroz Tata Black 5 1500
208 Innova Toyota Silver 8 3000
209 Harrier Tata White 6 2000
212 Duster Renault Red 6 2500
217 Ertiga Suzuki Grey 7 2300
Customer
Custcode Custname Ccode
101 Gopinath 201
102 Ashok 203
103 Harshini 209
104 Vishnu 212
i. Select make, count(*) from Car group by make having count(*)<2;

ii. Select Cname, Make from Car order by charges desc;
iii. Select Custname, Cname from Car R, Customer C where
R.Ccode=C.Ccode:
29 Write a function in Python Push (nums), where nums is a list of numbers. 3
From this list push all odd numbers into a stack implemented by using a list.
Display the stack if it has at least one element, otherwise display
appropriate error message.
OR
Write a function in Python Popstack (names), where names is a stack
implemented by a list of names. The function returns the name deleted
from the stack.
30 Find and write the output of the following Python code: 3
def Shuffle(str1):
str2=""
for i in range(0,len(str1)-1):
if(str1[i].islower()):
str2=str2+str1[i].upper()
elif str1[i].isupper():
str2=str2+str1[i].lower()
elif str1[i].isdigit():
str2=str2+'d'
else:
str2=str2+(str1[1-i])
print(str2)
Shuffle('Pre-Board Exam@2023')
Section-D
31 Young Minds Ltd. is an educational organization. It is planning to setup its 5
India campus at Chennai with its head office at Delhi. The Chennai campus
has 4
main buildings – ADMIN, ENGINEERING, BUSINESS and MEDIA.
You as a network expert have to suggest the best network related
solutions for
their problems raised in (i) to (v), keeping in mind the distances between
the
buildings and other given parameters.
Shortest distances between various buildings :

ADMIN to ENGINEERING 55 m
ADMIN to BUSINESS 90 m
ADMIN to MEDIA 50 m
ENGINEERING to BUSINESS 55 m
ENGINEERING to MEDIA 50 m
BUSINESS to MEDIA 45 m
DELHI Head Office to CHENNAI 2175 km
Campus
Number of Computers installed at various buildings are as follows :
ADMIN 110
ENGINEERING 75
BUSINESS 40
MEDIA 12
DELHI Head Office 20
(i) Suggest the most appropriate location of the server inside the CHENNAI
campus (out of the 4 buildings), to get the best connectivity for maximum
no. of computers. Justify your answer.
(ii) Suggest the topology and draw the cable layout to efficiently connect
various buildings within the CHENNAI campus.
(iii) Which hardware device will you suggest to be procured by the company
to minimize the transmission loss?
(iv) Which will be the most suitable wireless communication medium to
connect Chennai campus with its Delhi head office?
(v) Which of the following will you suggest to establish the online face-to-
face
communication between the people in the Admin Office of CHENNAI
Campus and DELHI Head Office?
(a) Cable TV
(b) Email
(c) Video Conferencing
(d) Text Chat
32 Write the SQL commands for the following questions (i) to (v) based on the 5
relations Car and Customer given below:
Car
Ccode Cname Make Colour Capacity Charges
201 Triber Renault Yellow 7 1000
203 Altroz Tata Black 5 1500
208 Innova Toyota Silver 8 3000
209 Harrier Tata White 6 2000
212 Duster Renault Red 6 2500
217 Ertiga Suzuki Grey 7 2300
Customer
Custcode Custname Ccode
101 Gopinath 201
102 Ashok 203
103 Harshini 201
104 Vishnu 212
(i) To display the Names and Charges of all the Silver coloured cars.
(ii) To display the non duplicate car codes in the customer table.
(iii) To display the Minimum and Maximum car charges.
(iv) To give a discount of 10% in the car charges for existing customers (who
are in the customer table).
(v) To display Name and Make of cars whose charges is in the range 2000
to 3000 (both inclusive).
33 A binary file “vehicle.dat” has structure [RegNo, Type, Make, Year]. 5
a. Write a user defined function AddVahan() to input data for a vehicle
and add to “vehicle.dat” file.
b. Write a function CountVahan(Type) in Python which accepts the
Type of the vehicle as the parameter and count and return the
number of vehicles of the given Type.
OR
A binary file “player.dat” has structure (PlayerId, Name, Team, StrikeRate).

Write a function ShowPlayer() in Python that would read contents of the file
and display the details of those players whose Team is “India” and
StrikeRate is above 50. Also display the total number of such players.
SECTION E
34 A Book store Current Books is planning to store their book details in a 4
database using SQL. As a database administrator, Poorvekka has decided
that:
(a) Name of the database - CB
(b) Name of the table - Collections
(c) The attributes of Collections are as
follows:
BookNo - Numeric
BookName – Character of size 25
Price – Numeric
Quantity – Numeric
Table : Collections
BookNo BookName Price Quantity
1647 The Lowland 399 75
5241 The Inheritance Of Loss 555 44
3546 The Guide 641 60
4541 Untouchable 529 53
5025 Train to Pakistan 643 73
6783 Godan 341 97
7614 The God Of Small Things 555 48
(d) Identify the attribute best suitable to be declared as a primary key,

(e) Write the degree and cardinality of the table Collections.
(f) Write SQL command to increment the quantity by 20 wherever
quantity is below 50.
(d) Poorvekka wants to remove the entire data from table
Collections. Which command will she use from the following:
a. DELETE FROM Collections;
b. DELETE Collections;
c. DROP DATABASE CB;
d. DELETE * FROM Collections;
35 Atul Prakash of Class 12 is writing a program to create a CSV file 4
“students.csv” which will contain student name and admission number
for some entries. He has written the following code. As a programmer,
help him to successfully execute the given task.
import # Line 1
def Addstudents(Name, Admno): # to write / add data into the CSV
f=open('students.csv',' ') # Line2
writerObj = csv.writer(f)
writerObj.writerow([Name,Admno])
f.close()
#csv file reading code
def Retrievestudents():# to read data from CSV
with open(' students.csv','r') as fobj:

readerObj=csv. (fobj) # Line
3 for row in readerObj:
print (row[0],row[1])
fobj.close() # Line4
AddStudents(“Raghava”, “2541”)
AddStudents (“Pooja”,”3411”)
AddStudents(“Krutika”,”2218”)
Retrievestudents () #Line 5
(a) Name the module to be imported in Line 1.

(b)Which mode Atul should open the file to add data.
(c) Fill in the blank in Line 3 to read data from a csv file.
(d) Is Line 4 mandatory? Justify your answer.
KENDRIYA VIDYALAYA SANGATHAN: ERNAKULAM REGION
CLASS XII SAMPLE PAPER -2 2022-23(SOLUTION)
Subject: COMPUTER SCIENCE (083)
MARKING SCHEME
Section - A
1 a) sub%marks 1
2 [“I”, “O”, “U”] 1
3 Module “csv” 1
4 c) by 1
5 b) K[3] =405 (as tuple is immutable) 1
6 {“Sub1” : “Physics” , “Sub2” : “Chemistry” , “Sub3”: “Math”} 1
7 7
1
8 floor() from math module 1
9 FTP (File Transfer Protocol) 1
10 c) Hacker 1
11 ORDER BY 1
12 To check for values which are not defined as NULL 1
13 AVG 1
14 a) UPDATE 1
15 Microwave / Radio wave 1
16 d. List 1
17 Ans: (c) A is True but R is False 1
18 Ans: (a) Both A and R are true and R is the correct explanation for A 1
SECTION B
19 a) 26.75 1
1
b) True
20 Wi-Fi is the name of a wireless networking technology that uses radio waves to 2
provide wireless high-speed Internet and network connections.
WiMax (World wide Interoperability for Microwave Access) is a wireless industry

coalition dedicated to the advancement of IEEE 802.16 standards for broadband
wireless access (BWA) networks.
OR
Domain Name: A domain name is a unique name that identifies a particular

website and represents the name of the server where the web pages reside.
URL: The Uniform Resource Locator is a means to locate resources such as web
pages on the Internet. URL is also a method to address the web pages on the
Internet.
Example: http://cbseacademic.nic.in/web_material/CurriculumMain22/CS2022-
23.pdf
is an URL where cbseacademic.nic.in is the domain name.
21 a. GPRS – General Packet Radio Services 2
b. GSM – Global System for Mobile communications
c. WLL – Wireless Local Loop/Wireless in Local Loop
d. PPP – Point to Point Protocol
22 Positional Parameter - When function calls are made, there is a one to one 2
correspondence between the argument and the parameter based on the
order/position in which the argument appears in the function.
Ex:
def fun1(x,y,z):
m= x/y-z
print(m)
a,b,c = 5,2,3
fun1(a,b,c)
fun1(4,b,b)
#fun1(a,b) #Error as the third argument is missing
Default parameters - Usually when a function is called, the number of arguments

must match exactly the number of parameters, otherwise python gives an error.
But there is an exception, if a function is defined with a default parameter, then
the function call can have less number of arguments than the number of
parameters in the function header.
Ex:
def fun1(x,y,z=2): # z is default parameter
m= x/y-z
print(m)
#def fun2(m=2,n,p): # error default arguments must be rightmost
# return m+n+p
a,b,c= 1,2,3
fun1(a,b,c)
fun1(a,b)
#fun1(b) #error as at least two parameters must be passed
OR
A function can return multiple values which is written after the return statement
and the values are separated by commas. The multiple return values are returned
as a tuple object to the statement that made the function call.
Ex:
def fun1(x,y,z):
return x+y,y+z,z+x
a,b,c= 3,5,9
#multiple returned values accepted as a tuple

m = fun1(a,b,c)
print(m)
#multiple returned values accepted in multiple variables

p,q,r=fun1(10,11,12)
print(p,q,r)
23 CORRECTED CODE: 2
for Name in ['Aakash', 'Satya', 'Tarushi']:

if Name[0]=='S':
print(Name)
24 Minimum VALUE = 0 2
Maximum VALUE = 3
Options (ii) & (iii)
are incorrect.
25 Alternate Keys are candidate keys which are not selected as Primary Key. 2
Table: STUD
AdmNo RollNo Name
1236 101 Amarnath
1457 102 Piyush
1836 103 Swetha
In the above table STUD, AdmNo and RollNo are candidate keys, If RollNo
is selected as Primary Key then AdmNo will be the alternate key.
SECTION C
26 def Interchange(num): 3
for i in range(0,n,2):
num[i], num[i+1] = num[i+1], num[i]
print(num)
num=[5,7,9,11,13,15]
n=len(num)
if n%2==0:
Interchange(num)
Note : Any correct code giving the same result is also accepted
27 def Disp_upper_first(): 3
word=""
f=open("legend.txt","r")
line=f.read()
word=line.split()
for i in word:
if i[0].isupper():
print(i)
f.close()
Disp_upper_first()
OR
def countdigits():
c=0
f=open("marks.txt","r")
line=f.read()
print(line)
for i in line:
if i.isdigit():
c+=1
print("Total number of digits in the file:",c)
f.close()
countdigits()
i.
28 Make Count(*) 3
Toyota 1
Suzuki 1
ii.
Cname Make
Innova Toyota
Duster Renault
Ertiga Suzuki
Harrier Tata
Altroz Tata
Triber Renault
iii.
Custname Cname
Gopinath Triber
Ashok Altroz
Harshini Harrier
Vishnu Duster
29 def Push(nums):
li =[] 3
for i in range(0,len(nums)):
if nums[i]%2!=0:
li.append(nums[i])
if len(li) == 0:
print('Stack is empty!!')
else:
print(li)
Push([10,15,20,25,30,35])
OR
def popStack(names) :
L = len(names)
if L==0:
print("Stack Underflow")
else:
val = names[L-1]
names.pop(L-1)
return val
res=popStack(['Harikaran','Balaji','Nikhil','Cathrine'])
print('Value returned:',res)
30 OUTPUT : 3
pRE2bOARDxeXAMaddd
SECTION -D
31 (i) Most suitable place to install the server is ADMIN, as this building has 5
maximum number of computers.
(ii)Topology: STAR
Cable layout:
(iii) Repeater
(iv) Satellite Link
(v) (c) Video Conferencing
32 (i) Select Cname, Charges from Car where Colour=’silver’; 5
(ii) Select distinct Ccode from customer;
(iii) Select min(Charges), max(Charges) from Car;
(iv) Update Car set Charges=Charges - Charges*0.1 from Car R, Customer C
where R.Ccode=C.Ccode;
(v) Select Cname, Make from Car where Charges between 2000 and 3000;
33 import pickle 5
def AddVahan():
f1= open(“vehicle.dat”, “ab”)
RegNo = input(“Enter the vehicle registration number: “)
Type = input(“Enter the vehicle type: “)
Make = input(“Enter the manufacturer name: “)
Year = int(input(“Enter the year of manufacturing: "))
rec = [RegNo, Type, Make, Year]
pickle.dump(rec, f1)
f1.close()
def CountVahan(Type):
f1 = open(“vehicle.dat”, “rb”)
count = 0
try:
while True:
rec = pickle.load(f1)
if Type == rec[1]:
count = count + 1
except:
f1.close()
return count
OR
import pickle
def ShowPlayer():
f1 = open(“player.dat”, “rb”)
count = 0
try:
while True:
rec= pickle.load(f1)
if rec[3] >50 and rec[2] == “India”:
print(rec [0], rec [1], rec [2], rec [3],sep=”\t”)
count +=1
except:
f1.close()
print(“Number of Indian players with strike rate more than 50=”, count)
SECTION E
34 (a) BookNo 4
(b) Degree=4 Cardinality =7
(c) UPDATE collections SET quantity = quantity + 20 WHERE quantity < 50;
(d) DELETE FROM Collections;
35 (a) Line 1 :import csv 4
(b) Line 2 :f=open('students.csv','a')
(c) Line 3 :readerObj=csv.reader(fobj)
(d) Line 4: Not mandatory, as we have opened the file using “with” operator, it
closes automatically.
KENDRIYA VIDYALAYA SANGATHAN, ERNAKULAM REGION
SAMPLE QUESTION PAPER-3(SOLVED)
COMPUTER SCIENCE
CLASS: XII
Max.Marks:70 Time Allowed:3 hours
1.
This question paper contains five sections, Section A to E.
2.
All questions are compulsory.
3.
Section A have 18 questions carrying 01 mark each.
4.
Section B has 07 Very Short Answer type questions carrying 02 marks each.
5.
Section C has 05 Short Answer type questions carrying 03 marks each.
6.
Section D has 03 Long Answer type questions carrying 05 marks each.
7.
Section E has 02 questions carrying 04 marks each. One internal choice is given in Q34
against part c only.
Q.NO PART A Marks
SECTION 1
Attempt any 15 questions from question no 1 to 21.
Which of the following is not a relational operator
1 1
a) > b)<= c)!= d)=
Identify the data type of result of expression 10<5
2 1
a)bool b)int c)float d)None
Which is not a type of tokens from the following.
3 1
a)keyword b) literals c)Operators d)Class
Identify valid declaration of tuple
a)T={‘a’,’b’,’c’,’d’} b) T=‘a’,’b’,’c’,’d’
4 1
c)D=(‘a’,’b’,’c’,’d’) d) both b and c
Write the module that need to be imported to execute the function dump():
5 1
a)random b)csv c)mysql.connector d)pickle
Given the list L=[-1,4,6,-5] ,write the output of print(L[-1:-3])
6
a)[4,6,-5] b)[] c)[6,-5] d)error
What will be the output of following:
x,y=10,5
7 x,y=y,x 1
print(x,y)
a) 10,5 b)5 10 c) 5,10 d)10 5
A function can return ------number of values
8 1
a)0 b)None c)Many d)2
The default file open mode is-----------mode
9 1
a)r b)r+ c)w d)a
Which of the following is/are mutable data type?
10 1
a)int b)string c)list d)tuple
Which operator in SQL is used to compare a value to a specified list of
11 values 1
a)BETWEEN b)= c)IN d)ALL
Which of the following is not an aggregate function?
12 1
a)MIN() b)SUM() c)UPPER() d)COUNT()
Which keyword is used to eliminate duplicate values in an SQL select query?
13 1
a)unique b)distinct c)key d)all
Which of the following network device is a broadcasting device
14 1
a)switch b)hub c)gateway d)router
What is the degree of the following relation?
slno dateofadmn class
15 1 2022-06-05 V 1
2 2022-08-23 VIII
a)3 b)5 c)2 d)1
If all devices are connected to a central hub, then topology is called
16 1
a)tree topology b)bus topology c)star topology d)mesh topology
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the
correct choice as
Assertion(A):The resultset refers to a logical set of records that are fetched

from the database by executing an SQL query.
17 1
Reason(R):Resultset stored in a cursor object can be extracted by using
fetch(…) functions.
Assertion(A):Python overwrites an existing file or creates a non-existing file
18 when we open a file with ‘w’ mode . 1
Reason(R):a+ mode is used only for write operations
SECTION B
Sona has written the following code to check whether number is divisible by
3 .She could not run the code successfully. Rewrite the code and underline
each correction done in the code.
x=10
for I range in (a)
19 2
If i%3=0:
print(I)
else
pass
Write disadvantage of bus topology and star topology(1 each).

20 or 2
What are Routers? How is it differs from gateway?.
Write output
a)a=5
21 2
a+=27
print(a)
b) a=5
print(a+4<10)
22 What is scope? What is the scope resolving rule in python? 2
(a)Expand the following terms:
23 i)MAN ii)HTML 2
b)What is URL ?
Write output for the following code.
def encrypt(str):
str1=""
for i in str:
if i.isupper():
str1+=i.lower()
else:
str1+="*"
return str1
s=encrypt("HeLLo")
print(s)
24 2
or
Go through the python code shown below and find out the possible
output(s) from the suggested options i to iv. Also specify maximum and
minimum value that can be assigned to the variable j.
import random
i=random.random()
j=random.randint(0,6)
print(int(i),”:”,j+int(i))
(i)0:0 (ii)0:6 (iii)1:7 (iv)1:6
Differentiate ORDER BY and GROUP BY with an example.

OR
25 2
Classify the following statements into DDL and DML
a)delete b)drop table c)update d)create table
SECTION C
Consider the following tables CABHUB and CUSTOMER
CABHUB
Vcode VehicleName Make Color Capacity Charges

100 Innova Toyota WHITE 7 15
26 3
102 SX4 Suzuki BLUE 4 14
104 C Class Mercedes RED 4 35
105 A-Star Suzuki WHITE 3 14
108 Indigo Tata SILVER 3 12
CUSTOMER
CCode CName VCode
Hemant
1 Sahu 101
2 Raj Lal 108
Feroza
3 Shah 105
4 Ketan Dhal 104
a)What will be the output of following statement?
select VehicleName,Capacity from Cabhub c, Customer s where
c.Vcode=s.Vcode and c.capacity<4;
b)Write the output of the queries (i) to (iv) based on the table CABHUB
i) select count(VCode),Color from CABHUB group by Color;
ii) select distinct capacity from Cabhub;
iii) select min(Charges),max(charges) from CABHUB;
iv) select VehicleName,Make from CABHUB order by VehicleName
Write a function in python to count number of words ending with ‘n’

present in a text file “ABC.txt”
If ABC.txt contains “A story of a rich man And his son”, the output of the
function should be
27 3
Count of words ending with ‘n’ is 2
Or
A text file contains alphanumeric text (say an.txt).Write a program that
reads this text file and prints only the numbers or digits from the file.
a)Write the output of the SQL commands for (i) to (iv) on the basis of tables
BOOKS and ISSUES.
Table: BOOKS
Book_ID BookName AuthorName Publisher Price Qty
L01 Maths Raman ABC 70 20
L02 Science Agarkar DEF 90 15
L03 Social Suresh XYZ 85 30
28 L04 Computer Sumita ABC 75 7 3

L05 Telugu Nannayya DEF 60 25
L06 English Wordsworth DEF 55 12
Table: ISSUES
Book_ID Qty_Issued
L02 13
L04 5
L05 21
(i) select sum(price) as TOTAL_PRICE from BOOKS;

(ii) select * from BOOKS where publisher=”DEF”;
(iii) select BookName,AuthorName from BOOKS,ISSUES where
BOOKS.Book_ID=ISSUES.Book_ID and Qty_Issued>10;
(iv) select BOOKS.Book_ID,BookName,Publisher,Price,Qty,Qty_Issued from
BOOKS,ISSUES where BOOKS.Book_ID=ISSUES.Book_ID;
b)Write SQL command to display structure of the table BOOKS.
Write a function SUMNOS() that accept a list L of numbers and find sum of
all even numbers and sum of all odd numbers.
If L=[1,2,3,4],
29 3
Output :
sum of even nos:6
Sum of odd numbers:4
A stack S contains Name of countries.Write a function POP(A), to remove
Name from stack. Function should handle underflow condition and should
return removed element.
30 OR 3
Write a function PUSH(STACK,Name) to add new name to the STACK data
structure . Also display all the names having at least 4 characters from the
stack.
SECTION D
“Learn Together” is an educational NGO. It is setting up its new campus at
Jabalpur for its web based activities. The campus has 4 compounds as shown
in the diagram below:
Z
Y
Building
Building
W
X
Building Building
31 5
Center to center distances between various buildings is as follows:

X Building to Y Building 25 m
Y Building to Z Building 100m
X Building to W Building 110 m
W Building to Y Building 135 m
X Building to Z Building 115 m
Z Building to W Building 35 m
Number of Computers in each of the buildings is follows:

X Building 150
Y Building 15
Z Building 5
W Bulding 20
a) Suggest the most suitable place (i.e. building) to house the server of
this organisation with a suitable reason.
b) Suggest a cable layout of connections between the buildings.

c) The organisation is planning to link its admin counter situated in
various parts of the same city, which type of network out of LAN, MAN or
WAN will be formed? Justify your answer.
d) Suggest the placement of the following devices with justification:
(i) Repeater
(ii) Hub/Switch
e) In each of the buildings,the management wants that each LAN segment

gets a dedicated a bandwidth ie.bandwidth must not be shared. How can this
be achieved?
a)Write the output of the code given below

def f():
global s
s += ' Is Great'
print(s)
s = "Python is funny"
s = "Python"
f()
32 print(s) 5
b)The code given below inserts the following record in the table Student:
RollNo – integer
Name – string
Marks – integer
Address –String
Phone-integer
Note the following to establish connectivity between Python and MYSQL:
 Username is root
 Password is root
 The table exists in a MYSQL database named school.
 The details (RollNo, Name, Marks,Address,Phoneno) are to be
accepted from the user.
Write the following missing statements to complete the code:
Statement 1 – to establish connection to the database
Statement 2 – to execute the command that inserts the record in the table
Student. Statement 3- to add the record permanently in the database
OR
a)Predict the output of the following
def student(firstname, lastname ='Mark', standard ='Fifth'):
print(firstname, lastname, 'studies in', standard, 'Standard')
student("John")
student('George','Jose','Seventh')
b) The code given below reads the following record from the table named
student and displays only those records whose address is ‘Delhi’ RollNo –
integer Name – string , Marks – integer ,Address-string,Phone-integer
Note the following to establish connectivity between Python and MYSQL:

Username is root
Password is root
The table exists in a MYSQL database named school.
Write the following missing statements to complete the code: Statement 1

– to form the cursor object
Statement 2 – to execute the query that extracts records of those students
whose address is ‘Delhi’.
Statement 3- to read the complete result of the query (records who are from
“Delhi”) into the object named r, from the table student in the database
What are the characteristics of csv file ? Write a Program in Python that
defines and calls the following user defined functions:
(i) ADD_PROD() – To accept and add information about a product

into a csv file named ‘product.csv’. Each record consists of
prodname and price to store product name and price of the
product
(ii) DISPLAY_PROD() – To display details of products having price
more than 100 present in the CSV file named ‘product.csv’.
33 5
OR
When do we use csv file?. Write a Program in Python that defines and calls
the following user defined functions:
(i) insert_ROLL()– To accept and add data of a student to a CSV file

‘marks.csv’. Each record consists of a list with field elements as rollno, mark
to store roll number and mark of students respectively.
(ii) read_ROLL()- To display and count the records of the students.
SECTION E
Advaith,a manager has stored the details of departments in a table called
DEPARTMENT.
DEPTNO DNAME LOC
----- -------------- --------
34 10 ACCOUNTING NEW YORK 1+1+2
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
He wants to add one more record to this table and has written the following
code and unable to insert that record.
INSERT INTO DEPARTMENT VALUES(43,”HRD”);
i. Help him to correct the code for adding the record
ii. How can he restrict Null values in the table
iii. Write a commands to :
a. show the names of department starting with “R”.
b.update LOC as “New York” for DEPTNO 30.
OR(Option for part iii only)
iii.Write a commands to :
a.insert the following record into the table:DEPTNO-47,DNAME-
Accounting,LOC-Paris
b.delete the records of location(LOC) “Boston”
Manju has created a program using two functions for storing his friends’
exam roll numbers and marks in a binary file “STUDENT.DAT” and to display
total mark.But he forgot some lines of code. As a programmer, help him to
complete the task and to run the program successfully.
______________________ #Line 1
def create_File():
f=open(“STUDENT.DAT”,”ab”)
rollno=int(input(“Enter roll number”))
m1=int(input(“Enter Mark1”))
d={“rollno”:rollno,”M1”:m1,”M2”:m2,”M3”:m3}
pickle._______(d,f) #Line2
f.close()
35 s={} 4
def read_File():
with open(“STUDENT.DAT”,”rb”) as f:
try:
while True:
s=__________________ #Line3
t=s[“M1”]+s[“M2”]+s[“M3”]
print(“RollNo:”,s[rollno],”Total Mark:”,t)
except:
______________________ #Line 4
a)Fill in the blank in Line 1 to import required module.

b)Fill in the blank in Line 2 to write the record
c)Complete Line 3 for reading the record
d)Write the code in the line marked Line4
KENDRIYA VIDYALAYA SANGATHAN, ERNAKULAM REGION
Sample Paper-3(SOLUTION)
SUB: COMPUTER SCIENCE
CLASS XII
Q.NO PART A Marks
Section -A
1 d)= 1
2 a)bool 1
3 d)class 1
4 d)both b and c 1
5 d)pickle 1
6 b)[] 1
7 b)5 10 1
8 c)Many 1
9 a)read 1
10 c)list 1
11 c)IN 1
12 c)UPPER() 1
13 DISTINCT 1
14 b)hub 1
15 a)3 1
16 c)star topology 1
17 b 1
18 c 1
Section-B
19 x=10 2
for I in range(a):
if I%3==0:
print(I)
else:
pass
20 Disadvantages of bus topology 2

1.Identification of problems becomes difficult if the whole network goes
down
2. Need terminators are required at both ends of the main cable
Disadvantages of star topology
1.If hub goes down everything goes down, none of the devices can work
without hub.
2.More expensive than linear bus topology due to the value of the
connecting devices (network switches)
or
What are routers?.
A router is a network device that can receive the data , analyse it and
transmit it to other networks . It is used to connect a Local Area Network to
the internet. Using a routing table, it ensures that data packets are travelling
through the best suitable paths to their destinations.
In simple words, a gateway is a device that we use for communicating among
various networks possessing different protocol sets. It is responsible for
converting a given protocol to another one.Gateway connects dissimilar
network
21 a)32 1+1
b) True
22 What is scope? What is the scope resolving rule in python? 2

The scope of a variable is the region of a program in which the variable is
visible, i.e., in which it is accessible by its name and can be used.
Scope resolution is required when a variable is used to determine where
should its value be come from. Scope resolution in Python follows the LEGB
rule.
23 a)MAN –Metropolitan Area Network b)HTML –Hyper Text Mark up Language 1+1
URL stands for Uniform Resource Locator. A URL is nothing more than the
address of a given unique resource on the Web.
24 h*ll* 2
OR
minimum-0
maximum -1
options(i) and (ii)
25 1. Order By : 2
Order by keyword sort the result-set either in ascending or in descending
order. This clause sorts the result-set in ascending order by default. In
order to sort the result-set in descending order DESC keyword is used.
Order By Syntax –
SELECT column_1, column_2, column_3...........
FROM Table_Name
ORDER BY column_1, column_2, column_3....... ASC|DESC;
2. Group By :
Group by statement is used to group the rows that have the same value. It
is often used with aggregate functions for example:AVG(), MAX(), COUNT(),
MIN() etc. One thing to remember about the group by clause is that the
tuples are grouped based on the similarity between the attribute values of
tuples.
Group By Syntax –
SELECT function_Name(column_1), column_2
FROM Table_Name
WHERE condition
GROUP BY column_1, column_2
ORDER BY column_1, column_2;
OR
a)delete -DML b)drop table -DDL c)update -DML d)create table-DDL
26 a) 1+2
Vehicle Capacity
A-Star 3
Indigo 3
b)
I)
count(vcode) color
2 WHITE
1 BLUE
1 RED
1 SILVER
II)
distinct capacity
7
4
3
III)
min(charge) max(charge)
12 35
iv)
Vehicle Name Make
A-Star Suzuki
C Class Mercedes
Indigo Tata
Innova Toyota
SX4 Suzuki
27 def countA(): 3
file=open("ABC.txt",'r')
r=file.read()
s=r.split()
count=0
for i in s:
if i[-1]=='n':
count+=1
file.close()
print("Count of words ending with “n” is", count)
OR
def printnum():
file=open("an.txt",'r')
r=file.read()
for i in r:
if i.isdigt():
print(i)
file.close()
28 a)i) 2+1
TOTAL_PRICE
435
ii)
Book_ID BookName AuthorName Publisher Price Qty

L02 Science Agarkar DEF 90 15
L05 Telugu Nannayya DEF 60 25
L06 English Wordsworth DEF 55 12
iii)
BookName AuthorName
Science Agarkar
Telugu Nannayya
iv)
Book_ID BookName Publisher Price Qty Qty_Issued

L02 Science DEF 90 15 13
L04 Computer ABC 75 7 5
L05 Telugu DEF 60 25 21
b)DESC BOOKS
29 def SUMNOS(L): 3
SE=0
SO=0
for i in L:
if i%2==0:
SE+=i
else:
SO+=i
print(“Sum of Even no:s=”,SE)
print(“Sum of Odd no:s=”,SO)
30 def POP(A): 3
if len(A)==0:
print(“UNDERFLOW”)
else:
val=A.pop()
return val
OR
Write a function PUSH(STACK,Name) to add new name to the STACK data
structure . Also display all the names having atleast 4 characters from the
stack.
def PUSH(STACK,Name):
STACK.append(Name)
#code for displaying
if len(STACK)==0:
print(“Empty stack”)
else:
top=len(STACK)-1
for i in range(top,-1,-1):
if len(STACK[i])>=4:
print(STACK[i] )
31 a) The most suitable place / block to house the server of this organisation 5(1
would be X Building, as this block contains the maximum number of each)
computers, thus decreasing the cabling cost for most of the computers as well
as increasing the efficiency of the maximum computers in the network.
b)
Answer:
Layout 1
Y Z
Buildin
W
X
Layout 2:
Y Z
Buildin
W
X
c)
Answer:
The type of network that shall be formed to link the sale counters situated in
various parts of the same city would be a MAN, because MAN (Metropolitan
Area Networks) are the networks that link computer facilities within a city.
d)
Answer:
(i) In layout1 between X&Z,X&W.In layout2 between Y and Z.Because
distance is more than 90m.
(ii) In both the layouts, a hub/switch each would be needed in all the
buildings, to interconnect the group of cables from the different
computers in each block
e)switch
32 a)Python Is Great 2+3

Python is funny
b)statement 1-connect
statement2-execute
statement3-commit
OR
a)John Mark studies in Fifth Standard
George Jose studies in Seventh Standard
b)Statement1-mycon.cursor()
statement2-select * from student where address=”Delhi”
statement3-fetchall()
33  One line for each record 5

 Comma separated fields
 Space-characters adjacent to commas are ignored
 Fields with in-built commas are separated by double quote
characters.
import csv
def ADD_PROD():
fout=open("product.csv","a",newline="\n")
wr=csv.writer(fout)
prodname=input("Enter Product name :: ")
price=float(input("Enter Price:: "))
lst=[prodname,price]
wr.writerow(lst)
fout.close()
def DISPLAY_PROD():
found=False
fin=open("record.csv","r",newline="\n")
data=csv.reader(fin)
for i in data:
if int(i[1])>100:
found=True
print(i[0],i[1])
if found==False:
print("Record not found")
fin.close()
ADD_PROD()
print(“Displaying product having price more than 100\n”)
DISPLAY_PROD()
OR
CSV file are useful when we need to import data into many other software
applications.
import csv
def inser_ROLL():
fout=open("marks.csv","a",newline="\n")
wr=csv.writer(fout)
rollno=int(input("Enter Roll number "))
mark=float(input("Enter mark :: "))
lst=[rollno,mark]
wr.writerow(lst)
fout.close()
def read_ROLL():
fin=open("marks.csv","r",newline="\n")
data=csv.reader(fin)
d=list(data)
print(“No.of records=”:,len(d))
for i in data:
print(i)
fin.close()
34 iv. INSERT INTO DEPARTMENT(deptno,dname) VALUES(43,”HRD”); 1+1+2

v. by adding constraint NOT NULL
vi. a. select DName from DEPARTMENT where Dname like “R%”;
b.update DEPARTMENT set LOC=”NEW YORK” where DEPTNO=30;
OR
iii. a. insert into DEPARTMENT values(47,”Accounting”,”Paris”);
b.delete from DEPARTMENT where LOC=”Boston”;
35 a)Fill in the blank in Line 1 to import required module. 1+1+1+1

a)import pickle
b)Fill in the blank in Line 2
b)dump
c)Complete line3
c)pickle.load(f)
d)Write the code in Line4
f.close()
SAMPLE PAPER (UNSOLVED) – COMPUTER SCIENCE (083)
MAX MARKS: 70 TOTAL TIME : 3 hrs
Part A
Section 1 [18 marks] (1x18)
1 Which of the following is an invalid identifier? 1
a. CS_class_XII
b. csclass12
c. _csclass12
d. 12CS
2 Which of the is a correct statement? 1
a. xyz = 10 100 1000
b. x y z = 10 100 1000
c. x, y, z = 10, 100, 1000
d. x y z= 10, 100, 1000
3 Aman wants to write a function in python. But he doesn’t know how to 1
start with it! Select the keyword used to start a function out of the
following:
a) function
b) start
c) def
d) fun
4 Which of the following is not a part of the python function? 1
a) function header
b) return statement
c) parameter list
d) function keyword
5 Which of the following is the correct statement for checking the presence 1
of a key in the dictionary?
a) <key> in <dictionary_object>
a) <key> not in <dictionary_object>
c) <key> found in <dictionary_object>
d) a) <key> exists in <dictionary_object>
6 What will be the output of : 1
t=(4,5,6)
del t[1]
print(t)
a) (4,6) b) ([4,6])
c) [4,6] d) Error
7 Which of the following statement is correct? 1
a) Tuples are mutable.
b) Tuples are immutable.
c) Tuples and lists are same.
d) All of these are correct.
8 What will be the output of following code: 1
txt="Term 1"
print(txt*2)
a) Term 1 Term 2
b) Term 1Term 1
c) Term 1 2
d) TTeerrmm 11
9 The append() method adds an element at 1
a. first
b. last
c. specified index
d. at any location
10 Which point can be considered as difference between string and list? 1
a. Length
b. Indexing and Slicing
c. Mutability
d. Accessing individual elements
11 If n=”Hello” and user wants to assign n[0]=’F’ what will be the result? 1
a. It will replace the first character
b.It’s not allowed in Python to assign a value to an individual character
using index
c.It will replace the entire word Hello into F
d.It will remove H and keep rest of the characters
12 In list slicing, the start and stop can be given beyond limits. If it is then 1
a. raise exception IndexError
b. raise exception ValueError
c. return elements falling between specified start and stop values
d. return the entire list
13 Ms. Hetvee is working on a string program. She wants to display last four 1
characters of a string object named s. Which of the following is statement
is true?
a. s[4:]
b. s[:4]
c. s[-4:]
d. s[:-4]
14 Which of the following statement is true for extend() list method? 1
a. adds element at last
b. adds multiple elements at last
c. adds element at specified index
d. adds elements at random index
15 The statement del l[1:3] do which of the following task? 1
a. deletes elements 2 to 4 elements from the list
b. deletes 2nd and 3rd element from the list
c. deletes 1st and 3rd element from the list
d. deletes 1st, 2nd and 3rd element from the list
16 If l=[11,22,33,44], then output of print(len(l)) will be 1
a. 4
b. 3
c. 8
d. 6
17 Assertion(A) The personal area Network (PAN) is established within a very 1
small area(20 to 30 sq ft) to share the information.
Reason (R ): The campus are network is used to interconnect the
computers located within a campus such as university campus, corporate
campus, hospital campus etc.
Based on the above discussion, choose an appropriate state form the
options given below:
(a) Both assertion and reason are true and the reason is the correct
explanation of assertion.
(b) Both assertion and reason are true but the reason is not the correct
(c) Assertion is true but reason is false.
(d) Assertion is false but reason is true.
(e) Assertion and reason both are wrong.
18 Assertion ( A) : In SQL, the aggregate function Avg() calculates the average 1
value on a set of values and produce a single result.
Reason ( R) : The aggregate functions are used to perform some
fundamental arithmetic tasks such as Min(),Max(), Sum() etc
(a) Both assertion and reason are true and the reason is the correct
(b) Both assertion and reason are true but the reason is not the correct
(c) Assertion is true but reason is false.
(d) Assertion is false but reason is true.
(e) Assertion and reason both are wrong.
Section B [14 marks] [2x7=14]

a) 7*3+4**2//5-8
b) 7>5 and 8>20 or not 12>4
20 Write down the fullform of : 2
A. FTP b) HTML c) SMTP d) VoIP
21 What are actual and formal parameters in Functions? Differentiate using 2
example.
22 Write the queries for the following questions using the table Product with 2
the following fields. (P_ Code, P_Name, Qty, Price)
(i) Display the price of product having code as P06.
(ii) Display the name of all products with quantity greater than 50 and price
less than 500
23 Give two characteristics of Stacks 2
24 In the table Loan below 2
(a) Identify the candidate key(s) from the table Loan.
(b) Which field will be considered as the foreign key if the tables Customers
and Loan are related in a database?
25 Rewrite the following code in Python after removing all syntax error(s). 2
Underline each correction done in the code.
Value=30
for VAL in range(0,Value)
If val%4==0:
print (VAL*4)
Elseif val%5==0:
print (VAL+3)
else
print(VAL+10)
Section C [15 Marks] [3x5]
26 Coach Abhishek stores the races and participants in a dictionary. Write a 3
program, with separate user defined functions to perform the following
operations:
a. Push() Push the names of the participants of the dictionary onto a

stack, where the distance is more than 100.
b. PoP() Pop and display the content of the stack.
For example:
If the sample content of the dictionary is as follows: Races ={100:'Varnika',
200 :'Jugal', 400:'Kushal', 800:'Minisha'}}
The output from the program should be: Minisha Kushal Jugal
27 a) Write the outputs of the SQL queries (i) to (iv) based on the 3
relations Teacher and Placement given below:
Table : Teacher
(i) SELECT Department, sum(Salary) FROM Teacher WHERE Salary>12000

GROUP BY Department;
ii) SELECT MAX(Date_of_Join),MIN(Date_of_Join) FROM Teacher WHERE

Gender=’M’;
iii) SELECT Name, Salary, T.Department, Place FROM Teacher T, Placement P

WHERE T.Department = P.Department AND T.Department Like ‘%o%;
iv) SELECT Name, Place FROM Teacher T, Placement P WHERE Gender =’M’
AND T.Department=P.Department;
(b) Write the command to remove all the tuples of a table

28 Write a program to count a total number of lines and count the total number 3
of lines starting with ‘A’, ‘B’, and ‘C’. (Consider the merge.txt file)
Or
Write a method/function DISPLAYWORDS() in python to read lines from a

text file STORY.TXT, and display those words, which are less than 4
characters.
29 You are a student in CBSE school. 1 Teacher has given a task to write a 3
python code to perform the following binary file operations with the help of
two user defined functions/modules:
a) Addrecord() to create a binary file called school.dat containing
student information (in list datatype) - student number, name, marks(out of
100) of each student.
Or
b) Search() to display name and marks of the student by asking the
student number from the user.
30 Give the output of the following Queries from the given table: 3
a) SELECT COUNT(age) FROM employee WHERE age>33;

b) Select COUT(distinct department) from EMPLOYEE;
c) Select MAX(Age) from EMPLOYEE where SEX =”F”;
Section D [15 Marks]
[5x3]
31 China Middleton Fashion is planning to expand their network in India, 5
starting with two cities to provide infrastructure for distribution of their
products. The company has planned to setup their main office in Chennai at
three different locations and have named their offices as Production Unit,
Finance Unit and Media Unit. The company’s rough layout of the same is as
follows: its Corporate Unit in Delhi. A rough layout of the same is as follows:
(i) Suggest the kind of network required (out of LAN, MAN, WAN) for each of
the following units. (2)
(a) Production Unit and Media Unit
(b) Production Unit and Finance Unit
(ii) Which of the following devices will you suggest for connecting all
computers with each of their office units? (1)
(a) Switch/Hub (b) Modem (c) Telephone
(iii) Suggest a cable/wiring layout for connecting the company’s local office
units located in Chennai. Also, suggest an effective method/technology for
connecting the company’s office unit located in Delhi (2)
32 A. Find an output of the following code 5
def func(b): (2+3)
global x
print(‘Global x=’, x)
y=x+b
x=7
z=x–b
print(‘Local x = ‘,x)
print(‘y = ‘,y)
print(‘z = ‘,z)
x=3
func(5)
B.) ABC Infotech Pvt. Ltd. needs to store, retrieve and delete the records of
its employees. Develop an interface that provides front-end interaction
through Python, and stores and updates records using MySQL.
The operations on MySQL table "emp" involve reading, searching, updating

and deleting the records of employees.
Give statements for 1,2 , 3or4
import __________ #statement1

db1 = mysql.connector.connect (host = "localhost", user = "root", password =
"pathwalla", database = "company")
cursor = db1.cursor()
sql = "SELECT FROM EMP WHERE SALARY> 70000;"
try:
cursor.______(sql) #statement2
resultset = cursor______ () #statement3

for ____ in resultset: #statement4
empno = row [0]
ename = row [1]
salary = row [2]
print (("empno-3d, ename=%s, salary-8f") % (empno, ename, salary))
except:
print ("Error: unable to fetch data")
db1close()
33 What is the advantage of using a csv file for permanent storage?’ 5
Write a Program in Python that defines and calls the following user defined
functions:
(i) ADD() – To accept and add data of a student to a CSV file ‘Stud.csv’. Each
record consists of a list with field elements as studid,s name and Smark to
store student id, student name and student percent marks respectively.
(ii) Count() – To count the number of records present in the CSV file where
Smark is greater then 75% from stud.csv.
OR
Give any one point of difference between a binary file and a csv file.
Write a Program in Python that defines and calls the following user defined
functions:
(i) add() – To accept and add data of a client to a CSV file ‘Client.csv’. Each
record consists of a list with field elements as Cid, Cname and CCity
(ii) search()- To display the records of the Clients whose city is KOCHI
SECTION E ( 4x2= 8 marks)
34 Consider the table ‘PERSONS’ given below 4
(i) Display the SurNames, FirstNames and Cities of people residing in
Udhamwara city.
(ii) Display the Person Ids (PID), cities and Pincodes of persons in descending
order of Pincodes.
(iii) Display the First Names and cities of all the females getting Basic salaries
above 40000.
(iv) Display First Names and Basic Salaries of all the persons whose
firstnames starts with “G”
35 Consider an employee data, Empcode, empname and salary. Sneha Wrote 4
python function to create binary file emp.dat and store their records. And
function to read and display all the records Help her complete the code
import_______ #STATEMENT 1
def add_record():
f = open(“emp.dat”,”ab”)
empcode =int(input(“employee code:”))
empname = int(input(“empName:”))
salary = int(input(“salary:”))
d = [empcode, empname, salary]
pickle.dump(____) #STATEMENT 2
f. close()
def search():
f=open(“_______”,”rb”) #STATEMENT 3
while True:
try:
d=pickle.load(___) #STATEMENT 4
print(d)
except EOFError:
break
f.close()
CBSE 2021 - TERM-1 QUESTION PAPER
COMPUTER SCIENCE (083)
STUDENTS SUPPORT MATERIAL COMPUTER SCIENCE(083) 278

ANSWER KEY – TERM 1 (Computer Science)
CBSE Term 1CBSE Term 1
Series : SSJ/2 SET : 4
1 2 3 4 5 6 7 8 9 10
B,D C D C C C D C B D
11 12 13 14 15 16 17 18 19 20
A C A B B C B A C D
21 22 23 24 25 26 27 28 29 30
A C B D A C B D A D
31 32 33 34 35 36 37 38 39 40
A D C C D C A D C B
41 42 43 44 45 46 47 48 49 50
C C C A C D C B D B
51 52 53 54 55
A A A B C

CBSE 2022 TERM-2 QP WITH MARKING SCHEME
Maximum Marks: 35 Time: 2 hours
General Instructions :
i. This question paper is divided into 3 Sections – A, B and C
ii. Section A, consists of 7 questions (1-7). Each question carries 2 marks.
iii. Section B, consists of 3 questions (8-10). Each question carries 3 marks.
iv. Section C, consists of 3 questions (11-13). Each question carries 4 marks.
v. Internal choices have been given for question numbers 7, 8 and 12.
Section -A
(Each question carries 2 marks)
1. “Stack is a linear data structure which follows a particular order in which 2
the operations are performed.”
What is the order in which the operations are performed in a Stack ?

Name the List method/function available in Python which is used to
remove the last element from a list implemented stack.
Also write an example using Python statements for removing the last
element of the list.
Ans Order of operations performed in a Stack is
LIFO (Last In First Out)
The List method in Python to remove the last element

from a list implemented stack is
pop()
OR
pop(-1)
OR
pop
Example:
L=[10,20,30,40]
L.pop() OR L.pop(-1)
OR
Any other appropriate example
(1 mark for writing correct order)

(½ mark for writing pop or any other correct method/function)
(½ mark for writing correct Python code of an example)
OR
(1 mark for writing correct order)
(1 mark for correct Python statement to demonstrate the pop() function)
(Note: FILO - First In Last Out, may also be considered)
[Sub Code: 083 Series: %BAB% Paper Code: 91 Set - 4] [Page #3/15]
STUDENT SUPPORT MATERIAL COMPUTER SCIENCE(083) 292
2. (i) Expand the following : 1
VoIP, PPP
Ans VoIP : Voice over Internet Protocol
PPP : Point to Point Protocol
(½ mark each for writing correct expansion)
(ii) Riya wants to transfer pictures from her mobile phone to her laptop. She 1
uses Bluetooth technology to connect two devices. Which type of network
(PAN/LAN/MAN/WAN) will be formed in this case?
Ans PAN/ Personal Area Network
(1 mark for correct type of network)
3. Differentiate between the terms Attribute and Domain in the context of 2

Relational Data Model.
Ans
Attribute Domain
The column/field of a It is a set of permissible

table/relation is known as values from which
an attribute. attributes can take/obtain
required value.
For example:
Table: Student
Name Class Marks
aaa XII 90
bbb X 99
Name, Class and Marks are The attribute class has

attributes domain of X, XII
(1 mark each for writing any correct explanation of Attribute and Domain)
4. Consider the following SQL table MEMBER in a SQL Database CLUB: 2

Table: MEMBER
M_ID NAME ACTIVITY
M1001 Amina GYM
M1002 Pratik GYM
M1003 Simon SWIMMING
M1004 Rakesh GYM
M1005 Avneet SWIMMING
Assume that the required library for establishing the connection between
Python and MYSQL is already imported in the given Python code. Also
assume that DB is the name of the database connection for table MEMBER
stored in the database CLUB.
Predict the output of the following code:
MYCUR = DB.cursor()
MYCUR.execute("USE CLUB")
MYCUR.execute("SELECT * FROM MEMBER WHERE ACTIVITY='GYM'")
R=MYCUR.fetchone()
for i in range(2):
R=MYCUR.fetchone()
print(R[0], R[1], sep ="#")
Ans M1002#Pratik
M1004#Rakesh
(1 mark for writing each correct line of output)
(Note: Deduct ½ mark for missing # or writing the output in a single line OR
writing any additional line along with the correct output)
5. Write the output of the SQL queries (a) to (d) based on the table 2
VACCINATION_DATA given below:
TABLE: VACCINATION_DATA
VID Name Age Dose1 Dose2 City
101 Jenny 27 2021-12-25 2022-01-31 Delhi
102 Harjot 55 2021-07-14 2021-10-14 Mumbai
103 Srikanth 43 2021-04-18 2021-07–20 Delhi
104 Gazala 75 2021-07-31 NULL Kolkata
105 Shiksha 32 2022-01-01 NULL Mumbai
(a) SELECT Name, Age FROM VACCINATION_DATA

WHERE Dose2 IS NOT NULL AND Age > 40;
Ans Name Age

Harjot 55
Srikanth 43
(½ mark for the correct output )

(Note: Ignore column heading of the output and order of the output rows)
(b) SELECT City, COUNT(*) FROM VACCINATION_DATA

GROUP BY City;
Ans
City COUNT(*)
Delhi 2
Mumbai 2
Kolkata 1

(c) SELECT DISTINCT City FROM VACCINATION_DATA;
Ans City
Delhi
Mumbai
Kolkata

(d) SELECT MAX(Dose1),MIN(Dose2)FROM VACCINATION_DATA;
Ans MAX(Dose1) MIN(Dose2)

2022-01-01 2021-07-20

6 Write the output of SQL queries (a) and (b) based on the following two 2
tables DOCTOR and PATIENT belonging to the same database :
Table: DOCTOR
DNO DNAME FEES
D1 AMITABH 1500
D2 ANIKET 1000
D3 NIKHIL 1500
D4 ANJANA 1500
Table: PATIENT
PNO PNAME ADMDATE DNO
P1 NOOR 2021-12-25 D1
P2 ANNIE 2021-11-20 D2
P3 PRAKASH 2020-12-10 NULL
P4 HARMEET 2019-12-20 D1
(a) SELECT DNAME, PNAME FROM DOCTOR

NATURAL JOIN PATIENT ;
Ans DNAME PNAME
AMITABH NOOR
ANIKET ANNIE
AMITABH HARMEET
(1 mark for writing correct output)
Note:
Deduct ½ mark for any additional row along with the correct rows
Ignore column heading of the output and order of the output rows
(b) SELECT PNAME, ADMDATE, FEES

FROM PATIENT P, DOCTOR D
WHERE D.DNO = P.DNO AND FEES > 1000;
Ans PNAME ADMDATE FEES

NOOR 2021-12-25 1500
HARMEET 2019-12-20 1500
(1 mark for writing correct output)
Note:
Deduct ½ mark for any additional row along with the correct rows
Ignore column heading of the output and order of the output rows
7. Differentiate between Candidate Key and Primary Key in the context of 2
Relational Database Model.
Ans A table may have more than one or a combination of
attribute(s)that identifies a tuple uniquely. All such
attribute(s) are known as Candidate Keys.
Out of all the Candidate keys, the most appropriate one,

which is used for unique identification of the Tuples,
is called the Primary Key.
Example:
Table: BANK
ACNO NAME PHONE
10001 RISHABH 9810876677
10031 ARNAV 9810876123
10064 ARNAV 9810875577
10076 GURSHARAN 9810871144
Candidate Keys: ACNO, PHONE
Primary Key: ACNO
(2 marks for correct explanation OR example given to differentiate the keys)
OR
(1 mark for writing only the correct explanation/example of candidate key)
(1 mark for writing only the correct explanation/example of primary key)
OR
Consider the following table PLAYER : 2
Table: PLAYER
PNO NAME SCORE
P1 RISHABH 52
P2 HUSSAIN 45
P3 ARNOLD 23
P4 ARNAV 18
P5 GURSHARAN 42
(a) Identify and write the name of the most appropriate column from the
given table PLAYER that can be used as a Primary key.
Ans PNO
(1 mark for mentioning PNO)
(Note: Don’t deduct marks, if any additional column name is also mentioned
along with PNO)
(b) Define the term Degree in relational data model. What is the Degree of
the given table PLAYER ?
Ans Total number of columns/attributes in a table/relation
is known as its Degree.
The Degree of the given table is 3.
(½ mark for writing/explaining with example the correct meaning of Degree)

(½ mark writing correct Degree of the given table)
Section -B
8. ● Write the definition of a user defined function PushNV(N) which 3
accepts a list of strings in the parameter N and pushes all strings
which have no vowels present in it, into a list named NoVowel.
● Write a program in Python to input 5 Words and push them one by one
into a list named All.
The program should then use the function PushNV() to create a stack
of words in the list NoVowel so that it stores only those words which
do not have any vowel present in it, from the list All.
Thereafter, pop each word from the list NoVowel and display the
popped word. When the stack is empty, display the message
"EmptyStack".
For example:
If the Words accepted and pushed into the list All are
['DRY', 'LIKE', 'RHYTHM', 'WORK', 'GYM']

Then the stack NoVowel should store
['DRY', 'RHYTHM', 'GYM']
And the output should be displayed as
GYM RHYTHM DRY EmptyStack
Ans def PushNV(N):

for W in N :
for C in W :
if C.upper() in 'AEIOU':
break
else:
NoVowel.append(W)
All=[]
NoVowel=[]
for i in range(5) :
All.append(input('Enter a Word: '))
PushNV(All)
while NoVowel :
print(NoVowel.pop(), end=' ')
else :
print('EmptyStack')
OR
Any other correct equivalent code
(½ mark for checking vowels correctly, ignore case sensitivity)

(½ mark for pushing strings into the stack NoVowel)
(½ mark for reading 5 words from the users)
(½ mark for assigning 5 words into All)
(½ mark for writing correct code to pop and display the words from NoVowel)
(½ mark for writing correct code to check empty stack and display the message
'EmptyStack')
OR
● Write the definition of a user defined function Push3_5(N) which
accepts a list of integers in a parameter N and pushes all those
integers which are divisible by 3 or divisible by 5 from the list N into
a list named Only3_5.
● Write a program in Python to input 5 integers into a list named NUM.
The program should then use the function Push3_5() to create the
stack of the list Only3_5. Thereafter pop each integer from the list
Only3_5 and display the popped value. When the list is empty, display
the message "StackEmpty".

For example:
If the integers input into the list NUM are :
[10,6,14,18,30]
Then the stack Only3_5 should store
[10,6,18,30]
And the output should be displayed as
30 18 6 10 StackEmpty
Ans def Push3_5(N):
for i in N :
if i%3==0 or i%5==0 :
Only3_5.append(i)
NUM=[]
Only3_5=[]
for i in range(5):
NUM.append(int(input('Enter an Integer: ')))
Push3_5(NUM)
while Only3_5 :
print(Only3_5.pop(), end=' ')
else :
print('StackEmpty')
OR
Any other correct equivalent code
(½ mark for checking divisibility correctly)
(½ mark for pushing integers into the stack Only3_5)
(½ mark for reading 5 integers from the users)
(½ mark for assigning those 5 integers into NUM)
(½ mark for writing correct code to pop and display the integers from Only3_5)
(½ mark for writing correct code to check empty stack and display the message
'StackEmpty')
9. (i) A SQL table ITEMS contains the following columns: 1

INO, INAME, QUANTITY, PRICE, DISCOUNT
Write the SQL command to remove the column DISCOUNT from the table.
Ans ALTER TABLE ITEMS

DROP COLUMN DISCOUNT;
OR
ALTER TABLE ITEMS
DROP DISCOUNT;
(½ mark for writing ALTER TABLE ITEMS)

(½ mark for writing DROP COLUMN DISCOUNT OR DROP DISCOUNT)

(ii) Categorize the following SQL commands into DDL and DML : 2
CREATE, UPDATE, INSERT, DROP
Ans DDL Commands : CREATE, DROP

DML Commands : INSERT, UPDATE
(½ Mark each for writing the correct DDL/DML commands)
10. Rohan is learning to work upon Relational Database Management System 3

(RDBMS) application. Help him to perform following tasks:
(a) To open the database named "LIBRARY".
Ans USE LIBRARY ;
(1 Mark for writing correct SQL command)
(b) To display the names of all the tables stored in the opened database.
Ans SHOW TABLES;

OR
SHOW TABLES FROM LIBRARY;
(c) To display the structure of the table "BOOKS" existing in the already
opened database "LIBRARY".
Ans DESCRIBE BOOKS ;

OR
DESC BOOKS ;
Section - C
11. Write SQL queries for (a) to (d) based on the tables PASSENGER and 4
FLIGHT given below:
Table : PASSENGER
PNO NAME GENDER FNO
1001 Suresh MALE F101
1002 Anita FEMALE F104
1003 Harjas MALE F102
1004 Nita FEMALE F103
Table: FLIGHT
FNO START END F_DATE FARE
F101 MUMBAI CHENNAI 2021-12-25 4500
F102 MUMBAI BENGALURU 2021-11-20 4000
F103 DELHI CHENNAI 2021-12-10 5500
F104 KOLKATA MUMBAI 2021-12-20 4500
F105 DELHI BENGALURU 2021-01-15 5000

(a) Write a query to change the fare to 6000 of the flight whose FNO is F104.
Ans UPDATE FLIGHT

SET FARE=6000 WHERE FNO="F104";
(½ Mark for writing UPDATE FLIGHT)

(½ Mark for writing SET FARE=6000 WHERE FNO="F104")
(b) Write a query to display the total number of MALE and FEMALE
PASSENGERS.
Ans SELECT GENDER, COUNT(*) FROM PASSENGER

GROUP BY GENDER;
OR
SELECT COUNT(*) FROM PASSENGER
GROUP BY GENDER;
(½ mark for writing SELECT part correctly)

(½ mark for writing GROUP BY GENDER; )
OR
(any alternate correct uses of COUNT() is acceptable)
(c) Write a query to display the NAME, corresponding FARE and F_DATE of
all PASSENGERS who have a flight to START from DELHI.
Ans SELECT NAME, FARE, F_DATE FROM PASSENGER P, FLIGHT F

WHERE F.FNO= P.FNO AND START = 'DELHI';
OR
SELECT NAME, FARE, F_DATE FROM PASSENGER, FLIGHT
WHERE PASSENGER.FNO= FLIGHT.FNO AND START = 'DELHI';
OR
SELECT NAME, FARE, F_DATE FROM PASSENGER, FLIGHT
WHERE PASSENGER.FNO= FLIGHT.FNO AND START LIKE 'DELHI';
OR
SELECT NAME,FARE,F_DATE FROM PASSENGER NATURAL JOIN FLIGHT
WHERE START = 'DELHI';
OR
Any other correct and equivalent query
(½ mark for writing SELECT - FROM part correctly)

(½ mark for writing WHERE part correctly)
(d) Write a query to delete the records of flights which end at Mumbai.
Ans DELETE FROM FLIGHT

WHERE END = "MUMBAI";
OR
DELETE FROM FLIGHT
WHERE END LIKE "MUMBAI";
(½ mark for writing DELETE FROM FLIGHT)

(½ mark for writing WHERE part correctly)

12. (i) Differentiate between Bus Topology and Tree Topology. Also, write one 2
advantage of each of them.
Ans
Bus Topology Tree Topology
In bus topology, each It is a hierarchical topology, in

communicating device connects which there are multiple
to a single transmission branches and each branch can
medium, known as bus. have one or more basic
topologies like star, ring and
bus.
Advantage: Advantage:
It is very cost-effective as It is easier to set-up multi-level
compared to other network plans for the network.
topologies.
OR
Any other correct difference/definition/advantages
(1 Mark for mentioning any one correct difference between the topologies)
(½ mark each for writing any one advantage of Bus and Tree Topologies)
OR
(½ mark each for conveying correct understanding of Bus and Tree Topology
using/not using diagram)
(½ mark each for writing any one advantage of Bus and Tree Topologies)
OR
Differentiate between HTML and XML.
Ans
HTML XML
It stands for HyperText Markup It stands for eXtensible Markup
Language. Language.
It contains predefined tags It contains user defined tags to
which are used to design describe and store the data.
webpages.
OR
Any other valid difference/characteristic

(Full 2 Marks for writing any one correct difference between HTML and XML)
OR
(1 Mark for writing correct explanation of HTML)

OR
(½ Mark for writing full form of HTML)
(1 Mark for writing correct explanation of XML)

OR
(½ Mark for writing full form of XML)
(ii) What is a web browser ? Write the names of any two commonly used web 2
browsers.
Ans A Web browser is a software/tool, which allows us to

view/access the content of WebPages.
OR
It is a Client software program that is used to access
various kinds of Internet resources using HTTP.
Examples :
Google Chrome, Microsoft Edge, Mozilla Firefox, Apple
Safari, Opera, Chromium, etc. (ANY TWO)
(1 Mark for writing correct explanation of Web-Browser)

(½ Mark for writing each correct name of two Web-Browsers)
13. Galaxy Provider Ltd. is planning to connect its office in Texas, USA with its 4
branch at Mumbai. The Mumbai branch has 3 Offices in three blocks
located at some distance from each other for different operations –
ADMIN, SALES and ACCOUNTS.
As a network consultant, you have to suggest the best network related
solutions for the issues/problems raised in (a) to (d), keeping in mind the
distances between various locations and other given parameters.
Layout of the Offices in the Mumbai branch:
Shortest distances between various locations:

ADMIN Block to SALES Block 300 m
SALES Block to ACCOUNTS Block 175 m
ADMIN Block to ACCOUNTS Block 350 m
MUMBAI Branch to TEXAS Head Office 14000 km

Number of Computers installed at various locations are as follows:
ADMIN Block 255
ACCOUNTS Block 75
SALES Block 30
TEXAS Head Office 90
(a) It is observed that there is a huge data loss during the process of data
transfer from one block to another. Suggest the most appropriate
networking device out of the following, which needs to be placed along
the path of the wire connecting one block office with another to refresh
the signal and forward it ahead.
(i) MODEM (ii) ETHERNET CARD
(iii) REPEATER (iv) HUB
Ans (iii) REPEATER
(1 Mark for correct identification of the Networking Device)
(b) Which hardware networking device out of the following, will you suggest
to connect all the computers within each block ?
(i) SWITCH (ii) MODEM
(iii) REPEATER (iv) ROUTER
Ans (i) SWITCH
(1 Mark for correct identification of the Networking Device)
(c) Which service/protocol out of the following will be most helpful to

conduct live interactions of employees from Mumbai Branch and
their counterparts in Texas ?
(i) FTP (ii) PPP
(iii) SMTP (iv) VoIP
Ans (iv) VoIP
(1 Mark for correct identification of the service/protocol)
(d) Draw the cable layout (block to block) to efficiently connect the three
offices of the Mumbai branch.
Ans
OR any alternate cable layout
(1 Mark for drawing correct cable layout)

Sample Papers 230-311 PDF

Uploaded by

Document Informationclick to expand document information

Copyright:

Available Formats

Sample Papers 230-311 PDF

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Sample Papers 230-311 PDF

Uploaded by

Copyright:

Available Formats

KENDRIYA VIDYALAYA SANGHATHAN – ERNAKULAM REGION

SAMPLE PAPER-1(SOLVED) – COMPUTER SCIENCE (083)

MAX MARKS: 70 TOTAL TIME : 3 hrs

2. All questions are compulsory.

1. Which of the following symbols are used for comments in Python? 1

(A) // (B) & (C) /**/ (D) #

4. ____________Spans over less than a Kilometer 1

5. The act which governs the cyber transactions in India is_______________ 1

10. How many values can be returned by a function in python? 1

11. print (id(x)) will print_______. 1

14. Suppose list1 is [1, 3, 2], What is list1 * 2 ? 1

15. The readlines() method returns 1

Statement (A) : A function can perform certain functionality 1

Section B [14 marks] [2x7=14]

19 Evaluate the following expressions: 2

20 Write down the fullform of : 2

22 What will be the output of the following code? 2

23 Difference between ALTER & UPDATE commands. 2

i. Smridh is a victim of …………

Section C [15 Marks] [3x5]

d={“Ramesh”:58, “Umesh”:78, “Vishal”:90, “Khushi”:60, “Ishika”:95}

Then the output will be: Umesh Vishal Ishika

Name of the database - Department

The attributes of WORKER are as follows:

I)Identify the attribute best suitable to be declared as a primary key

i) DELETE FROM WORKER;

A) Name the module he should import in Line 1.

A) Write a method/function DISPLAYWORDS() in python to read lines

Section D [15 Marks]

The distance between various buildings is as follows

1. Suggest the cable layout of connections between the buildings. (1)

a) Fiber optic cable

32. Give Output of : 5

def Change (P, Q = 30) :

import mysql.connector as sqltor.

MULTIPLEX = {'MNO': _____, 'MNAME": _____, 'MTYPE': _____}

table COMPANY and CUSTOMER

b) What is the cardinality and degree of table customer?

(i) Which module should be imported in the program? (Statement 1)

SectionD [15 Marks]

33. A.) def Search(): 5

II) Select company.Name from company , Customer where

Subject: COMPUTER SCIENCE (083)

22 Differentiate between positional parameters and default parameters 2

for Name in [Aakash, Sathya, Tarushi]

i) PHYPHY ii) PHY

25 What do you understand by Alternate Keys in a table? Give a suitable 2

i. Select make, count(*) from Car group by make having count(*)<2;

Shortest distances between various buildings :

A binary file “player.dat” has structure (PlayerId, Name, Team, StrikeRate).

(d) Identify the attribute best suitable to be declared as a primary key,

def Addstudents(Name, Admno): # to write / add data into the CSV

with open(' students.csv','r') as fobj:

(a) Name the module to be imported in Line 1.

Subject: COMPUTER SCIENCE (083)

WiMax (World wide Interoperability for Microwave Access) is a wireless industry

Domain Name: A domain name is a unique name that identifies a particular

Default parameters - Usually when a function is called, the number of arguments

MULTIPLEX = {'MNO': ___, 'MNAME": _, 'MTYPE': ___}

i. Select make, count() from Car group by make having count()<2;