Class 12 Sample Paper 2026 Informatics Practices

2026
SAMPLE / MODEL
PAPERS
NCERT BASED
PRACTICE PAPERS
DOWNLOAD PDF

FOR
CBSE BOARD
AND
STATE BOARDS

PRACTICE PAPER
CLASS XII
INFORMATICS PRACTICES (065)
SESSION: 2025-26

Time Allowed: 3 hours Maximum Marks: 70

General Instructions:

 Please check this question paper contains 37 questions.
 All questions are compulsory. However, internal choices have been provided in some
questions. Attempt only one of the choices in such questions
 The paper is divided into 5 Sections- A, B, C, D and E.
 Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
 Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
 Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
 Section D consists of 2 case study type questions (33 to 34). Each question carries 4
Marks.
 Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
 All programming questions are to be answered using Python Language only.
 In case of MCQ, text of the correct answer should also be written.
Q. No. Section-A (21 x 1 = 21 Marks) Marks
1. State whether the following statement is True or False: 1
The iloc[] indexer in Pandas allows selection of rows and columns by
integer positions.
2. Which SQL function is used to find the largest value in a column? 1
A. MAX()
B. HIGH()
C. UPPER()
D. TOP()
3. Rohan received repeated threatening messages on social media from an 1
unknown account. This is an example of:
A. Cyber Grooming
B. Cyber Bullying
C. Hacking
D. Identity Theft
4. Which of the following statements will display the last 5 rows of a 1
DataFrame df?
A. df.first()
B. df.show(5)
C. df.tail()
D. df.top(5)

5. Which of the following network devices regenerates weak signals to 1
extend the transmission distance?
A. Router
B. Modem
C. Repeater
D. Switch
6. Which SQL function returns the remainder of division between two 1
numbers?
A. DIV()
B. MOD()
C. REMAINDER()
D. BALANCE()
7. Sushmita, a movie producer wants to protect the script and dialogues of 1
her film. Which IPR should be used?
A. Trademark
B. Copyright
C. Patent
D. Industrial Design
8. Which of the following statements for a Pandas Series ‘s’ returns its index 1
labels?
A. s.index
B. s.values
C. s.keys()
D. s.labels()
9. In a relational database, a foreign key is used to: 1
A. Uniquely identify each record in a table
B. Define a candidate key
C. Store duplicate values
D. Link two tables together
10. The full form of URL is: 1
A. Uniform Resource Locator
B. Universal Record Link
C. Unique Resource List
D. Uniform Record Locator
11. Which of the following SQL aggregate functions can be used with both 1
numeric and non-numeric columns?
A. SUM()
B. AVG()
C. MAX()
D. COUNT()
12. What will be the result of adding a scalar value to a Pandas Series? 1
A. The scalar value is ignored
B. The scalar is added to each element of the Series
C. The scalar is added to only the first element
D. Error occurs

13. Which government agency in India handles cybercrime investigation and 1
policy enforcement?
A. Indian Cyber Crime Coordination Centre (I4C)
B. National Crime Records Bureau (NCRB)
C. Press Information Bureau (PIB)
D. Telecom Regulatory Authority of India (TRAI)
14. Which of the following SQL queries will display student names in 1
descending order?
A. SELECT Name FROM Students ORDER BY Name DESC;
B. SELECT Name FROM Students SORT BY Name DESC;
C. SELECT Name FROM Students GROUP BY Name DESC;
D. SELECT Name FROM Students ORDER Name DESC;
15. To select rows with labels 2 to 5 (inclusive) in a DataFrame df, which 1
command should be used?
A. df.iloc[2:5]
B. df.loc[2:4]
C. df.loc[2:5]
D. df.iloc[2:6]
16. In which topology are all devices connected to a single central device like 1
a switch or hub?
A. Bus
B. Mesh
C. Ring
D. Star
17. What will be the output of the SQL query: 1
SELECT INSTR('DATABASE', 'A');
A. 2
B. 3
C. 1
D. 0
18. Which of the following commands is used to create a DataFrame from a 1
CSV file named data.csv? (Note: pd is an alias for pandas)
A. pd.create_csv('data.csv')
B. pd.read_csv('data.csv')
C. pd.DataFrame('data.csv')
D. pd.open_csv('data.csv')
19. If a table has 10 rows and 2 of them have NULL in the column AGE, what 1
will COUNT(AGE) return?
A. 10
B. 8
C. 2
D. 0
Q-20 and Q-21 are Assertion (A) and Reason (R) Type questions.
Choose the correct option as:
A. Both Assertion (A) and Reason (R) are true, and Reason (R) is the
correct explanation of Assertion (A)
B. Both Assertion (A) and Reason (R) are true, but Reason (R) is not the

correct explanation of Assertion (A)
C. Assertion (A) is True, but Reason (R) is False
D. Assertion (A) is False, but Reason (R) is True

20. Assertion (A): The command df['Column1'] returns a Pandas Series. (Note: 1
df is a Pandas DataFrame)
Reason (R): Selecting a single column from a DataFrame gives a one-
dimensional object.
21. Assertion (A): The DROP TABLE command deletes the structure and data 1
of a table.
Reason (R): DROP TABLE is a DDL (Data Definition Language) command.
Q. No. Section-B (7 x 2 = 14 Marks) Marks
22. A. What type of data structure is a DataFrame? Give one example. 2

OR
B. Which library in Python is used for data analysis and manipulation?
What is the alias commonly used for the library?
23. A mobile repair shop owner throws damaged circuit boards and batteries 2
in a nearby garbage bin. Identify the type of waste being generated. State
one harmful effect of this waste on the environment.
24. Kamla wants to create a Pandas Series showing the marks scored by 2
students in a test.
Ravi 85
Sonia 92
Amit 78
Neha 88
Help her complete the code to display student names as index and marks
as values.

import _____ as pd
marks_data = {'Ravi':85, 'Sonia':92, 'Amit':78,
'Neha':88}
s = pd._____ (_____)
print(_____)
25. A. An organization wants its website to be accessible 24×7 to users 2
around the world. What kind of computer system is needed for this
purpose? What service helps in keeping the website files stored and
online?

OR
B. Rohan sends his project file to his teacher using G-mail. Which Internet
service is he using? Mention one advantage of this service.
26. Write a SQL query to perform the following: 2
I. Display only the year from the date '2026-03-15'
II. Convert the string 'computer' into uppercase.

27. What does the term IPR stands for? Name any one violation of IPR. 2

28. A. Write the output of the following code: 2
import pandas as pd
data = {'Name':['Aman','Bina','Chirag','Divya'],
'Marks':[85,78,92,88]}
df = pd.DataFrame(data)
df['Grade'] = ['B','C','A','B']
print(df)

OR

B. Write the output of the following code:
import pandas as pd
data = {'Name':['Hira','Lala','Chetan','Damini'],
'Marks':[58,87,95,83],
'Grade':['D','B','A','B']}
df = pd.DataFrame(data)
print(df['Marks'])

Section-C (4 x 3 = 12 Marks)
29. Write the differences between the following: 1+1+1=3
I. Copyrights and Patents
II. Plagiarism and Copyright infringement
III. Non-ethical hacking and Ethical hacking

30. A. Write a Python program to create and print a Pandas Series using a list 3
where the items sold in a shop are the indices and their quantities are
the values as shown below:

Item Quantity
Notebook 120
Pen 250
Pencil 300
Eraser 180

OR
B. Write a Python program to create and print a Pandas DataFrame from
a dictionary of Series. Set the Book Title as the row index of the
DataFrame, and columns as the number of books (Copies) and their
prices (Price) in a library as shown below:
Book Title Copies Price
Python Basics 25 320
Data Science Guide 18 450
AI for Students 12 500
Computer Networks 20 400

31. I. Write a SQL query to create a table named ORDERS with the following 2+1=3
specifications:

Column Name Data Type Key / Description
OrderID Numeric Primary Key
CustomerName Varchar(30) Name of the customer
OrderDate Date Date of the order
OrderAmount Float(8,2) Total amount of the order

II. Write a SQL query to insert one record into the ORDERS table with the
following details: (101, ‘Arbaz Khan’, ‘2026-11-10’, 2599.50)

32. A. Consider the following two tables: 3
Game, which stores (GameID, GameName, and Venue) and Player,
which stores (PlayerID, PlayerName, Age, GameID).

Table 1: GAME
GameID GameName Venue
101 Cricket Delhi
102 Football Mumbai
103 Badminton Chennai
104 Chess Kolkata

Table 2: PLAYER
PlayerID PlayerName Age GameID
1 Rohan 18 101
2 Meena 17 102
3 Arjun 19 103
4 Priya 18 101
5 Karan 17 105

Write SQL queries to:
I. List the names of players aged 18 or above, sorted in ascending
order by their name.
II. Display the names of games in uppercase that are played at Delhi.
III. Display the names of players along with the games they play and
the venue.

OR
B. Consider the following table Dishes, which stores (DishID, FoodName,
Category, Price, SpiceLevel)
Table : Dishes
DishID FoodName Category Price SpiceLevel
101 Chole Bhature Main Course 120.00 Spicy
102 Rajma Chawal Main Course 110.00 Medium

103 Aloo Paratha Breakfast 80.00 Medium
104 Paneer Tikka Snack 150.00 Spicy
105 Gulab Jamun Sweet 60.00 Mild

I. Write a suitable SQL query to rename the column FoodName to
Dish.
II. Write a suitable SQL query to remove the column SpiceLevel.
III. Write the output of the SQL query:
SELECT COUNT(*) FROM DISHES
GROUP BY CATEGORY HAVING COUNT(*) > 1;
Section-D (2 x 4 = 8 Marks)
33. Amit, a data analyst, is preparing a Python program to create a line graph 1x4=4
showing the average viewership ratings (in millions) of popular TV shows
over five months. However, some parts of his code are missing. Help Amit
by filling in the blanks.

Month Viewership (in Millions)
January 3.5
February 4.2
March 4.8
April 5.1
May 5.6

The incomplete code is as follows:
__________ as plt # Statement-1
Months = ['January', 'February', 'March', 'April', 'May']
Viewership = [3.5, 4.2, 4.8, 5.1, 5.6]
__________ # Statement-2
plt.xlabel('Months')

plt.ylabel('Viewership (in Millions)')
__________ # Statement-3
__________ # Statement-4
plt.legend()
plt.show()

I. Write the suitable import statement for Statement-1.
II. Write the suitable code for Statement-2 to plot the line graph with an
appropriate label for the legend.
III. Fill in Statement-3 to set the title of the graph.
IV. Fill in Statement-4 to save the graph as an image file named
tv_ratings.png.

34. A. Geeta, a database designer has created the following table: 1x4=4
News, which stores (NewsID, Headline, Category, PublishDate and
Views columns).
TABLE: NEWS
NewsID Headline Category PublishDate Views
101 Election Results Politics 2025-05-10 15000
Announced
102 Budget Session Politics 2025-07-12 13500
Highlights
103 Bollywood Awards Entertainment 2025-06-15 8500
Night
104 New Movie Trailer Entertainment 2025-08-05 9200
Released
105 Startup Funding Business 2025-08-25 9800
Increased
106 Stock Market Reaches Business 2025-09-02 11200
New High

Write suitable SQL query to:
I. Display all headlines in uppercase, sorted in descending order
of Views.
II. Display the month name and headline of all news articles
published.
III. Display the total number of articles and the average number of
views across all categories.
IV. Display the total number of articles and total views for each
category.

OR

B. Consider the following table Books, which stores (BookID, Title, Genre,
PublishDate and Price)
TABLE: BOOKS
BookID Title Genre PublishDate Price

201 The Lost Symbol Fiction 2023-03-12 499
202 Python for Beginners Education 2022-07-25 650
203 Data Science Simplified Education 2024-01-10 720
204 The Silent Patient Fiction 2023-09-18 540
205 World History Timeline History 2021-11-22 430
206 Ancient Civilizations History 2024-02-14 520

Write the output of the following SQL Queries:
I. SELECT UPPER(Title) FROM BOOKS WHERE Genre='Fiction';
II. SELECT ROUND(Price/100,1) FROM BOOKS WHERE BookID=203;
III. SELECT YEAR(PublishDate) FROM BOOKS WHERE Title='World History
Timeline';
IV. SELECT COUNT(Genre) FROM BOOKS WHERE Genre='Education';
Section-E (3 x 5 = 15 Marks)
35. SmartWave Solutions Pvt. Ltd. is a reputed IT company with its Head 5
Office in Bengaluru and a Regional Office in Pune.
The Bengaluru office consists of four departments — HR, Accounts,
Development, and Support.

The distances (in meters) between departments / offices are as follows:

Connection Distance
HR to Accounts 50
HR to Development 80
HR to Support 100
Accounts to Development 60
Accounts to Support 90
Development to Support 40
Bengaluru to Pune 980 km

The number of Computers in each Department / Offices are as follows:

Department / Office No. of Computers
HR 50
Accounts 35
Development 100
Support 20
Pune Office 40

As a network engineer, you have to propose solutions for various queries
listed from I to V:
I. Which department in the Bengaluru Office should host the main
server?
II. Suggest a suitable wired network layout to connect all the
departments of the Bengaluru office.
III. Name the network device required to connect all computers within a
department efficiently.

IV. What type of network (LAN / MAN / WAN) should be used to connect
the Bengaluru Head Office and the Pune Regional Office?
V. The company wants to plan efficient data transmission between the
computers in its offices, which networking device from Hub or Switch
should they prefer? Explain why.

36. Consider the DataFrame df given below: 1x5=5

InsectName Category Lifespan (in days)
Butterfly Flying 30
Ant Crawling 60
Dragonfly Flying 45
Beetle Crawling 120
Mosquito Flying 20

Write Python statements for the following tasks:
(assume all necessary modules are imported and DataFrame df is created)

I. Display the first three rows of the DataFrame df.
II. Add a new column named “Count” with values [10, 25, 12, 8, 20].
III. Display the names of insects whose lifespan is greater than 40 days.
IV. Change the Category of “Mosquito” to “Crawling”.
V. Delete the row corresponding to “Beetle” from the DataFrame.
37. A. Write suitable SQL queries for the following: 1x5=5
I. To display the first three characters from the Name column of the
Patients table.
II. To display the total salary of all employees from the Salary column
in the Employees table.
III. To display the day name from the Joining_Date column in the
Teachers table.
IV. To display the GameName column from the Games table after
removing all extra spaces from the right-hand side.
V. To display the current system date & time.

OR

B. Write suitable SQL queries for the following:
I. To display the square of the values in the Marks column of the
Students table.
II. To display the substring of Name starting from 2nd character for 4
characters from the Customers table.
III. To display the length of the City names from the Address table.
IV. To display the minimum price from the Price column in the
Products table.
V. To display the number of non-null entries in the Email column of
the Users table.