Computer Science (Python) Board Sample Paper 2025-2026 Commerce (English Medium) Class 12 Question Paper Solution

State if the following statement is True or False:

Using the statistics module, the output of the below statements will be 20:

import statistics

statistics.median([10, 20, 10, 30, 10, 20, 30])

What will be the output of the following code?

L = ["India", "Incredible", "Bharat"]
print(L[1][0] + L[2][−1])

IT

it

It

iT

Consider the given expression:

print(19<11 and 29>19 or not 75>30)

Which of the following will be the correct output of the given expression?

True

False

Null

No output

In SQL, which type of Join(s) may contain duplicate column(s)?

What will be the output of the following Python code?

str= "Soft Skills"
print(str[-3::-3])

lSf

Stkl

StKi

l

Write the output of the following Python code:

for k in range(7,40,6):
     print ( k + '-' )

What will be the output of the following Python statement:

print(10-3**2**2+144/12)

Consider the given SQL Query:

SELECT department, COUNT(*) FROM employees HAVING COUNT(*) > 5 GROUP BY department;

Saanvi is executing the query but not getting the correct output. Write the correction.

What will be the output of the following Python code?

try:
   x = 10 / 0
except Exception:
   print("Some other error!")
except ZeroDivisionError:
   print("Division by zero error!")

Division by zero error!

Some other error!

ZeroDivisionError

Nothing is printed

What will be the output of the following Python code?

my_dict = {"name": "Alicia", "age": 27, "city": "DELHI"}
print(my_dict.get("profession", "Not Specified"))

Alicia

DELHI

None

Not Specified

What possible output is expected to be displayed on the screen at the time of execution of the Python program from the following code?

import random
L=[10,30,50,70]
Lower=random.randint(2,2)
Upper=random.randint(2,3)
for K in range(Lower, Upper+1):
   print(L[K], end="@")

50@70@

90@

10@30@50@

10@30@50@70@

What will be the output of the following Python code?

i = 5
print(i,end='@@')
def add():
  global i
  i = i+7
  print(i,end='##')
add()
print(i)

5@@12##15

5@@5##12

5@@12##12

12@@12##12

Which SQL command can change the cardinality of an existing relation?

Insert

Delete

Both Insert & Delete

Drop

What is the output of the given Python code?

st='Waterskiing is thrilling!'
print(st.split("i"))

['Watersk', 'ng ', 's thr', 'll', ‘ng!']

['Watersk', '', 'ng ', 's thr', 'll', 'ng!']

['Watersk', 'i', 'ng ', 's thr', 'll', ‘ng!']

Error

In SQL, a relation consists of 5 columns and 6 rows. If 2 columns and 3 rows are added to the existing relation, what will be the updated degree of a relation?

Degree: 7

Degree: 8

Degree: 9

Degree: 6

Which SQL command is used to remove a column from a table in MySQL?

UPDATE

ALTER

DROP

DELETE

______ is a protocol used for retrieving emails from a mail server.

SMTP

FTP

POP3

PPP

Which of the following is correct about using a Hub and Switch in a computer network?

A hub sends data to all devices in a network, while a switch sends data to the specific device.

A hub sends data only to the devices it is connected to, while a switch sends data to all devices in a network.

A hub and switch function the same way and can be used interchangeably.

A hub and switch are both wireless networking devices.

Which of the following is used to create the structure of a web page?

CSS

HTML

JavaScript

FTP

Assertion (A): The expression (1, 2, 3, 4).append(5) in Python will modify the original sequence datatype.

Reason (R): The append() method adds an element to the end of a list and modifies the list in place.

Both A and R are True and R is the correct explanation for A.

Both A and R are True and R is not the correct explanation for A.

A is True but R is False.

A is False but R is True.

Assertion (A): A primary key must be unique and cannot have NULL values.

Reasoning (R): The primary key uniquely identifies each row in the table.

Both A and R are True and R is the correct explanation for A.

Both A and R are True and R is not the correct explanation for A.

A is True but R is False.

A is False but R is True.

Explain the difference between explicit and implicit type conversion in Python with a suitable example.

Explain the difference between break and continue statements in Python with a suitable example.

Rewrite it after removing all the errors. Also, underline all the corrections made.

define remove_first_last(str):
   if len(str)<2:
      return str
   new_str = str[1:-2]
   return new_str
result = remove_first_last("Hello")
Print("Resulting string:"result)

Answer using Python built-in method/function only:

Write a statement to find the index of the first occurrence of the substring “good” in a string named review.

Answer using Python built-in method/function only:

Write a statement to sort the elements of list L1 in descending order.

Predict the output of the following Python code:

text="Learn Python with fun and practice"
print(text.partition("with"))
print(text.count("a"))

Write a function remove_element() in Python that accepts a list L and a number n. If the number n exists in the list, it should be removed. If it does not exist, print a message saying “Element not found”.

Write a Python function add_contact() that accepts a dictionary phone_book, a name, and a phone number. The function should add the name and phone number to the dictionary. If the name already exists, print “Contact already exists” instead of updating it.

Predict the output of the Python code given below:

emp = {"Arv": (85000,90000),"Ria": (78000,88000),"Jay": (72000,80000),"Tia":
 (80000,70000)}
selected = [ ]
for name in emp:
   salary = emp[name]
   average = (salary[0] + salary[1])/2
   if average > 80000:
      selected.append(name)
print(selected)

Write a suitable command to do the following in MySQL.

View the table structure.

Write a suitable command to do the following in MySQL.

Create a database named SQP.

Differentiate between drop and delete query in SQL with a suitable example.

Define the following term:

Modem

Define the following term:

Gateway

Expand HTTP.

Expand FTP.

How is web server different from web browser?

Write a Python function that displays the number of times the word “Python” appears in a text file named “Prog.txt”. 

Write and call a Python function to read lines from a text file STORIES.TXT and display those lines which doesn’t start with a vowel (A, E, I, O, U) irrespective of their case.

A list containing records of products as 

L = [("Laptop", 90000), ("Mobile", 30000), ("Pen", 50), ("Headphones", 1500)]

Write the following user-defined function to perform an operation on a stack named Product to:

Push_element() – To push an item containing the product name and price of products costing more than 50 into the stack.

Output:

('Laptop', 90000), 
('Mobile', 30000),
('Headphones', 1500)

A list containing records of products as 

L = [("Laptop", 90000), ("Mobile", 30000), ("Pen", 50), ("Headphones", 1500)]

Write the following user-defined function to perform an operation on a stack named Product to:

Pop_element() – To pop the items from the stack and display them. Also, display "Stack Empty" when there are no elements in the stack.

Output: 

('Headphones', 1500) 
('Mobile', 30000) 
('Laptop', 90000) 
Stack Emply

Predict the output of the following Python code:

s1="SQP−25"
s2=""
i=0
while i<len(s1):
  if s1[i]>='0' and s1[i]<='9':
     Num=int(s1[i])
     Num−=1
     s2=s2+str(Num)
  elif s1[i]>='A' and s1[i]<='Z':
     s2=s2+s1[i+1]
  else:
     s2=s2+'^'
    i+=1
print(s2)

Predict the output of the following Python code:

wildlife_sanctuary = ["Kaziranga", "Ranthambhore", "Jim Corbett", "Sundarbans",
"Periyar", "Gir", "Bandipur"]
output = [ ]
for sanctuary in wildlife_sanctuary:
   if sanctuary[−1] in 'aeiou':
      output.append(sanctuary[0].upper())
print(output)

Consider the table SALES as given below:

Write the following queries:

1. To display the total quantity sold for each product whose total quantity sold exceeds 12.
2. To display the records of SALES table sorted by Product name in descending order.
3. To display the distinct Product names from the SALES table.
4. To display the records of customers whose names end with the letter ‘e’.

Predict the output of the following:

SELECT * FROM Sales where product='Tablet';

Predict the output of the following:

SELECT sales_id, customer_name FROM Sales WHERE product LIKE 'S%';

Predict the output of the following:

SELECT COUNT(*) FROM Sales WHERE product in ('Laptop', 'Tablet');

Predict the output of the following:

SELECT AVG(price) FROM Sales where product='Tablet';

Help him to efficiently maintain the data by creating the following user-defined functions:

1. Accept() – to accept a sales record from the user and add it to the file Sales.csv.
2. CalculateTotalSales() – to calculate and return the total sales based on the Quantity_Sold and Price_Per_Unit.

Pranav is managing a Travel Database and needs to access certain information from the Hotels and Bookings tables for an upcoming tourism survey. Help him extract the required information by writing the appropriate SQL queries as per the tasks mentioned below: 

1. To display a list of customer names who have bookings in any hotel of 'Delhi' city.
2. To display the booking details for customers who have booked hotels in 'Mumbai', 'Chennai', or 'Kolkata'.
3. To delete all bookings where the check-in date is before 2024-12-03.
4. A. To display the Cartesian Product of the two tables.
                                        OR
   B. To display the customer’s name along with their booked hotel’s name.

MySQL database named WarehouseDB has a product_inventory table in MySQL which contains the following attributes:

• Item_code: Item code (Integer)
• Product_name: Name of product (String)
• Quantity: Quantity of product (Integer)
• Cost: Cost of product (Integer)

Consider the following details to establish Python-MySQL connectivity:

• Username: admin_user
• Password: warehouse2024
• Host: localhost

Write a Python program to change the quantity of the product to 91 whose Item_code is 208 in the product_inventory table.

Mr. Ravi, a manager at a tech company, needs to maintain records of employees. Each record should include: Employee_ID, Employee_Name, Department and Salary. Write the Python function to input employee data and append it to a binary file.

Mr. Ravi, a manager at a tech company, needs to maintain records of employees. Each record should include: Employee ID, Employee_Name, Department and Salary. Write the Python functions to update the salary of employees in the "IT" department to 200000.

XYZNova Inc. is planning a new campus in Hyderabad while maintaining its headquarters in Bengaluru. The campus will have four buildings: HR, Finance, IT, and Logistics. As a network expert, you are tasked with proposing the best network solutions for their needs based on the following:

Number of Computers in Each Block:

1. Suggest the best location for the server in the Hyderabad campus and explain your reasoning.
2. Suggest the placement of the following devices:
   1. Repeater
   2. Switch
3. Suggest and draw a cable layout of connections between the buildings inside the campus.
4. The organisation plans to provide a high-speed link with its head office using a wired connection. Which of the cables will be most suitable for this job?
5. 1. What is the use of VoIP?
                                   OR
   2. Which type of network (PAN, LAN, MAN, or WAN) will be formed while connecting the Hyderabad campus to Bengaluru Headquarters?