CBSE Class 12 Computer Science Sample Paper For 2024-25 A Complete Guide To Boost Your Preparation | TutorialAICSIP

CBSE Class 12 Computer Science Sample Paper for 2024-25

The CBSE Class 12 Computer Science Sample Paper for 2024-25 is now available, and it’s time for students to kick-start their exam preparation with this essential resource. CBSE releases sample papers every year to give students an understanding of the exam pattern, types of questions, and the marking scheme. The Computer Science sample paper is a vital tool for students aiming to excel in their board exams.

In this blog, we’ll break down the CBSE Class 12 Computer Science Sample Paper for 2024-25, cover the latest exam pattern, tips for preparation, and how to make the best use of this paper to score high marks.

Why is the CBSE Class 12 Computer Science Sample Paper for 2024-25 Important?

The CBSE 2024-25 sample paper for Computer Science helps students familiarize themselves with:

• Exam Pattern: Understanding how questions are structured across different sections.
• Type of Questions: Identifying important concepts and topics that carry weight.
• Time Management: Practicing under timed conditions helps develop exam discipline.

By solving the sample paper, students can assess their knowledge, identify weak areas, and improve their accuracy and speed before the final exam.

CBSE Class 12 Computer Science Exam Pattern 2024-25

For the 2024-25 session, the CBSE Computer Science exam will follow a well-structured format. Here’s an overview:

Section A – CBSE Class 12 Computer Science Sample Paper for 2024-25

[1] State True or False: The Python interpreter handles logical errors during code execution.

Ans.:False
The python interpreter not handle any logical error during code execution. Logical errors generates an incorrect output or inappropriate output as logical errors are mistakes committed by the programmers in code.

[2] Identify the output of the following code snippet:

text = "PYTHONPROGRAM"
text=text.replace('PY','#')
print(text)

(A) #THONPROGRAM
(B) ##THON#ROGRAM
(C) #THON#ROGRAM
(D) #YTHON#ROGRAM

Ans.: (A) #THONPROGRAM
The replace method ‘PY’ with ‘#’. The word PYTHONPROGRAM contains PY once and # will be replaced with that.

[3] Which of the following expressions evaluates to False?
(A) not(True) and False
(B) True or False
(C) not(False and True)
(D) True and not(False)

[4] What is the output of the expression?

str="International"
print(str.split("n"))

(A) (‘I’, ‘ter’, ‘atio’, ‘al’)
(B) [‘I’, ‘ter’, ‘atio’, ‘al’]
(C) [‘I’, ‘n’, ‘ter’, ‘n’, ‘atio’, ‘n’, ‘al’]
(D) Error

Ans.: (B) [‘I’, ‘ter’, ‘atio’, ‘al’]
The split method will split the word from the specified word or letter and returns a list of remaining words.

[5] What will be the output of the following code snippet?

str= "World Peace" 
print(str[-2::-2])

Ans.: ce lo
-2 in starting position will start the slicing from second last character of string. Here the second last character is ‘c’, and the stop value is not specified, and step value is -2 so the slicing moves 2 steps from right side. So after ‘c’ it will moves to ‘e’ then space then ‘l’ then ‘o’. Hence output is ‘ce lo’.

[6] What will be the output of the following code?

tuple1 = (1, 2, 3) 
tuple2 = tuple1 
tuple1 += (4,) 
print(tuple1 == tuple2)

(A) True

(B) False

(C) tuple1

(D) Error

Ans.: (B) False
Here
tuple2 = tuple1 is given so tuple1 is copies into tuple2. Hence tuple2=(1,2,3)
tuple1+=(4) changes into tuple1, Hence tuple1=(1,2,3,4)
Now tuple1==tuple2 which are not similar. So output is False.

[7] If my_dict is a dictionary as defined below, then which of the following statements will raise an exception?

my_dict = {‘apple’: 10, ‘banana’: 20, ‘orange’: 30}

(A) my_dict.get(‘orange’)

(B) print(my_dict[‘apple’, ‘banana’])

(C) my_dict[‘apple’]=20

(D) print(str(my_dict))

Ans.: (B) print(my_dict[‘apple’,’banana’])
(A) my_dict.get(‘orange’) will return the value of orange i.e. 30
(B) Dictionary will never access multiple keys and raise KeyError exception.
(C) This statement will change the value apple to 20
(D) This statement will print dictionary as a string.

[8] What does the list.remove(x) method do in Python?

(A) Removes the element at index x from the list

(B) Removes the first occurrence of value x from the list

(C) Removes all occurrences of value x from the list

(D) Removes the last occurrence of value x from the list

Ans.: (B) Removes the first occurrence of value x from the list
(A), (C) and (D) are not relevant

[9] Which of the following statements will cause an error?
(A) t=1,
(B) t=(1,)
(C) t=(1)
(D) t=tuple(1)

Ans.: (D) t=tuple(1)
(A) t=1, and (B) t = (1,) initialize a tuple with a single element 1
(C) t=(1) initialize t as an integer

[10] Write the missing statement to complete the following code:

file = open("example.txt", "r") 
data = file.read(100) 
____________________ #Move the file pointer to the beginning of the file 
next_data = file.read(50) 
file.close()

Ans.: file.seek(0) or file.seek(0,0)

To understand this concept, watch this video:

[11] State whether the following statement is True or False: “The finally block in Python is executed only if no exception occurs in the try block.”

Ans.: False
The finally clause always executes at the end.

[12] What will be the output of the following code?

c = 10 
def add(): 
   global c 
   c = c + 2 
   print(c,end='#') 
add() 
c=15 
print(c,end='%')

(A) 12%15#

(B) 15#12%

(C) 12#15%

(D) 12%15#

Ans.: (C) 12#15%
c=10
In add() function c changes the value as declared as global variable, c=c+2=12.
The print() function prints 12#.
Now c=15 initialize the c as 15. Hence print() function accepts value as 15, and prints 15%.
Hence option (C) 12#15% is correct output.

[13] Which SQL command can change the degree of an existing relation?

Ans.: Alter table command
The degree of relations refers to no. of columns present in the relation.
The alter table command is used to add or remove column from the table.

[14] What will be the output of the query?

SELECT * FROM products WHERE product_name LIKE ‘App%’;

(A) Details of all products whose names start with ‘App’

(B) Details of all products whose names end with ‘App’

(C) Names of all products whose names start with ‘App’

(D) Names of all products whose names end with ‘App’

Ans.: (A) Details of all products whose names start with ‘App’
(B) To print all products whose names end with ‘App’ where condition requires product_name like ‘%App’
(C) and (D) For Names of all products requires name column in select clause

[15] In which datatype the value stored is padded with spaces to fit the specified length.
(A) DATE
(B) VARCHAR

(C) FLOAT
(D) CHAR

Ans.: (D) CHAR
(D) The DATE datatype stores the date values and its almost fixed for all values
(B) The VARCHAR data type occupies the length of values used in the field
(C) The FLOAT data type store the fractional values

[16] Which aggregate function can be used to find the cardinality of a table?
(A) sum()
(B) count()
(C) avg()
(D) max()

Ans.: (B) count()
Cardinality refers to no. of tuples or rows of table. Here the count(*) function will return number of rows present in the relation.
(A) sum() functions returns the sum of field values.
(C) avg() returns average of field values.
(D) max() returns maximum values from selected field values

[17] Which protocol is used to transfer files over the Internet?
(A) HTTP
(B) FTP
(C) PPP
(D) HTTPS

Ans.: (B) FTP
FTP stands for File Transfer Protocol
(A) HTTTP protocol is used to exchange data over the web
(C) PPP allows two routers to connect directly without any host or other networking in between.
(D) HTTPS secured version of HTTP

[18] Which network device is used to connect two networks that use different protocols?

(A) Modem

(B) Gateway

(C) Switch

(D) Repeater

Ans.: (B) Gateway
(A) Modem is used to convert analog signals to digital signals
(C) Switch two or more IT devices, such as computers, to communicate with one another
(D) Repeater is used to amplify and generate the incoming signal

[19] Which switching technique breaks data into smaller packets for transmission, allowing multiple packets to share the same network resources?

Ans.: (B) Packet Switching
– Circuit switching technique establishes a dedicated path between sender and receiver
– Message switching transfers a message as a whole unit and routed through intermediate node at which it is stored and forwarded

Q20 and Q21 are Assertion(A) and Reason(R) based questions. 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

[20] Assertion (A): In the case of positional arguments, the function call and function definition statements match in terms of the number and order of arguments.

Reasoning (R): During a function call, positional arguments should precede keyword arguments in the argument list.

Ans.: (B) Both A and R are true and R is not the correct explanation for A
Positional arguments order must be followed where in keyword arguments order doesn’t matter

[21] Assertion (A): A SELECT command in SQL can have both WHERE and HAVING clauses.

Reasoning (R): WHERE and HAVING clauses are used to check conditions, therefore, these can be used interchangeably.

Ans.: (C) A is True, R is false
Where is used with select clause and having is used with group by clause.

Watch this vide for difference between where and having for more clarity:

Watch this video to understand the MCQs with explanation:

Section B – CBSE Class 12 Computer Science Sample Paper for 2024-25

[22] How is a mutable object different from an immutable object in Python? Identify one mutable object and one immutable object from the following: (1,2), [1,2], {1:1,2:2}, ‘123’

[23] Give two examples of each of the following:
(I) Arithmetic operators

(II) Relational operators

[24] If L1=[1,2,3,2,1,2,4,2, . . . ], and L2=[10,20,30, . . .], then
(I) A) Write a statement to count the occurrences of 4 in L1.

c=0
for i in L1:
 if i==4:
  c+=1
print("Total 4 in List are:", c)

OR

B) Write a statement to sort the elements of list L1 in ascending order.

for i in range(len(L1)):
    for j in range(0, len(L1) - i - 1):
        if L1[j] > L1[j + 1]:
            L1[j], L1[j + 1] = L1[j + 1], L1[j]
print("Sorted list:",L1)

(II) A) Write a statement to insert all the elements of L2 at the end of L1.

L1=L1+L2
print("Sorted list:",L1)

OR

B) Write a statement to reverse the elements of list L2.

temp = []
while L2:
    temp.append(L2.pop())
    L2[:] = temp
print(L2)

i = 0
j = -1
for x in L2:
    j+=1
while i
(3)
temp = []
for i in L2:
        temp.insert(0, i)
1 mark for correct statement/code

[25] Identify the correct output(s) of the following code. Also write the minimum and the maximum possible values of the variable b.

import random
a="Wisdom"
b=random.randint(1,6)
for i in range(0,b,2):
  print(a[i],end='#')

[26] Give an example of a table which has one Primary key and two alternate keys. How many Candidate keys will this table have?

Watch this video to understand keys in SQL:

[27]

(I)
A) What constraint should be applied on a table column so that duplicate values are not allowed in that column, but NULL is allowed.

Ans.: Unique Key is used to fulfil the desired condition over here. As it doesn’t allow duplicate values but allows NULL at once.
1 mark for constraint name

OR

B) What constraint should be applied on a table column so that NULL is not allowed in that column, but duplicate values are allowed.

Ans.: Not null constraint is used to ignore null values but duplicate values are allowed.
1 mark for constraint name

(II)
A) Write an SQL command to remove the Primary Key constraint from a table, named MOBILE. M_ID is the primary key of the table.

Ans.: Alter table mobile drop primary key;
1 Mark for correct command

OR

B) Write an SQL command to make the column M_ID the Primary Key of an already existing table, named MOBILE.

Ans.: Alter table mobile add primary key (M_ID);
1 mark for correct command

[28] A) List one advantage and one disadvantage of star topology.

OR

B) Expand the term SMTP. What is the use of SMTP?

Ans.:
SMTP – Simple Mail Transfer Protocol
It is used to send emails from client to server

Section C – CBSE Class 12 Computer Science Sample Paper for 2024-25

[29] A) Write a Python function that displays all the words containing @cmail from a text file “Emails.txt”.

def check_cmail():
    f=open("Email.txt")
    dt=f.read()
    w=dt.split()
    for i in w:
        if '@cmail' in i:
            print(i,end=' ')
    f.close()
check_cmail()

OR

B) Write a Python function that finds and displays all the words longer than 5 characters from a text file “Words.txt”.

def words_gt5():
    f=open("Words.txt", 'r')
    dt=f.read()
    w=dt.split()
    for i in w:
        if len(i)>5:
            print(i,end=' ')
words_gt5()

[30] (A) You have a stack named BooksStack that contains records of books. Each book record is represented as a list containing book_title, author_name, and publication_year.
Write the following user-defined functions in Python to perform the specified operations on the stack BooksStack:
(I) push_book(BooksStack, new_book): This function takes the stack BooksStack and a new book record new_book as arguments and pushes the new book record onto the stack.
(II) pop_book(BooksStack): This function pops the topmost book record from the stack and returns it. If the stack is already empty, the function should display “Underflow”.
(III) peep(BookStack): This function displays the topmost element of the stack without deleting it. If the stack is empty, the function should display ‘None’.

def push_book(BookStack, new_book):
    BookStack.append(new_book)

def pop_book(BookStack):
    if not BookStack:
        print("Underflow")
    else:
        return BookStack.pop()

def peep(BookStack):
    if not BookStack:
        print("None")
    else:
        print(BookStack[-1])

while True:
    bt=input("Enter Book Title:")
    an=input("Enter Author Name:")
    year=int(input("Enter Year:"))
    lst=[bt,an,year]
    x=input("Press X to stop:")
    if x=='x':
        break
stk=[]
push_book(stk,lst)
print(pop_book(stk))
peep(stk)

OR

B) Write a Python program to input an integer and display all its prime factors in descending order, using a stack. For example, if the input number is 2100, the output should be: 7 5 5 3 2 2 (because prime factorization of 2100 is 7x5x5x3x2x2)
Hint: Smallest factor, other than 1, of any integer is guaranteed to be prime.

n=int(input("Enter an integer: "))
stk=[]
f=2
while n>1:
    if n%f==0:
        stk.append(f)
        n//=f
    else:
        f+=1
while stk:
    print(stk.pop(),end=' ')

[31] Consider the table ORDERS as given below, and write the following queries:
+——+———-+————+———-+——-+
| O_Id | C_Name | Product | Quantity | Price |
+——+———-+————+———-+——-+
| 1001 | Jitendra | Laptop | 1 | 12000 |
| 1002 | Mustafa | Smartphone | 2 | 10000 |
| 1003 | Dhwani | Headphone | 1 | 1500 |
+——+———-+————+———-+——-+
Note: The table contains many more records than shown here.

A)
(I) To display the total Quantity for each Product, excluding Products with total Quantity less than 5.
(II) To display the orders table sorted by total price in descending order.
(III) To display the distinct customer names from the Orders table.

Section D – CBSE Class 12 Computer Science Sample Paper for 2024-25

[32] A)
I. When is ZeroDivisionError exception raised in Python?
II. Give an example code to handle ZeroDivisionError? The code should display the message “Division by Zero is not allowed” in case of ZeroDivisionError exception, and the message “Some error occurred” in case of any other exception.

try:
    a=int(input("Enter an integer: "))
    print("Reciprocal of the number =",1/a)
except ZeroDivisionError:
    print("Division by Zero is not allowed")
except:
    print("Some Error Ocurred")

OR

B)
I. When is NameError exception raised in Python?
II. Give an example code to handle NameError? The code should display the message “Some name is not defined” in case of NameError exception, and the message “Some error occurred” in case of any other exception.

try:
    #a=int(input("Enter an integer: "))
    print("Reciprocal of the number =",1/a)
except NameError:
    print("a  is not defied")
except:
    print("Some Error Ocurred")

[33] A csv file “Happiness.csv” contains the data of a survey. Each record of the file contains the following data:
● Name of a country
● Population of the country
● Sample Size (Number of persons who participated in the survey in that country)
● Happy (Number of persons who accepted that they were Happy)
For example, a sample record of the file may be:
Signiland, 5673000, 5000, 3426
Write the following Python functions to perform the specified operations on this file:
(I) Read all the data from the file and display all those records for which the population is more than 5000000.
(II) Count the number of records in the file.

5000000:
            print(i)
   f.close()

def Count_records():
    import csv
    f=open("happiness.csv",'r')
    records=csv.reader(f)
    next(records, None)
    #To skip the Header row
    count=0
    for i in records:
        count+=1
    print(count)
    f.close()

[34] Saman has been entrusted with the management of Law University Database. He needs to access some information from FACULTY and COURSES tables for a survey analysis. Help him extract the following information by writing the desired SQL queries as mentioned below.

Table: FACULTY

Table: COURSES

(I) To display complete details (from both the tables) of those Faculties whose salary is less than 12000.
(II) To display the details of courses whose fees is in the range of 20000 to 50000 (both values included).
(III) To increase the fees of all courses by 500 which have “Computer” in their Course names.
(IV) (A) To display names (FName and LName) of faculty taking System Design.

OR

(B) To display the Cartesian Product of these two tables.

Ans.:
(I) Select * from FACULTY natural join COURSES where Salary<12000;
(II) Select * from courses where fees between 20000 and 50000;
(III) Update courses set fees=fees+500 where CName like ‘%Computer%’;
(IV) (A) Select FName, LName from faculty natural join courses where Came=”System Design”;
OR
(B) Select * from FACULTY, COURSES;
(4×1 mark for each correct query)
[/showhide]

Download Official Sample Paper from CBSE Website