MBOSE Class 12 Question Paper 2026 for Informatics Practice

FOR MBOSE CLASS 12 EXAM PREPARATION

MBOSE Class 12 2026
Question Paper ·
Informatics Practice
EXAM YEAR TYPE SUBJECT

MBOSE Class 12 2026 Question Paper Informatics Practice

Notes · Sample Papers · Previous Year Papers · Mock Tests

m
.co

m
m .co s e m
s e g l a
gl a a

Total No. of Printed Pages—15
HS-XII-A-Sc-Com-IP-26
m
m .co
.co m
2026
m s e
s eINFORMATICS l a
ag
PRACTICES

g la
a Full Marks : 70

Time : 3 hours

The figures in the margin indicate full marks for the questions
General Instructions :

(i) This question paper contains 37 questions.
m
.co
(ii) All questions are compulsory. However, internal choices

em
have been provided in some questions. Attempt only one

s
of the choices in such questions.
la A, B, C, D and E.
g
(iii) The paper is divided into 5 sections—
a
(iv) Section—A consists of 21 questions (1 to 21). Each
question carries 1 mark.
(v) Section—B consists of 7 questions (22 to 28). Each
question carries 2 marks.
(vi) Section—C consists of 4 questions (29 to 32). Each
question carries 3 marks.
m
m .co
(vii) Section—D consists of 2 questions (33 and 34). Each

.co m
question carries 4 marks.

e m(viii) Section—E consists of 3 questions (35 to 37). Eachlase
l as ag
ag
question carries 5 marks.
(ix) All programming questions are to be answered using
Python language only.
(x) In case of MCQ, text of the correct answer should also be
written.

/79 [ P.T.O.

m .
.co s e m
s em l a
g la ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 1 of 15

( 2 )

SECTION—A

Answer the following as directed : 1×21=21

1. A DataFrame can be thought of as a group of multiple
series objects.

(State True or False)

2. To get the transpose of a DataFrame DF1, you can write
(a) DF1.T
(b) DF1.Transpose
(c) DF1.Swap
(d) DF1.TRANS
(Choose the correct option)

3. Which argument of bar() lets you set the thickness of bar?
(a) thick
(b) thickness
(c) width
(d) bar width
(Choose the correct option)

4. To display the 3rd, 4th and 5th columns from 6th to 9th
rows of a DataFrame DF, you can write

(a) DF.loc [ 5:9, 2:5 ]

(b) DF.loc [ 2:5, 5:9 ]

(c) DF.iloc [ 5:9, 2:5 ]

(d) DF.iloc [ 2:5, 5:9 ]
(Choose the correct option)

HS/XII/A.Sc.Com/IP/26/79 [ Contd.

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 2 of 15

m
.co

m
m .co s e m
s e g l a
gl a a

( 3 )

m
m
5. While reading from a CSV file, to use a column’s values as
.co
.co
index labels, argument given in read_CSV() is
s e m
s em l a
(a)
la
index
g ag
a
(b) index_col

(c) index_values

(d) index_label
(Choose the correct option)

m
6. Name the methods you can use to iterate over DataFrame.
o
7. The MySQL function that returns the m . c
s e specified number of

l a
characters from a particular position
g
of a given string is

(a) MID() a
(b) SUBSTRING()

(c) SUBSTR()

(d) All of the above
(Choose the correct option)
m
m .co
m .co
8. Which of the following types of constraints will prevent the
s e m
s e entry of duplicate rows?
g l a
g la (a) CHECK
a
a (b) DISTINCT
(c) Primary Key
(d) Null
(Choose the correct option)

HS/XII/A.Sc.Com/IP/26/79 [ P.T.O.

m .
.co s e m
s em l a
g la ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 3 of 15

( 4 )

9. Which of the following statements will delete all rows in a
table namely MyTable without deleting the table
structure?
(a) DELETE FROM MyTable;
(b) DELETE TABLE MyTable;
(c) DROP TABLE MyTable;
(d) DELETE MyTable;
(Choose the correct option)

10. Which of the following SQL statements will give an output
as 200·6 after execution?
(a) SELECT ROUND (200·56, 0);
(b) SELECT ROUND (200·56, –1);
(c) SELECT ROUND (200·56, 2);
(d) SELECT ROUND (200·56, 1);
(Choose the correct option)

11. The ____ function in MySQL joins two or more strings.
(Fill in the blank)

12. What is the role of foreign key?

13. Function count() is a/an _____ function in SQL.
(Fill in the blank)

14. A device that connects two different networks and directs
data packets is a
(a) hub
(b) switch
(c) router
(d) repeater
(Choose the correct option)

HS/XII/A.Sc.Com/IP/26/79 [ Contd.

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 4 of 15

m
.co

m
m .co s e m
s e g l a
gl a a

( 5 )

m
m
15. Cookies are stored in the web server.
.co
.co (State True or False)
s e m
s em l a
16. Define g la ag
a webpage.

17. The rights of the owner of information to decide how much
information is to be shared/exchanged/distributed, are
collectively known as

(a) Intelligent Property Rights
m
m .co
(b) Intellectual Property Rights
s e
g la
a
(c) Interactive Property Rights

(d) Instance Property Rights
(Choose the correct option)

18. Mention any two health hazards associated with
m
m
inappropriate and excessive use of gadgets.
.co
.co s e m
s em19. Define digital footprint. g l a
g la a
a
20. What is URL?

21. What is alternate key?

HS/XII/A.Sc.Com/IP/26/79 [ P.T.O.

m .
.co s e m
s em l a
g la ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 5 of 15

( 6 )

SECTION—B

Answer the following questions : 2×7=14

22. List any two differences between series and DataFrame in
Pandas.

23. Complete the given Python code to get the required output
as : Rajasthan
import ____ as pd
di={‘Corbett’ : ‘Uttarakhand’, ‘Sariska’ : ‘Rajasthan’,
‘Kanha’ : ‘Madhya Pradesh’, ‘Gir’: ‘Gujarat’}
NP = ______.Series (_______)
print (NP [_______])

24. (a) Given are two objects, a list object namely lst1 and a
series object namely ser1, both are having similar
values i.e., 2, 4, 6, 8. Find out the output produced
by the following statements :

(i) print(lst1*2)

(ii) print(ser1*2)
Or

(b) Write a Python program to plot a line chart based on
the given data to depict the changing weekly average
temperature in Delhi for four weeks :
Week = [1, 2, 3, 4 ]
Avg_week temp = [40, 42, 38, 44]

HS/XII/A.Sc.Com/IP/26/79 [ Contd.

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 6 of 15

m
.co

m
m .co s e m
s e g l a
gl a a

( 7 )

m
m
25. Write down the results returned by the following queries :
.co
m .co s e m
s e l a
l a
(a) SELECT MOD (11, 4);
ag
ag
(b) SELECT SUBSTRING (‘Quadratically’, 5, 6);

26. (a) Differentiate between Web browser and Web server.
m
.co
Or

e m
(b)
s
What is meant by network topology? List any two
popular topologies.
la
ag
27. (a) Mary, a class XI student, has written code for a
website but is unsure how to make it available on the
Internet. Explain to Mary the role of a web server and
web hosting in ensuring availability of her website on

m
the Internet.

m Or
.co
m .co s e m
s e g l a
l a a
(b) Explain the concept of VoIP and mention one benefit
ag of using it.

28. What measures should you take to keep data secure?

HS/XII/A.Sc.Com/IP/26/79 [ P.T.O.

m .
.co s e m
s em l a
g la ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 7 of 15

( 8 )

SECTION—C

Answer the following questions : 3×4=12

29. (a) Given a DataFrame namely Data as shown in the
figure below :

Fruit Color Count Price
Apple Red 3 120
Apple Green 9 110
Pear Red 25 125
Pear Green 26 150
Lime Green 99 70

Write the code statement to—
(i) find all rows with the label ‘Apple’ and extract
all columns;

(ii) list the fruits with Count more than 25;

(iii) list 2nd, 3rd and 4th rows.
Or

(b) The series object S1 stores the charity contribution
made by each section :
A 6700
B 5600
C 5000
D 5200
Write a program to create the series S1 and sort the
values of series S1 in descending order of its index
and store it into series S3.

HS/XII/A.Sc.Com/IP/26/79 [ Contd.

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 8 of 15

m
.co

m
m .co s e m
s e g l a
gl a a

( 9 )

m
m
30. Consider the table PETDATA with the following data :
c. o Table : PETDATA m .co
s e
s emBreed l a
ID
l a
PName
101 Adi g Golden Retriever
LifeSpan Price Discount
ag
a
202 Candy Boxer
15
11
16000
22000
5
10
303 Dazzler Bulldog 10 18000 NULL
404 Akash Yorkshire Terrier 16 20000 12
505 Akira Pug NULL 25000 8

m
.co
(a) Write SQL queries for the following :

s em
(i) Display all the pet names in upper case.

g la
a of all the pets.
(ii) Display the total price

(iii) Display the average discount available on all the
pets.
Or

m
.co
(b) Write the output of the following SQL queries :
m
m .co s
(i) SELECT ID, PName FROM PETDATA ORDER BYe m
s e PName DESC;
g l a
g la a
a (ii) SELECT * FROM PETDATA WHERE PName
LIKE ‘‘A%’’;

(iii) UPDATE PETDATA SET LifeSpan = 17 WHERE
PName = “Akash’’;

HS/XII/A.Sc.Com/IP/26/79 [ P.T.O.

m .
.co s e m
s em l a
g la ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 9 of 15

( 10 )

31. Answer the following questions :
(a) What is Equi Join? 1
(b) What is the difference between WHERE clause and
HAVING clause? 2
32. (a) Why is it important to have a positive digital foot-
print? Write any three points to support your answer.
Or
(b) Why should intellectual property rights be protected?
Give any three reasons.

SECTION—D

Answer the following questions : 4×2=8
33. (a) Medal tally of the Commonwealth Games, 2018 of
India :
Country Gold Silver Bronze Total
India 26 20 20 66

Write a program to create a horizontal bar chart for
India’s medal tally for the above table. Write an
appropriate chart title and both axis labels. Also give
suitable Python statements to store this chart.
Or
(b) The heights of 10 students of eighth grade are given
below :
Height_cms = [145, 141, 142, 142, 143, 144,
141, 140, 143, 144]
Write suitable Python code to generate a histogram
based on the given data, along with an appropriate
chart title and both axis labels. Also give suitable
Python statement to save this chart.

HS/XII/A.Sc.Com/IP/26/79 [ Contd.

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 10 of 15

m
.co

m
m .co s e m
s e g l a
gl a a

( 11 )

m
34. (a)
m
Write the output for the following SQL queries :
c. o Table : FASHION m .co
s e
s em Product l a
la Kajal ag
ID Price Qty

g
a F02 Foundation
F01 970 10
2100 15
F03 Night cream 1700 20
F04 Day cream 1400 10
F05 Shampoo 1200 25
F06 Lipstick 850 32

m
(i) SELECT COUNT (Product) FROM FASHION;
o
c
(ii) SELECT SUM (Price * Qty) .FROM FASHION
m
WHERE Product = ‘‘Nightsecream’’;

g la 4) FROM FASHION
a
(iii) SELECT LEFT (Product,
WHERE Price > 1500;

(iv) SELECT MIN (Price) FROM FASHION;

Or

m
.co
(b) Find the output for the following SQL queries :
m
m .co (i) SELECT SUBSTR (‘‘CLIMATE CHANGE’’, 4, 4);
s e m
s e l a
(ii) SELECT UCASE (RIGHT (‘‘Pollution’’, 3)); ag
g la
a (iii) SELECT LENGTH (‘‘HAPPY’’)+3;

(iv) SELECT INSTR (‘‘WELCOME WORLD’’,
‘‘COME’’ );

HS/XII/A.Sc.Com/IP/26/79 [ P.T.O.

m .
.co s e m
s em l a
g la ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 11 of 15

( 12 )

SECTION—E

Answer the following questions : 5×3=15

35. (a) Consider the DataFrame df shown below :

Name Department Salary
0 Rohan Sharma IT 75000
1 Meera Kapoor HR 68000
2 Aarav Singh Finance 85000
3 Nisha Singh Marketing 72000
4 Aditya Verma IT 80000

Write Python statements for the following tasks :
(i) Print the last three rows of the DataFrame df.

(ii) Add a new column named ‘‘Experience’’ with
values [5, 8, 10, 6, 7].

(iii) Delete the column ‘‘Salary’’ from the DataFrame.

(iv) Rename the column ‘‘Department’’ to ‘‘Dept’’.

(v) Display only the ‘‘Name’’ and ‘‘Salary’’ columns
from the DataFrame.
Or

(b) Consider the following code and figure out what
these are trying to do. The Pandas library has been
imported as pd.

(i) pd.read_csv(‘‘data.csv’’, n rows = 20)

(ii) pd.read_csv(‘‘data.csv’’, skiprows = [1, 2, 3, 4])

(iii) pd.read_csv(‘‘data.csv’’, header = None)

HS/XII/A.Sc.Com/IP/26/79 [ Contd.

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 12 of 15

m
.co

m
m .co s e m
s e g l a
gl a a

( 13 )

m
c o m
(iv) pd.read_csv(‘‘data.csv’’, sep = ‘ @’ )
m .co
m .
(v) pd.read_csv(‘‘data.csv’’, index_col = ‘Ename’)
s e
s e l a
g
36. (a) Writel a suitable SQL queries for the following : ag
a(i) Count the characters in the string ‘Artificial
Intelligence’.

(ii) Find the position of ‘i’ in the column named
‘Topic’ of the Seminars table.

(iii) Square the Duration column in the Session
table.
o m
c
(iv) Display the average rating .from the Rating
s em
lafrom the Rating column
column in the Reviews table.

a g
(v) Display the total rating
in the Reviews table.
Or

(b) Write the SQL functions which will perform the
following operations :

(i) To display the name of the weekday of your date
m
.co
of birth.
m (ii) To convert e-mail id to lowercase.
m .co s e m
s e g l a
la a
(iii) To count the number of characters in your

ag name.

(iv) To display the first character of your name.

(v) To calculate the average marks secured by the
class.

HS/XII/A.Sc.Com/IP/26/79 [ P.T.O.

m .
.co s e m
s em l a
g la ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 13 of 15

( 14 )

37. (a) Read the text carefully and answer the questions :
ABC Solutions Ltd. is a prominent IT services firm
with its headquarters in Bengaluru and a regional
office in Kochi. The Bengaluru office comprises four
departments : HR, Marketing, Engineering and
Customer Services.

Bengaluru Office

HR Marketing Kochi
Office

Engineering Customer Services

The distances between these departments, as well as
between Bengaluru and Kochi, are as follows :
HR to Marketing : 55 metres
HR to Engineering : 85 metres
HR to Customer Services : 110 metres
Marketing to Engineering : 45 metres
Marketing to Customer Services : 65 metres
Engineering to Customer Services : 40 metres
Bengaluru Office to Kochi Office : 1200 kilometres
The no. of computers in each department/office is as
follows :
HR : 100
Marketing : 80
Engineering : 80
Customer Services : 30
Kochi Office : 60

HS/XII/A.Sc.Com/IP/26/79 [ Contd.

For more Question Papers, Sample Papers, Notes & Syllabus visit Page 14 of 15

m
.co

m
m .co s e m
s e g l a
gl a a

( 15 )

m
m
As a network engineer, you have to propose solutions
.co
.co
for various queries listed from (i) to (v).
m s e m
s e l a
a ag
(i) Suggest the most suitable department in the

g l Bengaluru Office setup to install the server.
a Also, give a reason to justify your suggested
location.

(ii) Draw a suitable cable layout of wired network
connectivity between the departments in the
Bengaluru Office setup.

(iii) Which hardware device will you suggest to
m
connect all the computers within each
.co
department?
s em
g la
a
(iv) Suggest the most appropriate type of network
(LAN, MAN, WAN) to connect the Bengaluru
Head Office and Kochi Regional Office.

(v) When a signal is transmitted through a wire
from HR department to Customer Services
department, its strength reduces. Which device
would you suggest the company of use to solve
m
.co
the problem?
m
.co m
Or
s e
s em (b) Differentiate between BUS topology and STAR g l a
g la a
a topology. Write any three advantages of BUS topology
and three disadvantages of STAR topology. 2+3=5

HHH

HS/XII/A.Sc.Com/IP/26/79 26K—890

m .
.co s e m
s em l a
g la ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 15 of 15