CBSE Class 12 Informatics Practices 2026 Sample Question Paper

About this paper

This is the CBSE Class 12 Informatics Practices (065) sample question paper (SQP) for the 2026 board exam. It carries 70 marks across 37 questions. Every question has a worked answer with an explanation: choose Solved Ans above to study them. You can read the paper here or download the PDF to practise offline.

Marks by unit

Data Handling using Pandas and Data Visualization: 25 marks · Database Query using SQL: 25 marks · Introduction to Computer Networks: 10 marks · Societal Impacts: 10 marks

Marks by chapter

Chapter	Marks
Data Handling Using Pandas – I	20
Plotting with PyPlot	4
Importing/Exporting Data (CSV & MySQL)	1
MySQL SQL Revision Tour	5
MySQL Functions	14
Querying Using SQL	3
Joins and Set Operations (SQL)	3
Introduction to Computer Networks	7
Introduction to Internet and Web	3
Societal Impacts	10

Questions in this paper

1. Q1 (1 mark, Data Handling Using Pandas – I) State whether the following statement is True or False: The drop() method can be used to remove rows or columns from a Pandas DataFrame.
2. Q2 (1 mark, MySQL Functions) What will be the result of the following SQL query? SELECT MOD(5, 6);
3. Q3 (1 mark, Societal Impacts) 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…
4. Q4 (1 mark, Importing/Exporting Data (CSV & MySQL)) Which of the following Python statements is used to write a Pandas DataFrame df to a CSV file?
5. Q5 (1 mark, Introduction to Computer Networks) Which of the following device is used for converting digital signals from a computer into analog signals for transmission over a telephone line.
6. Q6 (1 mark, MySQL Functions) What is the purpose of the ROUND(num, 0) in SQL, assuming num is a number with a fractional part?
7. Q7 (1 mark, Societal Impacts) Aarushi has written a novel and wants to protect her literary work. Which type of Intellectual Property right will help her do that?
8. Q8 (1 mark, Data Handling Using Pandas – I) The default index used in a Pandas Series, if no index is explicitly specified, is _____
9. Q9 (1 mark, MySQL SQL Revision Tour) Consider a table named Students that has one primary key and three alternate keys. How many candidate keys does the table have?
10. Q10 (1 mark, Introduction to Internet and Web) Which of the following is an application of VoIP technology?
11. Q11 (1 mark, Querying Using SQL) Which of the following SQL function is used to count the non-NULL values in a column named column_name?
12. Q12 (1 mark, Data Handling Using Pandas – I) When two Pandas Series with different indices are added, the result is _____.
13. Q13 (1 mark, Societal Impacts) In India, the primary law that deals e-commerce and cybercrime is _____.
14. Q14 (1 mark, Querying Using SQL) Which SQL command is used to sort rows in either ascending or descending order of values in a specific column?
15. Q15 (1 mark, Data Handling Using Pandas – I) 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?
16. Q16 (1 mark, Introduction to Computer Networks) In which network topology is every node directly connected to every other node?
17. Q17 (1 mark, MySQL Functions) What is the use of the INSTR() function in SQL?
18. Q18 (1 mark, Data Handling Using Pandas – I) Which of the following Python statements creates an empty Pandas DataFrame (Note: pd is an alias for pandas)?
19. Q19 (1 mark, Querying Using SQL) Which of the following is NOT an aggregate function in SQL?
20. Q20 (1 mark, Data Handling Using Pandas – I) 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…
21. Q21 (1 mark, MySQL SQL Revision Tour) 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 st…
22. Q22 (2 marks, Data Handling Using Pandas – I) (A) What is a DataFrame in Pandas? Mention any one property of DataFrame. OR (B) List any two differences between Series and DataFrame in Pandas.
23. Q23 (2 marks, Societal Impacts) What is e-waste? Mention any one impact of e-waste on the environment.
24. Q24 (2 marks, Data Handling Using Pandas – I) 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.…
25. Q25 (2 marks, Introduction to Internet and Web) (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 serve…
26. Q26 (2 marks, MySQL Functions) Write SQL queries to perform the following: I. Display the name of the day (e.g., Monday, Tuesday) for the date '2026-01-01'. II. Find and display the position…
27. Q27 (2 marks, Societal Impacts) Define digital footprints. Differentiate between active and passive digital footprints.
28. Q28 (2 marks, Data Handling Using Pandas – I) (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 = {'Nam…
29. Q29 (3 marks, Societal Impacts) Rahul has recently invented a new type of solar-powered water purification system and is concerned about the possibility of someone illegally copying and selli…
30. Q30 (3 marks, Data Handling Using Pandas – I) (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 th…
31. Q31 (3 marks, MySQL SQL Revision Tour) I. Write an SQL statement to create a table named EMPLOYEES, with the following specifications: Column Name | Data Type | Key EmployeeID | Numeric | Primary Ke…
32. Q32 (3 marks, Joins and Set Operations (SQL)) (A) Consider the following tables: Table 1: STUDENT, which stores StudentID, Name, and Class. StudentID | Name | Class 1 | Ankit | 12 2 | Priya | 11 3 | Rohan…
33. Q33 (4 marks, Plotting with PyPlot) 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.…
34. Q34 (4 marks, MySQL Functions) (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 |…
35. Q35 (5 marks, Introduction to Computer Networks) 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 offic…
36. Q36 (5 marks, Data Handling Using Pandas – I) Consider the DataFrame df shown below. | Name | Department | Salary 0 | Rohan Sharma | IT | 75000 1 | Meera Kapoor | HR | 68000 2 | Aarav Singh | Finance | 850…
37. Q37 (5 marks, MySQL Functions) (A) Write suitable SQL query for the following: I. To extract the first five characters from the product_code column in the Products table. II. To display the…