CBSE Class 12 IP (065) Sample Question Paper 2025-26 with Solutions is one of the best study resources for students preparing for the board examination. These latest CBSE sample papers are designed according to the updated syllabus, exam pattern, and marking scheme issued by CBSE. By solving the Informatics Practices sample paper, students can understand the types of questions asked in the board exam, including Python programming, SQL queries, Data Handling, Computer Networks, and Data Visualization topics. The detailed solutions also help students learn the correct answering format and improve accuracy in board exams.
Practicing CBSE Class 12 IP Sample Papers regularly helps students improve time management, problem-solving skills, and confidence before the final examination. Students can identify important topics, frequently asked questions, and weak areas that need more preparation. Solving sample question papers with answers also reduces exam stress and gives a real board exam experience. For better preparation, students should practice these solved sample papers along with previous year question papers, NCERT solutions, and revision notes to score high marks in the CBSE Class 12 upcoming Board Examination.
CBSE Class 12 IP 065 Sample QP 2025-26 with Solution
You can download the free PDF of this sample pre-board question paper from our website and start practicing today. Download Link available in last.
The Year-Wise CBSE Class 12 Informatics Practices (065) Pre-Board and Sample Question Papers with Solutions are provided at the bottom of this post.
CBSE Class 12 IP 065 Sample Question Paper Session (2025-26)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATICS PRACTICES (SUBJECT CODE - 065)
Sample Question Paper (SQP) Solution for Class XII (Session 2025-2026)
Max. Time: 3 Hours
Max. Marks: 70
General Instructions:
- Please check this question paper contains 37 questions.
- All questions are compulsory. However, internal choices have been provided in some questions. Attempt only one of the choices in such questions
- The paper is divided into 5 Sections- A, B, C, D and 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 case study type questions (33 to 34). Each question carries 4 Marks.
- Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
- 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 (21x1=21 Marks)
1. State whether the following statement is True or False:
The drop() method can be used to remove rows or columns from a Pandas DataFrame.
Ans: True
2. What will be the result of the following SQL query?
SELECT MOD(5, 6);
a) 3
b) 5
c) 6
d) 0
3. 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?
a) Cyber Bullying
b) Violation of Intellectual Property Rights
c) Hacking
d) Phishing
4. Which of the following Python statements is used to write a Pandas DataFrame df to a CSV file?
a) df.to_csv()
b) df.write_csv()
c) df.to_table()
d) df.export_csv()
5. Which of the following device is used for converting digital signals from a computer into analog signals for transmission over a telephone line.
a) Modem
b) Switch
c) Repeater
d) Router
6. What is the purpose of the ROUND(num, 0) in SQL, assuming num is a number with a fractional part?
a) Rounds the number to the nearest integer
b) Always rounds the number up
c) Leaves the number unchanged
d) Always rounds the number down
7. Aarushi has written a novel and wants to protect her literary work. Which type of Intellectual Property right will help her do that?
a) Patent
b) Copyright
c) Trademark
d) Both Copyright & Trademark
8. The default index used in a Pandas Series, if no index is explicitly specified, is _____
a) Strings starting with 'a'
b) Consecutive integers starting from 1
c) Random integers
d) Consecutive integers starting from 0
9. Consider a table named Students that has one primary key and three alternate keys. How many candidate keys does the table have?
a) 1
b) 2
c) 3
d) 4
10. Which of the following is an application of VoIP technology?
a) Email
b) Chat
c) Internet Telephony
d) Web Browsing
11. Which of the following SQL function is used to count the non-NULL values in a column named column_name?
a) COUNT(*)
b) COUNT(column_name)
c) SUM(column_name)
d) AVG(column_name)
12. When two Pandas Series with different indices are added, the result is _____.
a) Error occurs
b) Indices are ignored, and elements are added in order
c) The result has all indices, with missing values filled as NaN
d) Only the common indices are retained in the result
13. In India, the primary law that deals e-commerce and cybercrime is _____.
a) Cybercrime Prevention Act, 2000
b) Digital Security Act, 2000
c) Information Technology Act, 2000
d) E-Commerce Regulation Act, 2008
14. Which SQL command is used to sort rows in either ascending or descending order of values in a specific column?
a) ORDER BY
b) SORT BY
c) GROUP BY
d) SORT ON
15. 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?
a) df.loc[:3]
b) df.loc[:2]
c) df.loc[0:4]
d) df.loc[1:4]
16. In which network topology is every node directly connected to every other node?
a) Star
b) Tree
c) Mesh
d) Bus
17. What is the use of the INSTR() function in SQL?
a) To replace characters in a string
b) To find the length of a string
c) To find the position of a substring in a string
d) To extract characters from a string
18. Which of the following Python statements creates an empty Pandas DataFrame (Note: pd is an alias for pandas)?
a) pd.DataFrame(None)
b) pd.DataFrame()
c) pd.DataFrame([])
d) pd.DataFrame.empty()
19. Which of the following is NOT an aggregate function in SQL?
a) MIN()
b) SUM()
c) UPPER()
d) AVG()
Q.20 and Q.21 are Assertion (A) and Reason (R) Type questions. Choose the correct option as:
20. 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.
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
21. 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.
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
SECTION B (7x2=14 Marks)
22. What is a DataFrame in Pandas? Mention any one property of DataFrame.
Ans: A DataFrame is a 2-Dimensional labeled data structure with rows and columns.
Property: Flexible Size - Rows and Columns can be added or deleted after creation of DataFrame.
OR
List any two differences between Series and DataFrame in Pandas.
Ans: (i) A Series is 1-dimensional, while a DataFrame is 2-dimensional.
(ii) Series is size immutable while DataFrame is size mutable.
23. What is e-waste? Mention any one impact of e-waste on the environment.
Ans: E-waste refers to discarded electronic devices like computers and phones.
Impact: E-waste releases toxic chemicals into the soil and water, harming the environment.
24. Ravi wants to create a Pandas Series as shown below:
| January | 31 |
| February | 28 |
| March | 31 |
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)
Ans:
import pandas as pd
ser_data = {'January': 31, 'February': 28, 'March': 31}
s = pd.Series(ser_data)
print(s)
25. 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.
Ans: Web Server: It is a computer software that accepts client request and responds with required content or error message.
Web Hosting: It is a service that stores and maintains a website's files on a server so that the website is accessible online.
OR
Explain the concept of VoIP and mention one benefit of using it.
Ans: VoIP (Voice over Internet Protocol) is a technology that allows voice communication and calls over the internet instead of traditional telephone lines.
Benefit: It is cost-effective and reduces communication costs.
26. Write SQL queries to perform the following:
I. Display the name of the day (e.g., Monday, Tuesday) for the date '2026-01-01'.
Ans: SELECT DAYNAME('2026-01-01');
II. Find and display the position of the substring "India" in the string "Incredible India"
Ans: SELECT INSTR('Incredible India', 'India');
27. Define digital footprints. Differentiate between active and passive digital footprints.
Ans: Digital footprints are traces of a person's online activity.
Active Digital Footprint: Intentional posts or uploads.
Passive Digital Footprint: Unintentional data collected (e.g., location tracking).
28. 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)
Ans:
| StuName | Score | |
|---|---|---|
| 0 | Abhay | 85 |
| 1 | Ananya | 92 |
| 2 | Javed | 88 |
OR
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)
Ans:
| State | Capital | |
|---|---|---|
| 0 | Maharashtra | Mumbai |
| 2 | Kerala | Thiruvananthapuram |
SECTION C (4x3=12 Marks)
29. Rahul has recently invented a new type of solar-powered water purification system and is concerned about the possibility of someone illegally copying and selling his invention without his permission.
I. Explain Rahul the terms Intellectual Property & Intellectual Property Rights (IPR).
Ans: Intellectual Property (IP) refers to creations of the mind like literary works, inventions etc.
Intellectual Property Rights (IPR) are legal rights granted to creators for their original work.
II. Under which specific category of IPR is Rahul's invention covered?
Ans: Rahul's invention will be covered under Patent.
III. Describe the importance of IPR in safeguarding innovations.
Ans: Intellectual Property Rights (IPR) protect innovations by granting creators exclusive control over their inventions, preventing unauthorized use and ensuring financial rewards, which encourages further creativity and economic growth.
30. 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.
| Mathematics | 85 |
| Science | 90 |
| English | 78 |
| History | 88 |
Ans:
import pandas as pd
import numpy as np
marks = np.array([85, 90, 78, 88])
series = pd.Series(marks, index=['Mathematics', 'Science', 'English', 'History'])
print(series)
OR
Write a Python program to create the Pandas DataFrame displayed below using a list of dictionaries.
| Course | Duration | |
|---|---|---|
| 0 | Data Science | 12 |
| 1 | Artificial Intelligence | 18 |
| 2 | Web Development | 6 |
Ans:
import pandas as pd
d1 = {'Course': 'Data Science', 'Duration': 12}
d2 = {'Course': 'Artificial Intelligence', 'Duration': 18}
d3 = {'Course': 'Web Development', 'Duration': 6}
data = [d1, d2, d3]
df = pd.DataFrame(data)
print(df)
31. I. Write an SQL statement to create a table named EMPLOYEES, with the following specifications:
| Column Name | Data Type | Key |
|---|---|---|
| EmployeeID | Numeric | Primary Key |
| EmpName | Varchar(25) | |
| HireDate | Date | |
| Salary_in_Lacs | Float(4,2) |
Ans: CREATE TABLE EMPLOYEES (
EmployeeID NUMERIC PRIMARY KEY,
EmpName VARCHAR(25),
HireDate DATE,
Salary_in_Lacs FLOAT(4,2)
);
II. Write an SQL Query to insert the following data into the EMPLOYEES table: 101, Ravi Kumar, 2015-06-01, 1.70
Ans: INSERT INTO EMPLOYEES
(EmployeeID, EmpName, HireDate, Salary_in_Lacs)
VALUES (101, 'Ravi Kumar', '2015-06-01', 1.70);
32. Consider the following tables:
Table 1: STUDENT, which stores StudentID, Name, and Class.
| StudentID | Name | Class |
|---|---|---|
| 1 | Ankit | 12 |
| 2 | Priya | 11 |
| 3 | Rohan | 12 |
| 4 | Shreya | 11 |
| 5 | Rehan | 12 |
Table 2: MARKS, which stores StudentID, Subject, and Score
| StudentID | Subject | Score |
|---|---|---|
| 1 | Mathematics | 85 |
| 2 | Physics | 78 |
| 3 | Chemistry | 88 |
| 4 | Biology | 81 |
| 6 | Computer Science | 93 |
Write appropriate SQL queries for the following:
I. List the names of students enrolled in Class 12, sorted in ascending order.
Ans: SELECT Name FROM STUDENT WHERE Class = 12 ORDER BY Name ASC;
II. Display name of all subjects in uppercase where students scored more than 80 marks.
Ans: SELECT UPPER(Subject) FROM MARKS WHERE Score > 80;
III. Display the names of students along with their subject and Score.
Ans: SELECT Name, Subject, Score
FROM STUDENT JOIN MARKS
ON STUDENT.StudentID = MARKS.StudentID;
OR
Consider the following table EMPLOYEE, which stores EmployeeID, Name, Department and Salary.
Table: EMPLOYEE
| EmployeeID | Name | Department | Salary |
|---|---|---|---|
| 101 | Aman | IT | 60000 |
| 102 | Rahul | HR | 50000 |
| 103 | Priya | IT | 70000 |
| 104 | Neha | Finance | 55000 |
| 105 | Rahul | IT | 60000 |
I. Which attribute in the Table can be considered as the Primary Key? Provide justification for your answer.
Ans: EmployeeID can be considered as Primary Key because it uniquely identifies each employee in the table.
II. Write a suitable SQL query to add a new column, Experience, of numeric data type to the table.
Ans: ALTER TABLE Employee ADD Experience INT;
III. Write the output of the following SQL Query.
SELECT Department, COUNT(*) FROM Employee GROUP BY Department;
Ans:
| Department | COUNT(*) |
|---|---|
| IT | 3 |
| HR | 1 |
| Finance | 1 |
SECTION D (2x4=8 Marks)
33. 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.
| Month | Revenue (in Lacs) |
|---|---|
| January | 50 |
| February | 65 |
| March | 75 |
| April | 80 |
| May | 95 |
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()
I. Write the suitable code for the import statement in the blank space in the line marked as Statement-1.
Ans: import matplotlib.pyplot
II. 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.
Ans: plt.plot(Months, Revenue, label='Revenue (in Lacs')
III. Fill in the blank in Statement-3 with the correct Python code to set the title of the graph.
Ans: plt.title('Monthly Revenue Analysis')
IV. Fill in the blank in Statement-4 with the appropriate Python code to save the graph as an image file named monthly_revenue.png.
Ans: plt.savefig('monthly_revenue.png')
34. Raghav, who works as a database designer, has created a table Student as shown below:
Table : Student
| StudentID | Name | City | Marks | Admission_Date |
|---|---|---|---|---|
| 101 | Aarav Sharma | Delhi | 85 | 2022-04-01 |
| 102 | Priya Iyer | Mumbai | 78 | 2021-05-15 |
| 103 | Rohan Verma | Bangalore | 92 | 2020-06-10 |
| 104 | Simran Patel | Delhi | 88 | 2022-03-20 |
| 105 | Karan Yadav | Mumbai | 75 | 2021-08-05 |
Write suitable SQL query for the following.
I. Show the Name and City of the students, both in uppercase, sorted alphabetically by Name.
Ans: SELECT UPPER(Name), UPPER(City) FROM Student ORDER BY Name;
II. Display the Student ID along with the name of the month in which the student was admitted to the school.
Ans: SELECT StudentID, MONTHNAME(Admission_Date) FROM Student;
III. Calculate and display the average marks obtained by students.
Ans: SELECT AVG(Marks)FROM Student;
IV. Show the names of the cities and the number of students residing in the city.
Ans: SELECT City, COUNT(*) FROM Student GROUP BY City;
OR
Consider the following table and write the output of the following SQL Queries.
Table : Student
| StudentID | Name | DateofBirth | Marks | City |
|---|---|---|---|---|
| 301 | Aryan | 15-03-2005 | 88 | Delhi |
| 302 | Ayesha | NULL | 90 | NULL |
| 304 | Aditi | NULL | 85 | Pune |
| 305 | Rajesh | 11-01-2006 | 72 | NULL |
| 306 | Maria | 29-04-2005 | 95 | Chennai |
Write the output of the following SQL Queries.
I. SELECT Name, LENGTH(Name) FROM Student WHERE StudentID < 303;
Ans:
| Name | LENGTH(Name) |
|---|---|
| Aryan | 5 |
| Ayesha | 6 |
II. SELECT lower(Name) FROM Student WHERE MONTH(DateofBirth)= 3;
Ans:
| lower(Name) |
|---|
| aryan |
III. SELECT AVG(Marks) FROM Student;
Ans:
| AVG(Marks) |
|---|
| 86.0000 |
IV. SELECT Name, Marks FROM Student WHERE Marks BETWEEN 90 AND 100;
Ans:
| Name | Marks |
|---|---|
| Ayesha | 90 |
| Maria | 95 |
SECTION E (3x5=15 Marks)
35. 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:
| Administration to Sales | 60 meters |
| Administration to Development | 90 meters |
| Administration to Support | 120 meters |
| Sales to Development | 50 meters |
| Sales to Support | 70 meters |
| Development to Support | 45 meters |
| Mumbai Office to Jaipur | 1400 kilometers |
The number of computers in each department/office is as follows:
| Administration | 120 |
| Sales | 40 |
| Development | 70 |
| Support | 25 |
| Jaipur Office | 50 |
As a network engineer, you have to propose solutions for various queries listed from I to V.
I. Suggest the most suitable department in the Mumbai Office Setup, to install the server. Also, give a reason to justify your suggested location.
Ans: The server should be installed in the Administration department as it has the most number of computers.
II. Draw a suitable cable layout of wired network connectivity between the departments in the Mumbai Office.
Ans:
III. Which hardware device will you suggest to connect all the computers within each department?
Ans: Switch / Hub
IV. Suggest the most appropriate type of network (LAN, MAN, WAN) to connect the Mumbai Head Office and Jaipur Regional Office.
Ans: WAN (Wide Area Network), as the offices are located in different cities.
V. 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?
Ans: Repeater
36. Consider the DataFrame df shown below.
| Name | Department | Salary | |
|---|---|---|---|
| 0 | Rohan Sharma | IT | 75000 |
| 1 | Meera Kapoor | HR | 68000 |
| 2 | Aarav Singh | Finance | 85000 |
| 3 | Nisha Singh | Marketing | 72000 |
| 4 | Aditya Verma | IT | 80000 |
Write Python statements for the following tasks:
I. Print the last three rows of the DataFrame df.
Ans: print(df.tail(3))
II. Add a new column named "Experience" with values [5, 8, 10, 6, 7].
Ans: df['Experience'] = [5, 8, 10, 6, 7]
III. Delete the column "Salary" from the DataFrame.
Ans: df.drop(columns=['Salary'], inplace=True)
IV. Rename the column "Department" to "Dept".
Ans: df.rename(columns={'Department': 'Dept'}, inplace=True)
V. Display only the "Name" and "Salary" columns from the DataFrame.
Ans: print(df[["Name", "Salary"]])
37. Write suitable SQL query for the following:
I. To extract the first five characters from the product_code column in the Products table.
Ans: SELECT LEFT(product_code, 5) FROM Products;
II. To display the total number of orders from Order_Id column in the Orders table.
Ans: SELECT COUNT(Order_Id) FROM Orders;
III. To display the year of the order dates from the order_date column in the Orders table.
Ans: SELECT YEAR(order_date) FROM Orders;
IV. To display the Address column from the Customers table after removing leading and trailing spaces
Ans: SELECT TRIM(Address) FROM Customers;
V. To display the current date.
Ans: SELECT DATE(NOW());
OR
Write suitable SQL query for the following:
I. To display the total number of characters in the string DatabaseSystems.
Ans: SELECT LENGTH('DatabaseSystems');
II. Find the position of the first occurrence of the letter 'a' in the Product_Name column of the Products table.
Ans: SELECT INSTR(Product_Name, 'a') FROM Products;
III. Calculate the square of the Amount for each transaction in the Tran_Amount column of the Transactions table.
Ans: SELECT POWER(Tran_Amount, 2) FROM Transactions;
IV. To display the average salary from the Salaries column in the Employees table.
Ans: SELECT AVG(Salaries) FROM Employees;
V. Display the total sum of the Salary from the Salary column in the Employees table.
Ans: SELECT SUM(Salary) FROM Employees;
Download Now - Class 12 IP 065 Sample Question Paper 2025-26 with Solution
