CBSE Class 12 Informatics Practices 2027 Sample Question Paper

About this paper

This is the CBSE Class 12 Informatics Practices (065) sample question paper (SQP) for the 2027 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	17
Plotting with PyPlot	7
Importing/Exporting Data (CSV & MySQL)	1
MySQL SQL Revision Tour	9
MySQL Functions	10
Querying Using SQL	2
Joins and Set Operations (SQL)	4
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) A Pandas Series S1 is created with index labels ['a', 'b', 'c', 'd', 'e']. State whether the following statement is True or False: "The statement S1['b':'d'] w…
2. Q2 (1 mark, MySQL Functions) Ravi needs to find the total number of characters in the StudentName column. Which SQL function should he use?
3. Q3 (1 mark, Societal Impacts) Which type of Intellectual Property Right (IPR) protects an invention by giving the creator exclusive rights to make, use, and sell it for a specific period?
4. Q4 (1 mark, Plotting with PyPlot) While plotting a graph using Matplotlib, which function is used to specify the label for the Y-axis?
5. Q5 (1 mark, Introduction to Computer Networks) I am a networking device that converts digital data from a computer into analog signals for transmission, and then converts incoming analog signals back into d…
6. Q6 (1 mark, MySQL SQL Revision Tour) Which of the following is a Data Manipulation Language (DML) command in SQL?
7. Q7 (1 mark, Societal Impacts) The process of re-selling old electronic goods after minor repairs or modification is called:
8. Q8 (1 mark, Data Handling Using Pandas – I) What will be the output of the following code? import pandas as pd print(pd.Series(5, index=[0, 1, 2]))
9. Q9 (1 mark, Querying Using SQL) Fill in the blank: The SQL clause used to filter the groups formed by the GROUP BY clause based on a specific condition is ____________.
10. Q10 (1 mark, Introduction to Internet and Web) Riya visited an online shopping website, and it saved small text files on her computer to remember her preferences and session details. What are these files ca…
11. Q11 (1 mark, Querying Using SQL) Which keyword is used with the ORDER BY clause to sort data in descending order?
12. Q12 (1 mark, Data Handling Using Pandas – I) If we add two Pandas Series that do not have matching index labels, the result for those non-matching indices will be:
13. Q13 (1 mark, Societal Impacts) The process of buying electronic gadgets only when necessary to minimize the generation of electronic waste is an example of which 'R' of e-waste management?
14. Q14 (1 mark, MySQL Functions) Which SQL function is used to extract a specific number of characters from a string starting from a given position?
15. Q15 (1 mark, Importing/Exporting Data (CSV & MySQL)) Aman is exporting a Pandas DataFrame to a CSV file using the to_csv() function. He wants to save only the data and avoid writing the row indices to the file. W…
16. Q16 (1 mark, Introduction to Internet and Web) Fill in the blank: The process of storing a website on a web server so that it can be accessed over the internet is known as ________.
17. Q17 (1 mark, MySQL SQL Revision Tour) A HR manager queries an employee database. He wants to retrieve only those records where the Commission field actually contains a value. Which SQL condition sh…
18. Q18 (1 mark, Data Handling Using Pandas – I) When creating a DataFrame from a list of dictionaries, the dictionary keys become:
19. Q19 (1 mark, MySQL SQL Revision Tour) State whether the following statement is True or False: In SQL, the BETWEEN operator is inclusive of both the lower and upper values specified in the range.
20. Q20 (1 mark, Data Handling Using Pandas – I) Assertion (A) The statement df.drop('Science', axis=0) will remove the column labeled 'Science' from the DataFrame. Reason (R) In Pandas drop() method, axis=0…
21. Q21 (1 mark, MySQL SQL Revision Tour) Assertion (A) In SQL, the query select * from emp; and SELECT * FROM EMP; will produce the same result. Reason (R) SQL is a case-sensitive language.
22. Q22 (2 marks, Data Handling Using Pandas – I) (A) (i) Explain the use of the head() function in a Pandas DataFrame. (ii) What happens if the parameter n is not specified in the head() function? OR (B) Expl…
23. Q23 (2 marks, Societal Impacts) Differentiate between an Active and a Passive digital footprint.
24. Q24 (2 marks, Plotting with PyPlot) Define Data Visualization and state its primary purpose.
25. Q25 (2 marks, Introduction to Computer Networks) (A) Define Star Topology. Mention one major advantage of using it. OR (B) What is VoIP? State any one advantages of using VoIP for communication.
26. Q26 (2 marks, MySQL Functions) Write SQL queries for the following requirements: (i) Display the last 3 characters of the attribute Ename from the EMPLOYEE table. (ii) Find the position of t…
27. Q27 (2 marks, Societal Impacts) Mention and briefly explain any two guidelines of netiquette.
28. Q28 (2 marks, Data Handling Using Pandas – I) (A) Consider the following two dictionaries: dict1 = {'a': 10, 'b': 20} dict2 = {'a': 5, 'b': 10, 'c': 20} Write Python code to create a DataFrame from a list…
29. Q29 (3 marks, Societal Impacts) Consider the following digital security scenarios and answer the questions: (i) Mehak receives an SMS from an unknown number stating she has won a lottery. To…
30. Q30 (3 marks, Data Handling Using Pandas – I) (A) (i) Write a Python program to create a Pandas Series named Inventory from the following dictionary: stock = {'Pens': 150, 'Erasers': 80, 'Sharpeners': 60,…
31. Q31 (3 marks, MySQL Functions) Consider the table HOSPITAL, which contains the following columns: Column Name | Remark PNo | Patient Number PName | Patient Name Dept | Department DOA | Date…
32. Q32 (3 marks, MySQL Functions) (A) Consider a table named STUDENT containing the following data: ID | Name | DOB 1 | Aman | 2005-08-15 2 | Vinod | 2006-01-26 3 | Saurabh | 2004-01-01 Write t…
33. Q33 (4 marks, Plotting with PyPlot) Write a Python program using Matplotlib to plot a Line Graph showing the "Monthly Sales" of a shop with the following data: Months: ['Jan', 'Feb', 'Mar', 'Apr'…
34. Q34 (4 marks, Joins and Set Operations (SQL)) (A) Consider the following tables: Table: SPORTS RegNo | SName | Game | Fees 101 | Aryan | Cricket | 500 102 | Riya | Tennis | 600 103 | Kabir | Cricket | 500…
35. Q35 (5 marks, Introduction to Computer Networks) Tech-Innovate Pvt Ltd is a leading technology solutions provider renowned for delivering innovative digital services to clients worldwide. The company operates…
36. Q36 (5 marks, Data Handling Using Pandas – I) (i) Create a DataFrame named StoreDF as shown below using dictionary of series: Items | Quantity | Unit_Price 0 Bread | 50 | 30 1 Milk | 100 | 25 2 Eggs | 120…
37. Q37 (5 marks, MySQL SQL Revision Tour) (A) Refer to the table given below: Table: BOOK BookID | Title | Author | Price 201 | Wings of Fire | A P J Abdul Kalam | 350 202 | The Guide | R. K. Narayan |…