CBSE Class 12 Informatics Practices 2026 Main Paper (Set 1)

About this paper

This is the CBSE Class 12 Informatics Practices (065) board exam question paper (Set 1), 2026. 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	19
Plotting with PyPlot	5
Importing/Exporting Data (CSV & MySQL)	1
MySQL SQL Revision Tour	6
MySQL Functions	14
Querying Using SQL	2
Joins and Set Operations (SQL)	3
Introduction to Computer Networks	8
Introduction to Internet and Web	2
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: In Pandas Series, the Positional index can be a string or an integer.
2. Q2 (1 mark, Data Handling Using Pandas – I) We can add a new row to a DataFrame DF using the _______ method.
3. Q3 (1 mark, Societal Impacts) Naveen discarded various types of waste material without realizing that e-waste contains harmful substances that could pollute the environment. He wants to kno…
4. Q4 (1 mark, Plotting with PyPlot) In which scenario is a bar chart preferred over a line chart?
5. Q5 (1 mark, Introduction to Computer Networks) Which of the following network topology uses a central cable (backbone) to connect all devices?
6. Q6 (1 mark, Querying Using SQL) 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.
7. Q7 (1 mark, Societal Impacts) 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 h…
8. Q8 (1 mark, Data Handling Using Pandas – I) Aditya is working on a DataFrame named df. He has written the statement: print(df.loc['S2']) What will the above statement do?
9. Q9 (1 mark, MySQL Functions) What will be the result of the following SQL command? SELECT LENGTH ('Data Base'); (Note: There is a single space between the words Data and Base.)
10. Q10 (1 mark, Introduction to Internet and Web) Which of the following is a key feature of a Static Web Page?
11. Q11 (1 mark, MySQL SQL Revision Tour) Which of the following is the correct expanded form of DML?
12. Q12 (1 mark, Importing/Exporting Data (CSV & MySQL)) CSV stands for _______ Separated Values.
13. Q13 (1 mark, Societal Impacts) Which of the following is an example of maintaining good net etiquette?
14. Q14 (1 mark, Data Handling Using Pandas – I) In the context of creating a Pandas Series from a dictionary, which of the following statement is correct?
15. Q15 (1 mark, Data Handling Using Pandas – I) 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?
16. Q16 (1 mark, Introduction to Internet and Web) 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?
17. Q17 (1 mark, MySQL Functions) State whether the following statement is True or False: The INSTR (string1, string2) function in SQL returns 0 if string2 is not present as a substring in stri…
18. Q18 (1 mark, Data Handling Using Pandas – I) In a Pandas DataFrame, which value for axis will be used to delete a column?
19. Q19 (1 mark, MySQL Functions) What will be the result of the following SQL command: SELECT ROUND(15.678, 2);
20. Q20 (1 mark, Data Handling Using Pandas – I) Assertion (A): Pandas DataFrame can store values of multiple data types in multiple Columns. Reason (R): DataFrames are implemented using 2D arrays, which allo…
21. Q21 (1 mark, Querying Using SQL) 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 NU…
22. Q22 (2 marks, Data Handling Using Pandas – I) (a) List any two characteristics of Pandas library in Python. OR (b) Briefly explain the purpose of Boolean Indexing with respect to DataFrames. Support your a…
23. Q23 (2 marks, Societal Impacts) 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 menti…
24. Q24 (2 marks, MySQL SQL Revision Tour) Define the following terms with respect to RDBMS: a. Domain b. Tuple
25. Q25 (2 marks, Introduction to Computer Networks) (a) Explain the role of the following network devices in a network: (I) Modem (II) Gateway OR (b) Differentiate between add-ons and plug-ins in a web browser.
26. Q26 (2 marks, MySQL Functions) Write SQL queries to perform the following: (I) Display the month (in numeric form) of the date '2026-01-01'. (II) Display only the year part from the date '20…
27. Q27 (2 marks, Societal Impacts) (a) What is data protection? (b) Mention any two precautionary measures one can take to avoid the risk of cybercrime.
28. Q28 (2 marks, Data Handling Using Pandas – I) (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'…
29. Q29 (3 marks, Societal Impacts) 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 amou…
30. Q30 (3 marks, Data Handling Using Pandas – I) (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 - J…
31. Q31 (3 marks, MySQL SQL Revision Tour) (i) Write an SQL statement to create a table named PRODUCTS with the following specifications: Column Name | Data Type | Key --- | --- | --- PId | Integer | Pr…
32. Q32 (3 marks, Joins and Set Operations (SQL)) (a) Consider the following tables: Table 1: TEACHER, which stores Teacher ID (TID), Teacher Name (TName), Experience (Experience) and City (City) that they liv…
33. Q33 (4 marks, Plotting with PyPlot) 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…
34. Q34 (4 marks, MySQL Functions) (a) Write a suitable SQL query based on the Guest table: (I) Display last 3 characters of guest name in upper case. (II) Display the name of the guest along wi…
35. Q35 (5 marks, Introduction to Computer Networks) My Solutions Pvt. Ltd. network design case study (Mysuru HQ, Chennai Regional). Mysuru computers: HR (30), Research (80), Design (50), Tech Support (20). I. Id…
36. Q36 (5 marks, Data Handling Using Pandas – I) Consider the DataFrame 'Scholarship'. Answer the following: I. Write Python code to create and display the given DataFrame using the Dictionary of Series metho…
37. Q37 (5 marks, MySQL Functions) (a) Write suitable SQL query for the following: I. Display only the date part from the date/time expression '2026-01-01 10:10:10'. II. Convert all customer nam…