12 Papers

CBSE Class 12 Informatics Practices 2025 Sample Question Paper

About this paper 37 questions · 70 marks · solved answers

About this paper

This is the CBSE Class 12 Informatics Practices (065) sample question paper (SQP) for the 2025 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

ChapterMarks
Data Handling Using Pandas – I18
Plotting with PyPlot6
Importing/Exporting Data (CSV & MySQL)1
MySQL SQL Revision Tour8
MySQL Functions7
Querying Using SQL10
Introduction to Computer Networks8
Introduction to Internet and Web2
Societal Impacts10

Questions in this paper

  1. Q1 (1 mark, Data Handling Using Pandas – I) State whether the following statement is True or False: Slicing can be used to extract a specific portion from a Pandas Series.
  2. Q2 (1 mark, MySQL SQL Revision Tour) The purpose of WHERE clause in a SQL statement is to:
  3. Q3 (1 mark, Introduction to Computer Networks) Identify the networking device responsible for routing data packets based on their destination addresses.
  4. Q4 (1 mark, MySQL SQL Revision Tour) Identify the SQL command used to delete a relation (table) from a relational database.
  5. Q5 (1 mark, Societal Impacts) e-waste refers to:
  6. Q6 (1 mark, Data Handling Using Pandas – I) Which of the following Python statements can be used to select a column column_name from a DataFrame df ?
  7. Q7 (1 mark, Plotting with PyPlot) By default, the plot() function of Matplotlib draws a ______ plot.
  8. Q8 (1 mark, Querying Using SQL) State whether the following statement is True or False: In SQL, the HAVING clause is used to apply filter on groups formed by the GROUP BY clause.
  9. Q9 (1 mark, Importing/Exporting Data (CSV & MySQL)) Which of the following Python statements is used to import data from a CSV file into a Pandas DataFrame (Note: pd is an alias for pandas)?
  10. Q10 (1 mark, Societal Impacts) What is plagiarism?
  11. Q11 (1 mark, Querying Using SQL) Fill in the Blank The COUNT(*) function provides the total number of __________ within a relation (table) in a relational database.
  12. Q12 (1 mark, Introduction to Computer Networks) In which of the network topologies do all devices connect to a central point, such as a switch or hub?
  13. Q13 (1 mark, Data Handling Using Pandas – I) In a Pandas DataFrame, if the tail() function is used without specifying the optional argument indicating the number of rows to display, what is the default nu…
  14. Q14 (1 mark, Societal Impacts) Identify the type of cybercrime that involves sending fraudulent emails to deceive individuals into revealing sensitive information.
  15. Q15 (1 mark, Data Handling Using Pandas – I) While creating a Series using a dictionary, the keys of the dictionary become:
  16. Q16 (1 mark, MySQL Functions) Match the following SQL functions/clauses with their descriptions: SQL Function | Description P. | MAX() | 1. Find the position of a substring in a string. Q.…
  17. Q17 (1 mark, Data Handling Using Pandas – I) Fill in the Blank Boolean indexing in Pandas DataFrame can be used for _______.
  18. Q18 (1 mark, Plotting with PyPlot) Which Matplotlib plot is best suited to represent changes in data over time?
  19. Q19 (1 mark, Introduction to Computer Networks) Which type of network covers a small geographical area like a single office, building, or school campus?
  20. Q20 (1 mark, Data Handling Using Pandas – I) Assertion (A): We can add a new column in an existing DataFrame. Reason (R): DataFrames are size mutable.
  21. Q21 (1 mark, MySQL SQL Revision Tour) Assertion (A): In SQL, INSERT INTO is a Data Definition Language (DDL) Command. Reason (R): DDL commands are used to create, modify, or remove database structu…
  22. Q22 (2 marks, Data Handling Using Pandas – I) (A) What is a Series in Python Pandas? Also, give a suitable example to support your answer. OR (B) What does the term 'library' signify in Python? Mention one…
  23. Q23 (2 marks, Societal Impacts) What are intellectual property rights (IPR), and why are they important in the digital world?
  24. Q24 (2 marks, MySQL Functions) Consider the string: "Database Management System". Write suitable SQL queries for the following: I. To extract and display "Manage" from the string. II. Displa…
  25. Q25 (2 marks, Introduction to Internet and Web) (A) What is Internet and how does it differ from World Wide Web (WWW)? OR (B) Explain the concept of browser cookies and mention one advantage of using them.
  26. Q26 (2 marks, MySQL SQL Revision Tour) Define the term Primary Key in a database. Explain how it is different from a Candidate Key.
  27. Q27 (2 marks, Societal Impacts) Mention two health concerns associated with excessive use of Digital Devices.
  28. Q28 (2 marks, Data Handling Using Pandas – I) (A) Sneha is writing a Python program to create a DataFrame using a list of dictionaries. However, her code contains some mistakes. Identify the errors, rewrit…
  29. Q29 (3 marks, Societal Impacts) Ayesha's family is replacing their old computer with a new one. They decide to throw the old computer in a nearby empty field/plot. I. Explain any one potentia…
  30. Q30 (3 marks, Data Handling Using Pandas – I) (A) Write a Python program to create the following DataFrame using a list of dictionaries. | Product | Price 0 | Laptop | 60000 1 | Desktop | 45000 2 | Monitor…
  31. Q31 (3 marks, MySQL SQL Revision Tour) I. Write an SQL statement to create a table named STUDENTS, with the following specifications: Column Name | Data Type | Key StudentID | Numeric | Primary Key…
  32. Q32 (3 marks, Querying Using SQL) (A) Consider the following tables: Table 1: EMPLOYEE, which stores Employee ID (EMP_ID), Employee Name (EMP_NAME), Employee City (EMP_CITY) Table 2: PAYROLL, w…
  33. Q33 (4 marks, Plotting with PyPlot) During a practical exam, a student Ankita has to fill in the blanks in a Python program that generates a bar chart. This bar chart represents the number of boo…
  34. Q34 (4 marks, MySQL Functions) (A) Rahul, who works as a database designer, has developed a database for a bookshop. This database includes a table BOOK whose column (attribute) names are me…
  35. Q35 (5 marks, Introduction to Computer Networks) ABC Pvt. Ltd., a multinational technology company, is looking to establish its Indian Head Office in Bengaluru, and a regional office branch in Lucknow. The Be…
  36. Q36 (5 marks, Data Handling Using Pandas – I) Consider the DataFrame df shown below. MovieID Title | Year | Rating 0 | 1 | LAGAAN | 2001 | 8.4 1 | 2 | TAARE ZAMEEN PAR | 2007 | 8.5 2 | 3 | 3 IDIOTS | 2009…
  37. Q37 (5 marks, Querying Using SQL) (A) Write suitable SQL query for the following: I. To display the average score from the test_results column (attribute) in the Exams table. II. To display the…

Download and study this document offline

Download PDF

Loading Preview...