Informatics Practices Board Sample Paper 2025-2026 Commerce (English Medium) Class 12 Question Paper Solution

State whether the following statement is True or False:

The drop() method can be used to remove rows or columns from a Pandas DataFrame.

What will be the result of the following SQL query?

SELECT MOD(5, 6);

3

5

6

0

Shruti received an email that appeared to be from a popular social media platform, requesting her to click a link to reset her password. The link directed her to a fraudulent website designed to capture her login credentials. This situation is an example of which type of cybercrime?

Cyber Bullying

Violation of Intellectual Property Rights

Hacking

Phishing

Which of the following Python statements is used to write a Pandas DataFrame df to a CSV file?

df.to_csv()

df.write_csv()

df.to_table()

df.export_csv()

Which of the following device is used for converting digital signals from a computer into analog signals for transmission over a telephone line.

Modem

Switch

Repeater

Router

What is the purpose of the ROUND(num, 0) in SQL, assuming num is a number with a fractional part?

Rounds the number to the nearest integer.

Always rounds the number up.

Leaves the number unchanged.

Always rounds the number down.

Aarushi has written a novel and wants to protect her literary work. Which type of Intellectual Property right will help her do that?

Patent

Copyright

Trademark

Both Copyright & Trademark

The default index used in a Pandas Series, if no index is explicitly specified, is ______.

Strings starting with 'a'

Consecutive integers starting from 1

Random integers

Consecutive integers starting from 0

Consider a table named Students that has one primary key and three alternate keys. How many candidate keys does the table have?

1

2

3

4

Which of the following is an application of VoIP technology?

Email

Chat

Internet Telephony

Web Browsing

Which of the following SQL function is used to count the non-NULL values in a column named column_name?

COUNT(*)

COUNT(column_name)

SUM(column_name)

AVG(column_name)

When two Pandas Series with different indices are added, the result is ______.

Error occurs

Indices are ignored, and elements are added in order.

The result has all indices, with missing values filled as NaN.

Only the common indices are retained in the result.

In India, the primary law that deals e-commerce and cybercrime is ______.

Cybercrime Prevention Act, 2000

Digital Security Act, 2000

Information Technology Act, 2000

E-Commerce Regulation Act, 2008

Which SQL command is used to sort rows in either ascending or descending order of values in a specific column?

ORDER BY

SORT BY

GROUP BY

SORT ON

Which of the following Python commands selects the first 3 rows of a DataFrame df, assuming that labelled index are consecutive integers starting from 0?

df.loc[:3]

df.loc[:2]

df.loc[0:4]

df.loc[1:4]

In which network topology is every node directly connected to every other node?

Star

Tree

Mesh

Bus

What is the use of the INSTR() function in SQL?

To replace characters in a string

To find the length of a string

To find the position of a substring in a string

To extract characters from a string

Which of the following Python statements creates an empty Pandas DataFrame (Note: pd is an alias for pandas)?

pd.DataFrame(None)

pd.DataFrame()

pd.DataFrame([])

pd.DataFrame.empty()

Which of the following is NOT an aggregate function in SQL?

MIN()

SUM()

UPPER()

AVG()

Assertion (A): The output of print(df) and print(df.loc[:]) will be same for a DataFrame df.

Reason (R): The statement print(df.loc[:]) will display all rows and columns of the DataFrame df, thus showing the entire data.

Both A and R are True, and R correctly explains A.

Both A and R are True, but R does not correctly explain A.

A is True, but R is False.

A is False, but R is True.

Assertion (A): The INSERT INTO command is a DML (Data Manipulation Language) command.

Reason (R): DML commands are used to insert, update or delete the data stored in a database.

Both A and R are True, and R correctly explains A.

Both A and R are True, but R does not correctly explain A.

A is True, but R is False.

A is False, but R is True.

What is a DataFrame in Pandas?

Mention any one property of DataFrame.

List any two differences between Series and DataFrame in Pandas.

Mention any one impact of e-waste on the environment.

Ravi wants to create a Pandas Series as shown below:

Help him in completing the code below to achieve the desired output.

Note: ser_data is a dictionary.

import ______ as pd
ser_data = ______
s = pd.______(ser_data)
print(s)

Rohan, a Class XII student, has written code for a website but is unsure how to make it available on the Internet. Explain to Rohan the role of a web server and web hosting in ensuring availability of his website on the internet.

Explain the concept of VoIP.

Mention one benefit of using VoIP.

Write an SQL query to perform the following:

Display the name of the day (e.g., Monday, Tuesday) for the date '2026-01-01'.

Write an SQL query to perform the following:

Find and display the position of the substring “India” in the string “Incredible India”.

Define digital footprints.

Write the difference between the following:

Active and passive footprints.

Write the output of the following code:

import pandas as pd
students = pd.Series(['Abhay', 'Ananya', 'Javed'])
marks = pd.Series([85, 92, 88])
data = {'Name': students, 'Marks': marks}
df = pd.DataFrame(data)
df.rename(columns={'Name': 'StuName', 'Marks': 'Score'},
inplace=True)
print(df)

Write the output of the following code:

import pandas as pd
states = pd.Series(['Maharashtra', 'Gujarat', 'Kerala'])
capitals = pd.Series(['Mumbai', 'Gandhinagar', 'Thiruvananthapuram'])
data = {'State': states, 'Capital': capitals}
df = pd.DataFrame(data)
df.drop(index=1, inplace=True) 
print(df)

1. Explain Rahul the terms Intellectual Property & Intellectual Property Rights (IPR).
2. Under which specific category of IPR is Rahul’s invention covered?
3. Describe the importance of IPR in safeguarding innovations.

Write a Python program to create a Pandas Series as shown below using a ndarray, where the subject names are the indices and the corresponding marks are the values in the series.

Write a Python program to create the Pandas DataFrame displayed below using a list of dictionaries.

Write an SQL statement to create a table named EMPLOYEES, with the following specifications:

Write an SQL Query to insert the following data into the EMPLOYEES table: 101, Ravi Kumar, 2015-06-01, 1.70.

Consider the following tables:

Table 1: STUDENT, which stores StudentID, Name, and Class.

Table 2: MARKS, which stores StudentID, Subject, and Score

Write appropriate SQL queries for the following:

1. List the names of students enrolled in Class 12, sorted in ascending order.
2. Display name of all subjects in uppercase where students scored more than 80 marks.
3. Display the names of students along with their subject and Score.

Consider the following table EMPLOYEE, which stores EmployeeID, Name, Department and Salary.

Table: EMPLOYEE

1. Which attribute in the Table can be considered as the Primary Key? Provide justification for your answer.
2. Write a suitable SQL query to add a new column, Experience, of numeric data type to the table.
3. Write the output of the following SQL Query.
   SELECT Department, COUNT(*) FROM Employee GROUP BY Department;

Rohan, a business analyst, is working on a Python program to create a line graph that represents the monthly revenue (in lakhs) of a company over five months. However, some parts of his code are incomplete. Help Rohan by filling in the blanks in the following Python program.

Help Rohan to complete the code.

______ as plt #Statement−1 
Months = ['January', 'February', 'March', 'April', 'May']
Revenue = [50, 65, 75, 80, 95]
______ #Statement-2
plt.xlabel('Months')
plt.ylabel('Revenue')
______ #Statement-3
______ #Statement-4
plt.legend()
plt.show()

1. Write the suitable code for the import statement in the blank space in the line marked as Statement−1.
2. Write the suitable code for the blank space in the line marked as Statement−2, which plots the line graph with the appropriate data and includes a label for the legend.
3. Fill in the blank in Statement-3 with the correct Python code to set the title of the graph.
4. Fill in the blank in Statement-4 with the appropriate Python code to save the graph as an image file named monthly_revenue.png.

Raghav, who works as a database designer, has created a table Student as shown below:

Table: Student

Write suitable SQL query for the following.

1. Show the Name and City of the students, both in uppercase, sorted alphabetically by Name.
2. Display the Student ID along with the name of the month in which the student was admitted to the school.
3. Calculate and display the average marks obtained by students.
4. Show the names of the cities and the number of students residing in the city.

Consider the following table and write the output of the following SQL Queries.

Table: Student

Write the output of the following SQL Queries.

1. SELECT Name, LENGTH(Name) FROM Student WHERE
   StudentID < 303;

2. SELECT lower(Name) FROM Student WHERE
   MONTH(DateofBirth)= 3;

3. SELECT AVG(Marks) FROM Student;

4. SELECT Name, Marks FROM Student WHERE Marks
   BETWEEN 90 AND 100;

ABC Pvt Ltd. is a leading global IT solutions provider. The company’s head office is located in Mumbai while its Regional Office is in Jaipur. The Mumbai office consists of four departments: Administration, Sales, Development, and Support.

The distances between these departments, as well as between Mumbai and Jaipur, are as follows:

The number of computers in each department/office is as follows:

As a network engineer, you have to propose solutions for various queries listed from I to V.

1. Suggest the most suitable department in the Mumbai Office Setup, to install the server. Also, give a reason to justify your suggested location.
2. Draw a suitable cable layout of wired network connectivity between the departments in the Mumbai Office.
3. Which hardware device will you suggest to connect all the computers within each department?
4. Suggest the most appropriate type of network (LAN, MAN, WAN) to connect the Mumbai Head Office and Jaipur Regional Office.
5. When a signal is transmitted through a wire from Administration department to Support department, its strength reduces. Which device would you suggest the company use to solve this problem?

Consider the DataFrame df shown below.

Write Python statements for the following tasks:

1. Print the last three rows of the DataFrame df.
2. Add a new column named "Experience" with values [5, 8, 10, 6, 7].
3. Delete the column "Salary" from the DataFrame.
4. Rename the column "Department" to "Dept".
5. Display only the "Name" and "Salary" columns from the DataFrame

Write a suitable SQL query for the following:

1. To extract the first five characters from the product_code column in the Products table.
2. To display the total number of orders from Order_Id column in the Orders table.
3. To display the year of the order dates from the order_date column in the Orders table.
4. To display the Address column from the Customers table after removing leading and trailing spaces.
5. To display the current date.

Write a suitable SQL query for the following:

1. To display the total number of characters in the string DatabaseSystems.
2. Find the position of the first occurrence of the letter 'a' in the Product_Name column of the Products table.
3. Calculate the square of the Amount for each transaction in the Tran_Amount column of the Transactions table.
4. To display the average salary from the Salaries column in the Employees table.
5. Display the total sum of the Salary from the Salary column in the Employees table.