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

About this paper

This is the CBSE Class 12 Informatics Practices (065) board exam question paper (Set 1), 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	20
Plotting with PyPlot	5
MySQL SQL Revision Tour	5
MySQL Functions	12
Querying Using SQL	8
Introduction to Computer Networks	5
Introduction to Internet and Web	5
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 Python, we cannot create an empty DataFrame.
2. Q2 (1 mark, MySQL Functions) What will be the output of the following SQL command? SELECT MONTHNAME('2024-08-02');
3. Q3 (1 mark, Introduction to Internet and Web) Temporary data files stored by websites in our computer can be used to track our online activities and also to personalize browsing experience. These files are…
4. Q4 (1 mark, Querying Using SQL) Which of the following is not an aggregate function in SQL?
5. Q5 (1 mark, Societal Impacts) Raheem created a unique computer software and wants to protect his creation from being copied or used without his permission. He is considering to apply for le…
6. Q6 (1 mark, Data Handling Using Pandas – I) What is the default index type for a Pandas Series if not explicitly specified?
7. Q7 (1 mark, Plotting with PyPlot) In Python which function of matplotlib library is used to save a plot?
8. Q8 (1 mark, MySQL Functions) State whether the following statement is True or False: The MOD() function in SQL returns the quotient of division operation between two numbers.
9. Q9 (1 mark, Data Handling Using Pandas – I) Which of the following data structure is used for storing one-dimensional labelled data in Python Pandas?
10. Q10 (1 mark, Societal Impacts) Priya received an email that appeared to be from her bank, asking her to update her account information by clicking on a link. She clicked the link to enter he…
11. Q11 (1 mark, MySQL Functions) Which SQL function calculates a^b (a raised to the power b)?
12. Q12 (1 mark, Introduction to Internet and Web) Which protocol is used while communicating through video calls on the Internet?
13. Q13 (1 mark, Data Handling Using Pandas – I) Which of the following Python statements will be used to select a specific element having index as points, from a Pandas Series named ser?
14. Q14 (1 mark, Societal Impacts) Excessive screen time and poor posture can lead to:
15. Q15 (1 mark, Data Handling Using Pandas – I) Which of the following libraries defines an ndarray in Python?
16. Q16 (1 mark, MySQL Functions) With respect to SQL, match the function given in column-II with categories given in column-I: I | II (i) Math function | (a) COUNT() (ii) Aggregate function |…
17. Q17 (1 mark, Data Handling Using Pandas – I) Which of the following Python statements is used to change a column label in a DataFrame, df?
18. Q18 (1 mark, Data Handling Using Pandas – I) In Python Pandas, DataFrame. ______ [] is used for label indexing with DataFrames.
19. Q19 (1 mark, Introduction to Internet and Web) Every web page on the Internet has a unique address. This address is known as:
20. Q20 (1 mark, Data Handling Using Pandas – I) Assertion (A): The drop() method in Pandas can be used to delete rows and columns from a DataFrame. Reason (R): The axis parameter in the drop() method specifi…
21. Q21 (1 mark, MySQL Functions) Assertion (A): The ROUND() function in SQL can be used to round off a number to a specified number of decimal places. Reason (R): The ROUND() function is a str…
22. Q22 (2 marks, Data Handling Using Pandas – I) (a) Mention any two main points of difference between Series and DataFrame of Python Pandas. OR (b) Explain how we can access elements of a series using slicin…
23. Q23 (2 marks, Societal Impacts) A small tech startup, is considering using open source software to develop their new project management tool. They are evaluating the benefits and potential ch…
24. Q24 (2 marks, MySQL Functions) Consider the string, "Informatics Practices". Write suitable SQL queries for the following: (i) To convert the entire string to uppercase. (ii) To display the…
25. Q25 (2 marks, Introduction to Internet and Web) (a) Give any two points of difference between Static web page and Dynamic web page. OR (b) Describe the role of a router in a network.
26. Q26 (2 marks, MySQL SQL Revision Tour) What is a Database Management System (DBMS)? Mention any two examples of DBMS.
27. Q27 (2 marks, Societal Impacts) Give any two impacts on environment that are caused when e-waste is carelessly thrown or dumped in landfills or dumping grounds.
28. Q28 (2 marks, Data Handling Using Pandas – I) (a) Rohit is trying to create a Pandas Series from scalar values. His code has some mistakes. Rewrite the correct code and underline the corrections made. impo…
29. Q29 (3 marks, Societal Impacts) Ravi is a student studying in grade 12. He frequently uses the internet for various activities such as social networking, online shopping, and to research for…
30. Q30 (3 marks, Data Handling Using Pandas – I) (a) Write a Python program to create the following DataFrame using a Dictionary of Series: | City | State 0 | Mumbai | Maharashtra 1 | Dehradun | Uttarakhand 2…
31. Q31 (3 marks, MySQL SQL Revision Tour) (i) Write the SQL statement to create a table, Customer with the following specifications: Table: Customer Column Name | Data Type | Key CID | Int | Primary Ke…
32. Q32 (3 marks, Querying Using SQL) (a) Given the following tables: Table: STUDENTS S_ID | NAME | AGE | CITY 1 | Rahul | 20 | Delhi 2 | Priya | 22 | Mumbai 3 | David | 21 | Delhi 4 | Neha | 23 |…
33. Q33 (4 marks, Plotting with PyPlot) Gurkirat has to fill in the blanks in the given Python program that generates a line plot as shown below. The given line plot represents the temperature (in de…
34. Q34 (4 marks, Querying Using SQL) (a) An educational institution is maintaining a database for storing the details of courses being offered. The database includes a table COURSE with the follow…
35. Q35 (5 marks, Introduction to Computer Networks) XYZ Technologies, Hyderabad is a company that deals with data science and AI projects. They have different divisions ADMIN, SALES, PRODUCTION and SERVICE. The…
36. Q36 (5 marks, Data Handling Using Pandas – I) Consider the DataFrame Doctor shown below: | DID | Name | Department | Fee 0 | 101 | Dr. Joe | ENT | 1500 1 | 102 | Dr. Salma | UROLOGY | 1600 2 | 103 | Dr. Je…
37. Q37 (5 marks, MySQL Functions) (a) Write SQL query for the following: (i) To display sum total of all the values of the Score column, from STUDENTS table. (ii) To display the first five char…