Class 12 Practicing Previous Year Question Papers is one of the most effective ways to prepare for the CBSE Class 12 Informatics Practices (IP 065) Board Examination. Solving previous year papers helps students understand the CBSE examination pattern, question types, marking scheme, and important topics. It also provides an opportunity to revise important concepts such as Python programming, Pandas, Data Visualization, SQL, Computer Networks, and Societal Impacts. Regular practice helps students identify their weak areas, improve problem-solving skills, and gain confidence before the final examination.
CBSE Class 12 IP (065) Board Question Paper 2025-26 with Solution will help students evaluate their preparation and understand the correct approach to answering different types of questions. By attempting the question paper within the prescribed time limit and checking their answers with the provided solutions, students can improve their time management, accuracy, and presentation skills. Students are advised to solve the complete paper independently before referring to the solutions to get the maximum benefit from their practice.
CBSE Class 12 IP 065 Board Question Paper 2025-26 with Solution
Exam Date Mar 25, 2026
Series QR1SP
Question Paper Code 90 Set 4
INFORMATICS PRACTICES (065) - PYQP 2026
(Session 2025-26)
Time allowed : 3 hours
Maximum Marks : 70
General Instructions :
- All questions are compulsory.
- The examination paper contains 5 sections – Section A to Section E.
- Section A consists of 21 questions (1 to 21). Each question carries 1 mark.
- Section B consists of 7 questions (22 to 28). Each question carries 2 marks.
- Section C consists of 4 questions (29 to 32). Each question carries 3 marks.
- Section D consists of 2 questions (33 to 34). Each question carries 4 marks.
- Section E consists of 3 questions (35 to 37). Each question carries 5 marks.
- Internal choices have been provided in some questions. Attempt only one of the choices in such questions.
- All programming questions are to be answered using Python language only.
- In case of MCQ, text of the correct answer should also be written.
-SECTION A-
1. State whether the following statement is True or False:
In Pandas Series, the Positional index can be a string or an integer.
Ans: False
2. We can add a new row to a DataFrame DF using the ______ method.
a) DF.add()
b) DF.loc[]
c) DF.loc()
d) DF.addloc[]
3. Naveen discarded various types of waste material without realizing that e-waste contains harmful substances that could pollute the environment. He wants to know which of the following will be considered as e-waste?
a) Plastic Bottle
b) Broken Smartphone
c) Aluminium Foil
d) Banana Peel
4. In which scenario is a bar chart preferred over a line chart?
a) To visualise monthly temperature trends over a year
b) To compare the number of students in different classes
c) To show stock price movements over time
d) To analyse trends in website traffic over days
5. Which of the following network topology uses a central cable (backbone) to connect all devices?
a) Mesh
b) Star
c) Tree
d) Bus
6. State whether the following statement is True or False:
In SQL, an aggregate function returns multiple values for each column on which it is applied.
Ans: False
7. Rohini has developed a new kind of water purifier that uses a unique filtration method. Which type of Intellectual Property Right should she apply to protect her invention?
a) Trademark
b) Copyright
c) Patent
d) Both Copyright & Trademark
8. Aditya is working on a DataFrame named df. He has written the statement:
print(df.loc['S2'])
What will the above statement do?
a) Display the data of the row having label 'S2'
b) Display the columns of the DataFrame
c) Display the data type of the column having label 'S2'
d) Display the index numbers of the DataFrame
9. What will be the result of the following SQL command?
SELECT LENGTH ('Data Base');
Note: There is single space between the words Data and Base.
a) 7
b) 8
c) 9
d) Error
10. Which of the following is a key feature of a Static Web Page?
a) Its content updates very frequently
b) It displays different content to different users
c) It loads slower than a Dynamic Web Page
d) It shows the same content unless the code is manually updated
11. Which of the following is the correct expanded form of DML?
a) Device Management Language
b) Device Manipulation Language
c) Data Management Language
d) Data Manipulation Language
12. CSV stands for __________ Separated Values.
a) Colon
b) CTRL
c) Comma
d) Caret
13. Which of the following is an example of maintaining good net etiquette?
a) Spamming emails or messages to strangers
b) Ignoring other’s opinions in online discussions
c) Not using copyrighted materials without permission of the owner
d) Sharing someone's private information publicly
14. In the context of creating a Pandas Series from a dictionary, which of the following statement is correct?
a) The values of the dictionary become the indices of the Series
b) The keys of the dictionary become the values of the Series
c) The keys of the dictionary become the indices of the Series
d) The Series will have default integer indices starting from 0, ignoring the dictionary keys
15. In Pandas, when extracting a portion of a Series ser1 using ser1[start:end] with positional indices start and end, which of the following statements is true?
a) The element at the end index is included in the output
b) The element at the end index is excluded from the output
c) The elements at both the start and end indices are excluded from the output
d) The element at the start index is excluded from the output
16. Nisha is using an Android app to make a voice call over the internet to her friend in another country. Which protocol is being used in this case?
a) Chat
b) VoIP
c) Email
d) TV
17. State whether the following statement is True or False:
The INSTR(stringl, string2) function in SQL returns 0 if string2 is not present as a substring in string1.
Ans: True
18. In a Pandas DataFrame, which value for axis will be used to delete a column?
a) axis = -1
b) axis = 0
c) axis = 1
d) axis = 2
19. What will be the result of the following SQL command?
SELECT ROUND(15.678, 2);
a) 15.00
b) 15.67
c) 15.68
d) 16.00
Q. 20 and Q. 21 are Assertion (A) and Reason (R) Type questions. Choose the correct option as:
a) Both (A) and (R) are True, and (R) correctly explains (A)
b) Both (A) and (R) are True, but (R) does not correctly explain (A)
c) (A) is True, but (R) is False
d) (A) is False, but (R) is True
20. Assertion (A): Pandas DataFrame can store values of multiple data types in multiple Columns.
Reason (R): DataFrames are implemented using 2D arrays, which allows only numeric values.
Ans: c) (A) is True, but (R) is False
21. Assertion (A): The output of the SQL query SELECT COUNT (name) FROM students; will differ from the output of SELECT COUNT (*) FROM students; if there are some NULL values in the name column.
Reason (R): COUNT(column_name) returns the count of NON NULL values in that column, whereas COUNT(*) returns the number of records in the table.
Ans: a) Both (A) and (R) are True, and (R) correctly explains (A)
-SECTION B-
22. (a) List any two characteristics of Pandas library in Python.
Ans: (i) Open-Source: Pandas is a free and open-source Python library.
(ii) Data Handling: It is used for handling, analysing, and manipulating large amounts of data.
OR
(b) Briefly explain the purpose of Boolean Indexing with respect to DataFrames. Support your answer with a suitable example.
Ans: Boolean Indexing is used to select or filter rows from a DataFrame based on a given condition. It returns only those rows for which the condition evaluates to True.
Example:
import pandas as pd
data = {'Name': ['Aman', 'Riya', 'Raj', 'Simran'],
'Marks': [85, 45, 90, 60]}
df = pd.DataFrame(data)
# Display students scoring more than 60 marks
print(df[df['Marks'] > 60])
Output:
| Name | Marks | |
|---|---|---|
| 0 | Aman | 85 |
| 2 | Raj | 90 |
23. Anjana had created a website using free design elements sourced from different creators online. She then published the site for public access but did not mention the source of the design elements used.
(i) Identify one possible violation of IPR in this situation.
Ans: Anjana may have violated Copyright by using creative design elements without giving proper attribution (credit) to their original creators, if attribution was required by the licence.
(ii) Name any two licensing models that allow legal reuse of digital creative work with conditions.
Ans: Two licensing models that allow legal reuse of digital creative work with certain conditions are:
(i) Creative Commons (CC) Licence
(ii) GNU General Public Licence (GPL)
24. Define the following terms with respect to RDBMS:
(a) Domain - A domain is the set of all possible values that an attribute (column) can contain in a database table.
(b) Tuple - A tuple is a single row or record in a relational database table.
25. (a) Explain the role of the following network devices in a network:
i) Modem - A modem (Modulator-Demodulator) converts digital signals into analog signals and vice versa, enabling data transmission over communication lines.
ii) Gateway - A gateway connects two different networks that may use different protocols and enables communication between them.
OR
(b) Differentiate between add-ons and plug-ins in a web browser.
Ans: Add-ons are extensions that add new features or functionalities to a web browser.
Example: Ad blockers, password manager.
Plug-ins are software components that enable a browser to handle specific types of content.
Example: Adobe Flash Player, Java Plug-in.
26. Write SQL queries to perform the following:
I. Display the month (in numeric form) of the date '2026-01-01'.
Ans: SELECT MONTH('2026-01-01');
II. Display only the year part from the date '2026-01-01'.
Ans: SELECT YEAR('2026-01-01');
27. (a) What is data protection?
Ans: Data protection refers to the process of safeguarding data from unauthorized access, misuse, modification, loss or destruction.
(b) Mention any two precautionary measures one can take to avoid the risk of cybercrime.
Ans: (i) Use strong and unique passwords and enable two-factor authentication.
(ii) Avoid clicking on suspicious links or downloading attachments from unknown sources.
28. (a) Niharika wants to create a Pandas Series using a NumPy array with three elements 'a','b', and 'c', and assign custom indexes 'first','second' and 'third'. Help her complete the code below.
import pandas as pd
import ______ as np
arr = np._____ (['a' , 'b' , 'c'])
s = pd._____(arr,_____=['first','second','third'])
print(s)
Ans:
import pandas as pd
import numpy as np
arr = np.array(['a', 'b', 'c'])
s = pd.Series(arr, index=['first', 'second', 'third'])
print(s)
OR
Write the output of the following code:
import pandas as pd
s1 = pd.Series ([1, 2, 3], index = ['a','b','c'])
s2 = pd.Series ([4, 5, 6], index = ['b','c','d'])
print(s1 + S2)
Ans:
a NaN
b 6.0
c 8.0
d NaN
dtype: float64
-SECTION C-
29. Mandeep received an email stating he won a lottery though he had never participated in any such event. He was asked to provide bank details to process the amount. Mandeep provided the required details but within next few minutes ` One lakh was debited from his account.
Answer the following questions based on the given case study:
I. Mandeep is the victim of which type of cybercrime?
Ans: Phishing
II. Other than email, mention any two common methods through which this type of cybercrime is being committed these days.
Ans: SMS, Phone Calls, Social Media and Fake Websites, Messenger Applications etc.
III. Name one law that safeguards the rights of Internet users in India.
Ans: Information Technology (IT) Act 2000
30. (A) Write a Python program to create and display a Pandas Series as shown below:
July 31
Aug 31
Sept 30
Oct 31
The index labels are the names of the months - July, Aug, Sept, Oct.
The corresponding scalar values are the number of days in these respective months - 31, 31, 30, 31.
Ans:
import pandas as pd
# Creating a Pandas Series
months = pd.Series([31, 31, 30, 31],
index=['July', 'Aug', 'Sept', 'Oct'])
# Displaying the Series
print(months)
OR
(B) A CSV file named customer.csv contains records of customers. The first row of the file represents the header. Sample data from the file is shown below:
Name, Age, City
Rudra, 17, Kolkata
Divya, 19, Dehradun
Nabeel, 22, Lucknow
Write a Python program to import data from the CSV file into a Pandas DataFrame named DF and display the last two rows.
Ans:
import pandas as pd
# Importing data from CSV file into DataFrame
DF = pd.read_csv("customer.csv")
# Displaying the last two rows
print(DF.tail(2))
31. (i) Write an SQL statement to create a table named PRODUCTS with the following specifications:
| Column Name | Data Type | Key |
|---|---|---|
| PID | Integer | Primary Key |
| PName | Varchar of size 30 | |
| PCat | Char of size 15 | |
| Price | Decimal Number |
Ans: CREATE TABLE PRODUCTS (
PID INT PRIMARY KEY,
PName VARCHAR(30),
PCat CHAR(15),
Price DECIMAL(10,2)
);
(ii) Write an SQL query to increase the price of all items by 100, whose product category is Grocery, in the table PRODUCTS.
Ans: UPDATE PRODUCTS
SET Price = Price + 100
WHERE PCat = 'Grocery';
32. (A) Consider the following tables:
Table 1 : TEACHER, which stores Teacher ID (TID), Teacher Name (TName), Experience(Experience) and City (City) that they live in.
| TID | TName | Experience | City |
|---|---|---|---|
| 1 | Kartik | 5 | Bhopal |
| 2 | Shahnaz | 6 | Nagpur |
| 3 | Rajendra | 7 | Delhi |
| 4 | Tanvi | 4 | Bhopal |
| 5 | Alam | 9 | Delhi |
Table 2 : SUBJECT, which stores Subject ID (SID), Subject Name (SubName) and ID of the teacher(TID) teaching that Subject.
| SID | SubName | TID |
|---|---|---|
| 101 | Physics | 1 |
| 102 | Chemistry | 2 |
| 103 | Mathematics | 3 |
| 104 | Informatics Practices | 4 |
| 105 | Computer Science | 5 |
Write appropriate SQL query for the following:
(i) Delete the record of the subject whose TID is equal to 4.
Ans: DELETE FROM SUBJECT WHERE TID = 4;
(ii) Display the names of teachers who have more than 5 years of experience and who stay in Nagpur.
Ans: SELECT TName FROM TEACHER
WHERE Experience > 5 AND City = 'Nagpur';
(iii) Display subject names along with their teacher names.
Ans: SELECT SubName, TName FROM TEACHER, SUBJECT
WHERE TEACHER.TID = SUBJECT.TID;
OR
SELECT SubName, TName FROM SUBJECT
INNER JOIN TEACHER
ON SUBJECT.TID = TEACHER.TID;
OR
(B) Consider the table LIBRARY as given below.
| BookId | Title | Genre | Price |
|---|---|---|---|
| 101 | Python Basics | Technology | 278 |
| 201 | The Silent Patient | Fiction | 340 |
| 301 | Data Science | Technology | 291 |
| 401 | Oceans | Marine Life | NULL |
(i) Which attribute(s) can be considered as the Candidate keys(s)? Justify your answer.
Ans: BookId is unique to every row of table.
(ii) Write an SQL query to insert a new record with the following values:
BookId : 501
Title : AI for ALL
Genre : Technology
Price : 589
Ans: INSERT INTO LIBRARY VALUES (501, 'AI for ALL', 'Technology', 589);
(iii) Write an SQL query to add a new column Author that is a character data type of size 20.
Ans: ALTER TABLE LIBRARY ADD COLUMN AUTHOR VARCHAR(20);
-SECTION D-
33. Ms. Anjali, a data analyst, has been assigned the task of creating a histogram to display the age distribution of ten participants in a workshop. She has been provided with the following list of their ages:
Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23]
She has started writing a Python program for it. However, the code is incomplete. Help her complete the program by filling in the missing parts, so that the histogram as shown below is displayed.
import matplotlib.pyplot as plt
Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23]
binsize=[20,22,24,26,28,30]
plt._______(Ages, bins=binsize, edgecolor = 'black',
label = 'Participants') # Statement-1
______.xlabel('Age') # Statement-2
plt.ylabel('Number of Participants')
plt.title("Age Distribution")
plt._______ # Statement-3
_________ # Statement-4
I. Write the suitable code for the blank space in the line marked as Statement-1 which plots the histogram.
Ans: hist
II. Fill in the blank in Statement-2 to use the correct alias of the required module to set the label on x axis.
Ans: plt
III. Fill in the blank in Statement-3 with the correct Python code to display the legend on the graph.
Ans: legend()
IV. Fill in the blank in Statetment-4 with the appropriate Python code to display the graph.
Ans: plt.show()
34. (A) Shalini, who works as a database designer in the hotel industry, has created a table named Guest to keep track of guest details as shown below:
Table: Guest
| GuestID | GuestName | RoomNumber | CheckInDate | Charges |
|---|---|---|---|---|
| G101 | Harish | 101 | 2025-04-03 | 3000 |
| G102 | Sunita | 101 | 2025-04-03 | 3000 |
| G103 | Ramesh | 102 | 2025-05-04 | 3000 |
| G104 | Bhumika | 103 | 2025-06-02 | 3000 |
Write a suitable SQL query for the following:
(i) Display last 3 characters of guest name in upper case.
Ans: SELECT UPPER(RIGHT(GuestName, 3)) FROM Guest;
(ii) Display the name of the guest along with the day name of check-in date.
Ans: SELECT GuestName, DAYNAME(CheckInDate) FROM Guest;
(iii) Display the remainder when charges are divided by 1000.
Ans: SELECT MOD(Charges,1000) FROM Guest;
(iv) Extract and display three characters, starting from the second character, of each guest name.
Ans: SELECT SUBSTR(GuestName,2,3) FROM Guest;
OR
(B) Consider the following table and write the output of the following SQL Queries.
Table: ORDERS
| ORDERID | CUSTOMERNAME | TOTALAMOUNT | DISCOUNT | ORDERDATE |
|---|---|---|---|---|
| 101 | Hemant | 5000 | 10 | 2024-03-01 |
| 102 | Neha | 7000 | 15 | NULL |
| 103 | Keshav | 3000 | 5 | 2024-01-20 |
| 104 | Sandhya | 4500 | NULL | 2023-12-25 |
Write the output of the following SQL Queries:
I. SELECT CUSTOMERNAME FROM ORDERS WHERE DISCOUNT IS NOT NULL;
Ans:
| CUSTOMERNAME |
|---|
| Hemant |
| Neha |
| Keshav |
II. SELECT CUSTOMERNAME, DISCOUNT FROM ORDERS WHERE DISCOUNT BETWEEN 5 AND 10;
Ans:
| Name | DISCOUNT |
|---|---|
| Hemant | 10 |
| Keshav | 5 |
II. SELECT MONTHNAME(ORDERDATE) FROM ORDERS WHERE ORDERDATE IS NOT NULL;
Ans:
| MONTHNAME (ORDERDATE) |
|---|
| March |
| January |
| December |
II. SELECT ORDERID, DAY(ORDERDATE) FROM ORDERS;
Ans:
| ORDERID | DAY (ORDERDATE) |
|---|---|
| 101 | 1 |
| 102 | NULL |
| 103 | 20 |
| 104 | 25 |
-SECTION E-
35. My Solutions Pvt. Ltd. is a reputed software development and IT consulting firm. The company’s head office is located in Mysuru, and it has a regional office in Chennai. The Mysuru office comprises four departments: Human Resources, Research, Design and Technical Support.
The distances between these departments and between Mysuru and Chennai are as follows:
| From To | Distance (meters) |
| Human Resources to Research | 55 meters |
| Human Resources to Design | 75 meters |
| Human Resources to Technical Support | 140 meters |
| Research to Design | 40 meters |
| Research to Technical Support | 80 meters |
| Design to Technical Support | 60 meters |
| Mysuru Office to Chennai Office | 350 kilometers |
The number of computers in each department/office is as follows:
| Human Resources | 30 |
| Research | 80 |
| Design | 50 |
| Technical Support | 20 |
| Chennai Office | 35 |
As a network engineer, you have to propose solutions for various queries listed from I to V.
I. Identify the most suitable department to install the main server in the Mysuru office. Justify your answer with a valid reason.
Ans: Research department.
Justification: Research department has maximum number of computers.
II. Create a cable layout design to establish Wired network connectivity between the departments in the Mysuru Office.
III. Suggest the appropriate network device to connect multiple computers within the Research department.
Ans: Switch OR Hub
IV. What type of network (LAN, MAN, WAN) would best connect the Mysuru and Chennai office?
Ans: WAN (Wide Area Network)
V. Which device should be used if the signal strength weakens while transmitting data between the Human Resources and Technical Support departments due to the long distance between them?
Ans: Repeater
36. Consider the DataFrame Scholarship shown below:
| Name | Course | Amount | |
|---|---|---|---|
| 0 | Ananya | B.Sc. | 62000 |
| 1 | Karan | B.Tech | 67000 |
| 2 | Simran | MCA | 64000 |
| 3 | Rahul | BCA | 70000 |
| 4 | Priya | BA | 69000 |
Answer the following questions:
I. Write Python code to create and display the given DataFrame using the Dictionary of Series method.
Ans: import pandas as pd
# Creating Series for each column
name = pd.Series(["Ananya", "Karan", "Simran", "Rahul", "Priya"])
course = pd.Series(["B.Sc.", "B.Tech", "MCA", "BCA", "BA"])
amount = pd.Series([62000, 67000, 64000, 70000, 69000])
# Creating DataFrame using Dictionary of Series
data = {"Name": name, "Course": course, "Amount": amount }
Scholarship = pd.DataFrame(data)
# Display the DataFrame
print(Scholarship)
II. Rename row indexes to ['a', 'b', 'c', 'd', 'e']
Ans: Scholarship.index = ['a', 'b', 'c', 'd', 'e']
III. Write Python statement to remove the last row of the given DataFrame.
Ans: Scholarship = Scholarship.drop(Scholarship.index[-1])
37. (A) Write suitable SQL query for the following:
I. To display only the date part from the date/time expression '2026-01-01 10:10:10'
Ans: SELECT DATE('2026-01-01 10:10:10');
II. To convert all customer names from the Cust_Name column to lowercase in the Customer table.
Ans: SELECT LOWER(Cust_Name) FROM Customer;
III. To extract the first 4 characters from the City_Name column in Location table.
Ans: SELECT LEFT(City_Name,4) FROM Location;
IV. To display the name of the city from the CITY column in EVENT table, after removing leading spaces.
Ans: SELECT LTRIM(CITY) FROM EVENT;
V. To find the average salary from Salary column in Employees table.
Ans: SELECT AVG(Salary) FROM Employees;
OR
(B) Write suitable SQL query for the following:
I. To display the value of 172.
Ans: SELECT POW(17,2);
II. To display the day part of the dates in the Hire_Date column of the Employee table.
Ans: SELECT DAY(Hire_Date)FROM Employee;
III. To display the maximum value of the Bill_Amount column in the Bill table.
Ans: SELECT MAX(Bill_Amount) FROM Bill;
IV. To remove leading and trailing spaces from the Location column in the Branch table.
Ans: UPDATE Branch SET Location = TRIM(Location);
V. To display total salary from tot_sal column in Employees table.
Ans: SELECT SUM(tot_sal) FROM Employees;
Download Now - Class 12 IP 843 CBSE Board Previous Year Question Paper (PYQP) 2025-26 with Solution
