The CBSE Class 12 Informatics Practices (065) Sample Question Paper 2026 with Solution has been officially released, offering a clear preview of the updated exam structure and question types. Based on the latest CBSE guidelines for the 2025–26 academic session, this sample paper is a must-have for both students and teachers.
The CBSE Class 12 Informatics Practices Sample Paper 2026 helps students become familiar with the latest question paper design and marking scheme, reducing exam-day surprises. By solving the paper, students can evaluate their preparation level, identify weak topics, and revise accordingly. It also encourages students to write answers within the prescribed word limit and in the correct format, which is crucial for scoring full marks. The sample paper includes a balanced mix of theory and practical-based questions, offering board-level practice that boosts both accuracy and confidence.
For teachers, this sample paper serves as a valuable teaching aid. It can be used to design class tests, pre-board question papers, and practice assignments aligned with the CBSE pattern. They can also use it to train students in time management and proper answer presentation. Additionally, it helps educators to structure lesson plans and revision strategies effectively, ensuring that classroom teaching remains focused on expected board exam outcomes.
CBSE Class 12 Informatics Practices 065 Sample Question Paper 2026 with Solution
SAMPLE QUESTION PAPER (THEORY)
CLASS: XII SESSION: 2025-26
INFORMATICS PRACTICES (065)
Time allowed: 3 Hours
Maximum Marks: 70
General Instructions:
● 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 3 questions (29 to 32). Each question carries 3 Marks.
● Section D consists of 4 questions (33 to 34). Each question carries 4 Marks.
● Section E consists of 2 questions (35 to 37). Each question carries 5 Marks.
● There is no overall choice. However, 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 (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()
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. (A) 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
(B) List any two differences between Series and DataFrame in Pandas.
Ans: A Series is 1-dimensional, while a DataFrame is 2-dimensional.
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:pandas
{'January': 31, 'February': 28, 'March': 31}
Series
25. (A) 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
(B) Explain the concept of VoIP and mention one benefit of using it.
Ans: VoIP allows voice communication over the internet.
Benefit: Cost-effective
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. (A) 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)
OR
(B) 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)
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. (A) 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
(B) Write a Python program to create the Pandas DataFrame displayed below using a list of dictionaries.
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
(B) 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;
| 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 |
______ 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. (A) 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 Verma | 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
(B) 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;
| Name | LENGTH(Name) |
| Aryan | 5 |
| Ayesha | 6 |
(ii) SELECT lower(Name) FROM Student WHERE MONTH(DateofBirth)= 3;
| lower(Name) |
| aryan |
(iii) SELECT AVG(Marks) FROM Student;
| AVG(Marks) |
| 86.0000 |
(iv) SELECT Name, Marks FROM Student WHERE Marks BETWEEN 90 AND 100;
| 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 Office | 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.
(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.
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;