CBSE Sample Papers for Class 12 Computer Science Set 5 with Solutions

Students must start practicing the questions from CBSE Sample Papers for Class 12 Computer Science with Solutions Set 5 are designed as per the revised syllabus.

CBSE Sample Papers for Class 12 Computer Science Set 5 with Solutions

Time: 3 Hours
Maximum Marks: 70

General Instructions

1. This question paper contains 37 questions.
2. All questions are compulsory. However, internal choices have been provided in some questions. Attempt only one of the choices in such questions.
3. The paper is divided into 5 Sections – A, B, C, D and E.
4. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
5. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
6. Section C consists of 3 questions (29 to 31). Each question carries 3 Marks.
7. Section D consists of 4 questions (32 to 35). Each question carries 4 Marks.
8. Section E consists of 2 questions (36 to 37). Each question carries 5 Marks.
9. All programming questions are to be answered using Python Language only.
10. In the case of MCQ, the text of the correct answer should also be written.

Section A
(21 × 1 = 21)

Question 1.
State True or False
“The pop() method removes and displays the last element of a list.”
Answer:
True

Question 2.
The command to merge the dictionary Book with Library the command would be:
(a) d=Book+Library
(b) print(Book+Library)
(c) Book.update(Library)
(d) Library.update(Book)
Answer:
(d) Library.update(Book)

Question 3.
Which of the following will result to False?
(a) 9%5=4 and 10%3=1
(b) 10**3=1000 and math.sqrt(100)=10
(c) True or True or Not True
(d) None of these
Answer:
(d) None of the above

Question 4.
The output of the code will be:

L=[6, 7, 8, 9, 10]
print(L[2:20])

(a) [8, 9, 10]
(b) [ ]
(c) Error
(d) [6, 7, 8, 9, 10]
Answer:
(a) [8,9,10]

Question 5.
What is the output of the following code?

City="Kolkata"
print(City.upper () [ -2 : 1 : -1])

(a) TAKL
(b) Kata
(c) Takl
(d) TaKl
Answer:
(a) TAKL

Question 6.
Given a tuple tup=(20,50,10,60,30).
The statement t.append(90) returns
(a) (20,50,10,60,30,90)
(b) (90)
(c) Error
(d) (30,90)
Answer:
(c) Error

Question 7.
Predict the output of the following code:

def fun(x):
x[0]=5
return x.
g=[10,11,12]
print(fun(g),g)

(a) [5,11,12] [5,11,12]
(b) [5,10,12] [5,11,12]
(c) [5,11,12] [5,10,12]
(d) [10,11,12] [10,11,12]
Answer:
(a) [5,11,12] [5,11,12]

Question 8.
The method that removes a range of values from a list is?
(a) del
(b) cut()
(c) pop()
(d) removeElement()
Answer:
(a) del

Question 9.
What will the following code display?

Name="Neha"
type(Name)

(a) Invalid function
(b) <class ‘str’>
(c) <class ‘int’>
(d) <class ‘float’>
Answer:
(b) <class ‘str’>

Question 10.
Fill in the missing blank in the code given to read the contents of the file and create a list of words from it.

fobj=open(“notes.txt”, “r”)
data=fobj.read()
lstwords=______________
fobj.close()

Answer:
data.split(‘ ‘)

Question 11.
State True or False:
There can be a try block without a catch block but vice versa is not possible.
Answer:
True

Question 12.
What will be the output of the following code?

def addEm(x,y,z):
return(x+y+z)
def prod(x,y,z):
return x*y*z
a=addEm(6,16,26)
b=prod(2,3,6)
print(a,b)

(a) 47
35
(b) 48
48 36
(c) 40
30
(d) Error in code
Answer:
(b) 48
48 36

Question 13.
What SQL clause is used to filter records based on a specified condition?
Answer:
WHERE

Question 14.
What will the following query do?

Select Pname, Qty , Qty* Price as “Amount” from Product where Qty>50;

(a) Insert the values Pname, Qty, and Qty*Price into the table Product.
(b) Display the Pname, qty, and price in the table product
(c) Error in SQL
(d) Display the Pname, qty, price, and a calculated field Qty×Price with the heading “Amount” from the table product
Answer:
(d) Display the Pname, qty, price, and a calculated field Qty×Price with the heading “Amount” from the table product

Question 15.
Which of the following are possible relational operations?
(a) Join
(b) Selection
(c) Cartesian product
(d) All of these
Answer:
(d) All of these

Question 16.
To arrange a table in descending order of field Salary the clause to be used is
(a) Order by Salary
(b) Order by Salary Desc
(c) Arrange by SalaryDesc
(d) Arrange by Salary
Answer:
(b) Order by Salary Desc

Question 17.
Identify the device that links two homogeneous packed broadcast local networks.
(a) Hub
(b) Router
(c) Bridge
(d) Gateway
Answer:
(c) Bridge

Question 18.
A ______________ is a set of rules that governs data communication.
(a) Forum
(b) Protocol
(c) Standard
(d) None of these
Answer:
(b) Protocol

Question 19.
Which transmission media is the most fragile and difficult to maintain?
Answer:
Fiber optic cable

Directions (Q. 20 and 21) are Assertion (A) and Reason (R) based questions. Mark the correct choice as
(a) Both A and R are true and R is a correct explanation of A.
(b) Both A and R are true but R is not a correct explanation of A.
(c) A is true and R is false.
(d) A is false and R is true.

Question 20.
Assertion (A): Default parameters to a function are not compulsory but are a good practice to specify.
Reason (R): If default parameters are specified the formal parameters will take the default values if any of the actual parameters are not passed.
Answer:
(a) Both A and R are true and R is the correct explanation for A.

Question 21.
Assertion (A): The maximum set of attributes that can uniquely identify a tuple is known as a candidate key.
Reason (R): Out of one or more candidate keys, the attribute chosen by the database designer to uniquely identify the tuples in a relation is called the primary key of that relation.
Answer:
(d) A is False but R is True

Section B
(7 × 2 = 14)

Question 22.
Differentiate between break and continue statements with the help of an example.
Answer:
break statement is used to terminate the execution of the loop.
For example:

for i in range(6):
if i= =3:
break
print (i)

The output of the above code will be:
0
1
2
The loop terminates when i becomes 3 due to the break statement. Whereas, the continue statement is used to force the next iteration while skipping the statements in the present iteration.

Question 23.
Give examples of:
(a) Two relational operators
(b) How is the * operator different from **
Answer:
(a) Relational operators: >, ==
(b) * – Used to perform multiplication
** – Used to calculate the power of a number

Question 24.
Given a list Lst=[34,67,89,3,1,12]
(I) (a) Write a statement to display the number of elements in the list
Or
(b) To create a tuple ‘t’ from the list
(II) (a) To display the sum of elements of the list.
Or
(b) To remove the element “89” from the list.
Answer:

(I) (a) print(len(Lst))
Or
(b) t=tuple(Lst)
(II) (a) print(sum(Lst))
Or
(b) Lst.remove(89)

Question 25.
What are the possible outcome(s) after the execution of the following code? Also, specify the maximum and the minimum value.

import random
PICK=random.randint (0, 3)
CITY=[“DELHI”, “MUMBAI”, “CHENNAI”, “KOLKATA”];
for I in CITY:
for J in range (1, PICK):
print(I, end = “ ”)
print()

(i) DELHIDELHI
MUMBAIMUMBAI
CHENNAICHENNAI
KOLKATAKOLKATA

(ii) DELHI
DELHIMUMBAI
DELHIMUMBAICHENNAI

(iii) DELHI
MUMBAI
CHENNAI
KOLKATA

(iv) DELHI
MUMBAIMUMBAI
KOLKATAKOLKATAKOLKATA
Answer:
Options (i) and (iii) are possible options
PICK maxval = 3
minval = 0

Question 26.
A table Transaction has 5 columns and 15 rows. Two rows are added to the table. What will be the degree of the table? Now two columns are deleted, what will be the degree of the table?
Answer:
The degree will remain the same = 5
Now Degree will be 5 – 2 = 3

Question 27.
(I) Write commands/clauses/functions to be used for the following:
(a) To change the name of a column Qty to quantity.
Or
(b) Function to search for a string in a field.
(II) (a) To increase the values of the price column in a table.
Or
(b) Function to display a certain number of characters from the left of a field.
Answer:
(I) (a) Alter table
Rename
Or
(b) instr()
(II) (a) Update
Or
(b) Left()

Question 28.
(a) Write the full form of the following
(i) TCP
(ii) HTTP
Or
(b) Identify the types of networks formed in the following cases:
(i) Two friends sharing files between a distance of 1000 km.
(ii) A device transmitting voice to stations within a distance of 30 km.
Answer:
(a) (i) TCP: Transmission Control Protocol
(ii) HTTP: Hypertext Transfer Protocol
Or
(b) (i) WAN
(ii) MAN

Section C
(3 × 3 = 9)

Question 29.
Write a method Filterwords() to find and display words from a text file ‘NewsLetter.txt’ whose length is less than 4.
Or
Write a method countAN() that checks the number of occurrences of “A” and “N” in a text file “Story.txt”.
Answer:

def Filterwords():
c=0
file=open(‘NewsLetter.txt’, ‘r’)
line=file.read()
word=line.split(‘ ’)
dor c in word:
if len(c)<4:
print(c)
file.close()
Filterwords()
Or
def countAN():
countA=0
countN=0
file=open(“Story.txt”,“r”)
data=file.read()
for ch in data:
if ch in “A”:
countA+=1
elif ch in “N”:
countN+=1
print(“Number of A:”, countA)
print(“Number of N:”, countN)
file.close()
CountAN()

Question 30.
(a) A linear stack called status contains the following information:
Phone number of Employee
Name of Employee
Write the following methods to perform given operations on the stack status:
Push_element() To Push an object containing the Phone number of the Employee and the Name of the Employee into the stack.
Pop_element() To Pop an object from the stack and to release the memory.
Or
(b) Write a program with functions as detailed below, to operate on a stack storing palindrome numbers only.
Answer:

(a) def Push_element (Status, Top):
phone_no = int(input (“Enter phone number :”))
emp_name = input ("Enter employee name :”)
St = (phone_no, emp_name)
Status.append (St)
Top = Top + 1
return Top
def Pop_element (Status, Top):
Slen = len(Status)
if (Slen==0):
print (“Status is empty”)
else:
phone_no, emp_name = Status. Pop ()
Top = Top - 1
print(“Phone number %s and name %s deleted”)
%(phone_no, emp_name)
return Top
Or
(b) pal nums = []
def pushpals(n):
t=str(n)
if t==t.reverse()
palnums.append(n)
ans='y'
while ans=='y':
n=input(“Enter a number :”)
pushpals (n)
ans=input(“Add more(y/n)”)

Question 31.
Consider the following table.

(a) (i) Write the command to remove the records of the “Cardiology” department.
(ii) Display a report showing the Name, charges, and discount (15%) for all patients.
(iii) Display names of female patients.
Or
(b) (i) Display the details of patients of the “Gynaecology” department who are Female.
(ii) Display only the monthname of admission of Male patients.
(iii) Increase charges of “Cardiology” patients by 20%.
Answer:

(a) (i) DELETE FROM PATIENTS WHERE Department="Cardiology";
(ii) SELECT Name, Charges, Charges*0.15 AS "Discount" FROM PATIENTS;
(iii) SELECT Name FROM PATIENTS WHERE Sex="F";
Or
(b) (i) SELECT * FROM PATIENTS WHERE Department = ‘Gynaecology’ and Sex="F";
(ii) SELECT monthname(Dateofadm) FROM PATIENTS WHERE Sex="M";
(iii) Update PATIENTS set Charges=Charges + Charges*0.2 WHERE Department ="Cardiology";

Section D
(4 × 4 = 16)

Question 32.
(A) (i) Why is it necessary to handle exceptions in a program?
(ii) What output will the following code produce, if the file “t1.txt” is not present?

try:
f=open(“t1.txt”,“r”)
s=f.read()
print(s)
except FileNotFoundError:
print(“File does not exist”)
else:
print(“File successfully processed”)
finally:
print(“File handling code ends”)

Or
(B) (i) How many except blocks can be written against a try block?
(ii) What output will the following code produce:

try:
f=open("t1.txt", "w")
f.write("AISSCE2025")
f.close()
f=open("t1.txt","r")
s=f.read()
print(s)
except FileNotFoundError:
print('File does not exist')
else:
print('File successfully processed')
finally:
print('File handling code ends')

Answer:
(A) (i) Handling exceptions in a code creates a safe or guard code that has a lesser probability of abnormally terminating.
(ii) Output:
File does not exist
File handling code ends
Or
(B) (i) Multiple except blocks can be written against a try to match and handle different kinds of exceptions.
(ii) Output:
AISSCE2025
File successfully processed
File handling code ends

Question 33.
(a) Which file can be opened with Notepad as well as MS Excel?
(b) A binary file “Garment.dat” exists containing records of different types of garments as per the following structure.
GarmentID Type Gender Cost
Write a Python program to add and search records of garments from the binary file and display them using the following functions:
AddGarment() Function to input details of garments and store them in the file “Garment.dat”, if the garment type is “cotton” or “silk”.
ShowGarments() To open the file “Garment.dat”, display details and the number of “silk” garments.
Answer:
(a) CSV file

(b) import pickle
def AddGarment( ) :
f=open("Garment.dat","wb")
ans='y'
gid=" "
gtype=" "
gen=" "
gcost=0.0
while ans=='y':
gid=input("Enter garment id.")
gtype=input("Enter Garment type")
gen=input("Gender")
gcost=float(input(“Enter cost”))
glst=[gid, gtype, gen, gcost]
if gtype=="cotton" or gtype="silk":
pickle.dump(glst,f)
else;
print(“Invalid garment type!!!”)
ans=input("Continue(y/n)")
f.close()
def ShowGarments():
count=0
f=open("Garment.dat","rb")
while True:
try:
glst=pickle.load(f)
if glst[1]=="silk":
count+=1
print("Garment ID.:", glst[0])
print("Garment Type:", glst[1])
print("Gender:", glst[2])
print("Price:",glst[3])
print("No. of silk garments":, count)
except EOFError:
print("End of file")
break
f.close()
AddGarment()
ShowGarments()

Question 34.
Consider the following tables School and Admin and answer the following questions:

Give the output of the following SQL queries:
(i) Select Designation Count (*) From Admin Group By Designation Having Count (*) <2;
(ii) SELECT max (EXPERIENCE) FROM SCHOOL;
(iii) SELECT TEACHER FROM SCHOOL WHERE EXPERIENCE >12 ORDER BY TEACHER;
(iv) (A) SELECT COUNT (*), GENDER FROM ADMIN GROUP BY GENDER;
Or
(B) Write a query to display the teacher name, subject, and designation of teachers whose experience is greater than 10.
Answer:
(i) VICE PRINCIPAL 01
(ii) 16
(iii) UMESH YASHRAJ
(iv) (A) 5 MALE
2 FEMALE
Or

(B) SELECT teacher, subject, designation FROM SCHOOL S, Admin A WHERE A.code=S.code and S.experience>10;

Question 35.
What is the utility of the fetchall() method?
Write a code to fetch all the records of a Student table from the PythonDB Database.
Note:
Host: localhost
Database: PythonDB
User: root
Password: arihant
Table: Student
Answer:
The fetchall() method retrieves all rows from the result set of a database query. It returns them as a list of tuples, allowing you to access and manipulate all the data at once.

import mysql.connector
con = mysql.connector.connect(host = “localhost”, user = “root”, passwd = “arihant”, database = “PythonDB”)
cursor = con.cursor()
try:
cursor.execute ("Select * from Student")
display = cursor.fetchall()
for i in display:
print(i)
except:
con.rollback()
con.close()

Section E
(2 × 5 = 10)

Question 36.
A csv file “cricket.csv” exists to store the data of cricketers as follows:
CID CricketerName Strikerate WorldRank
Write a program in Python to add data of more cricketers along with the existing records. Also, display the details of cricketers as per the condition given using the functions:
AppendCricketer() To accept data of cricketers and append them to the file “cricket.csv”
GetCricketers() To open the file “cricket.csv” and display the number of cricketers whose world ranking is above 50.
Answer:

import pickle
def AppendCricketer():
f=open("cricket.csv","ab")
ans='y'
cid=" "
cname=" "
srate=0.0
wrank=0.0
while ans=='y':
cid=input("Enter cricketer id.")
cname=input("Enter cricketer name")
srate=float(input("Enter Strike rate: "))
wrank=int(input(“Enter world rank"))
clst=[cid, cname, srate, wrank]
pickle.dump(clst.f)
ans=input("Continue(y/n)")
f.close()
def GetCricketers():
count=0
f=open("cricket.csv","rb")
while True:
try:
clst=pickle.load(f)
if int(clst[3]) > 50:
count+=1
print(“Number of cricketers above world rank 50:”, count)
except EOFError:
break
f.close()
AppendCricketer()
GetCricketers()

Question 37.
G.R.K International Inc. is planning to connect its Bengaluru Office Setup with its Head Office in Delhi. The Bengaluru Office G.R.K. International Inc. is spread across an area of approx. 1 square kilometer consisting of 3 blocks. Human Resources, Academics, and Administration. You as a network expert have to suggest answers to the questions (a) to (e) raised by them.
Note: Keep the distances between blocks and the number of computers in each block in mind, while providing them the solutions.

Shortest distances between various blocks

Number of computers installed at various blocks

(a) Suggest the most suitable block in the Bengaluru Office Setup to host the server. Give a suitable reason with your suggestion.
(b) Suggest the cable layout among the various blocks within the Bengaluru Office Setup for connecting the blocks.
(c) Suggest the placement of the switch.
(d) Suggest the most suitable media to provide secure, fast, and reliable data connectivity between the Delhi Head Office and the Bengaluru Office Setup.
(e) (i) Expand the following:
WAN
LAN
Or
(ii)
Expand the following:
WLAN
MAN
Answer:
(a) Human Resources, because it has the maximum number of computers.
(b)

(c) Switches are needed in every building as they share bandwidth in every building.
(d) Satellite
(e) (i) WAN – Wide Area Network
LAN – Local Area Network
Or
(ii) WLAN – Wireless Local Area Network
MAN – Metropolitan Area Network