CBSE Class 12 Informatics Practices 2025 Compartmental Exam

About this paper

This is the CBSE Class 12 Informatics Practices (065) compartment (supplementary) exam paper, 2025. 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	17
Plotting with PyPlot	4
Importing/Exporting Data (CSV & MySQL)	4
MySQL SQL Revision Tour	9
MySQL Functions	9
Querying Using SQL	6
Joins and Set Operations (SQL)	1
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: "Series data structure of Pandas can hold the value of integer data type only."
2. Q2 (1 mark, MySQL Functions) What will be the output of the following SQL command? SELECT MOD (20,6);
3. Q3 (1 mark, Introduction to Internet and Web) Webpages showing stock prices and weather update changes frequently, therefore such webpages are:
4. Q4 (1 mark, Joins and Set Operations (SQL)) State True or False: Equi-join in SQL combines and displays data from two or more relations based on matching values in common attribute.
5. Q5 (1 mark, Societal Impacts) The fraudulent act of obtaining the personal information of another person to commit online fraud, is called:
6. Q6 (1 mark, Data Handling Using Pandas – I) Which of the following functions is used to delete a row from a DataFrame?
7. Q7 (1 mark, Data Handling Using Pandas – I) _____ is the type of indexing that allows us to filter a DataFrame by applying a condition. (Label Indexing / Boolean Indexing)
8. Q8 (1 mark, MySQL Functions) What will be the output of the following SQL query? SELECT MID ('INCREDIBLE INDIA', 6,3);
9. Q9 (1 mark, Importing/Exporting Data (CSV & MySQL)) Which of the following is the correct full form of CSV?
10. Q10 (1 mark, Societal Impacts) Which of the following statements is true about Copyright?
11. Q11 (1 mark, Querying Using SQL) What does the following SQL query do? SELECT name, COUNT(*) FROM students GROUP BY name HAVING COUNT(*) > 1;
12. Q12 (1 mark, Introduction to Computer Networks) I help to regenerate and amplify the signals to ensure reliable communication over long distances. Who am I?
13. Q13 (1 mark, Data Handling Using Pandas – I) NumPy stands for _____ Python.
14. Q14 (1 mark, Societal Impacts) Which of the following is a potential hazard associated with e-waste disposal?
15. Q15 (1 mark, Data Handling Using Pandas – I) To create a Pandas series from an ndarray 'array1', which of the following statements can be used? (Note: Assume pd as alias for pandas)
16. Q16 (1 mark, MySQL SQL Revision Tour) The ALTER command in SQL can be used to:
17. Q17 (1 mark, Importing/Exporting Data (CSV & MySQL)) Which method is used to store data from a Pandas DataFrame 'dF' into a csv file?
18. Q18 (1 mark, Data Handling Using Pandas – I) How can we add a new column named 'name' to a DataFrame 'dF'? (Note: Assume the values for the column are stored in a list named 'data')
19. Q19 (1 mark, Introduction to Computer Networks) Name the device that converts data from digital to analog and vice versa in a network.
20. Q20 (1 mark, Data Handling Using Pandas – I) Assertion (A): Pandas is a high level data manipulation tool used for analyzing data. Reason (R): It is very easy to import and export data using the Pandas li…
21. Q21 (1 mark, MySQL SQL Revision Tour) Assertion (A): There can be multiple primary keys in a relation. Reason (R): There can be multiple candidate keys in a relation but only one of these is chosen…
22. Q22 (2 marks, Data Handling Using Pandas – I) (a) What is DataFrame in Pandas? Explain with the help of an example. OR (b) What is data visualization? Also mention its any one main purpose.
23. Q23 (2 marks, Societal Impacts) Mention any two health concerns associated with excessive usage of technology.
24. Q24 (2 marks, MySQL Functions) Write SQL Queries to perform the following task: (i) Extract the leftmost 5 characters after removing the leading and trailing spaces from "DESIGN THINKING" (i…
25. Q25 (2 marks, Introduction to Internet and Web) (a) What is a Web Server? OR (b) Write any one advantage and one disadvantage of bus topology.
26. Q26 (2 marks, Querying Using SQL) What are aggregate functions in SQL? Name any two aggregate functions.
27. Q27 (2 marks, Societal Impacts) What is a digital footprint? Also, provide two examples of how it's created.
28. Q28 (2 marks, Importing/Exporting Data (CSV & MySQL)) (a) Arjun is trying to load data from a CSV file, where values are separated by commas, into a DataFrame using Pandas, but his code has errors. Identify the mi…
29. Q29 (3 marks, Societal Impacts) Akshay is writing a research paper and directly copies several paragraphs from an online article without crediting the original author. (i) Identify the act of…
30. Q30 (3 marks, Data Handling Using Pandas – I) (a) Write a Python Program to create a DataFrame using a list of dictionaries with the following data: Student | Marks 0 | Aarav | 85 1 | Aisha | 90 2 | Vivaan…
31. Q31 (3 marks, MySQL SQL Revision Tour) (a) Write the SQL statement to create a table Customer with the following specifications: Table: Customer Column Name | Data Type | Key CID | Numeric | Primary…
32. Q32 (3 marks, Querying Using SQL) (a) Given the following tables: Table: EMPLOYEES EMP_ID | EMP_NAME | DEPARTMENT | JOIN_DATE Table: PROJECTS Project_ID | EMP_ID | PROJECT_NAME | HOURS Write SQ…
33. Q33 (4 marks, Plotting with PyPlot) You are a data analyst at a retail company. The company wants to analyse its monthly sales data for the year 2024 to identify trends and make informed business…
34. Q34 (4 marks, MySQL SQL Revision Tour) (a) Moulik is a database manager at a retail company. The company maintains a Customer table in their database to track customer information. Table: Customer c…
35. Q35 (5 marks, Introduction to Computer Networks) ABC Innovators Pvt. Ltd., Bengaluru is a company specializing in IoT solutions. They have different departments : Research, Development, Marketing and IT Suppo…
36. Q36 (5 marks, Data Handling Using Pandas – I) Consider the DataFrame dF shown below: PRODUCT_ID | PRODUCT_NAME | CATEGORY | PRICE P001 | Laptop | Electronics | 60000 ... Write Python statements for the Dat…
37. Q37 (5 marks, MySQL Functions) (a) Write suitable SQL query for the following: (i) Display the minimum value in the Salary column from the EMPLOYEES table. (ii) Display the FirstName column…