Page 1
FOR CBSE CLASS 12 PREPARATION
CBSE Class 12 Sample
Paper 2027 Solution
(Marking Scheme) for
Informatics Practices
EXAM YEAR TYPE SUBJECT
CBSE Class 12 2027 Solutions Informatics Practices
Notes · Sample Papers · Previous Year Papers · Mock Tests
Page 2
m
m .co
m .co INFORMATICS PRACTICES (Code No. 065)
se MARKING SCHEME
Class - XII (2026-27) a
Time Allowed: 3 Hours Maximum Marks: 70
General Instructions:
All questions are compulsory.
The examination paper contains five sections, from Section A to Section E.
m
.co
Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
m
.co
Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
e m
s
Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
em l a
s
Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
l a
Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
g ag
a
There is no overall choice. However, internal choices have been provided in some
questions. Attempt only one of the choices in such questions.
All programming questions are to be answered using Python Language only.
QNO Section-A (1 to 21) 21 x 1 = 21 Marks MARKS
1 False 1
(1 mark for correct answer)
2 C. LENGTH() 1
m
.co
(1 mark for correct answer)
3 C. Patent 1
(1 mark for correct answer)
e m
4 B. ylabel()
las 1
5
(1 mark for correct answer)
C. Modem ag 1
(1 mark for correct answer)
6 C. UPDATE 1
(1 mark for correct answer)
7 B. Refurbishing 1
(1 mark for correct answer)
8 A. A Series with values 5, 5, 5 1
(1 mark for correct answer)
m
c. o
9 HAVING 1
m
.co
(1 mark for correct answer)
10 C. Cookies
s em 1
s em11 (1 mark for correct answer)
la a
A. DESC 1
ag 12
(1 mark for correct answer)
C. NaN 1
(1 mark for correct answer)
13 C. Reduce 1
(1 mark for correct answer)
14 D. MID() 1
(1 mark for correct answer)
15 C. index 1
(1 mark for correct answer)
m .
c. o
16 Web hosting or Hosting 1
(1 mark for correct answer)
e m
em l as
s
la ag
ag For more Question Papers, Sample Papers, Notes & Syllabus visit Page 1 of 5
Page 3
17 B. WHERE Commission IS NOT NULL 1
(1 mark for correct answer)
18 C. Column labels 1
(1 mark for correct answer)
19 True 1
(1 mark for correct answer)
20 D. Assertion (A) is False, but Reason (R) is True. 1
(1 mark for correct answer)
21 C. Assertion (A) is True and Reason (R) is False. 1
(1 mark for correct answer)
Section-B (22 to 28) 7X2 = 14 Marks
22 (A) (i) 2
The head() function displays the first n rows of a DataFrame.
If n is not specified in head(), it returns the first 5 rows by default.
OR
(B) Boolean indexing is a technique used to select subsets of data based
on the actual values in the DataFrame rather than row/column labels.
Example
data = [
{'Name': 'Aarav', 'Age': 24},
{'Name': 'Priya', 'Age': 30}
]
df = pd.DataFrame(data)
print(df['Age'] > 25)
Output
23 Active digital footprint: An active digital footprint is created when a person 2
intentionally shares or submits information online.
Passive digital footprint: A passive digital footprint is created when
information is collected automatically, often without the user’s knowledge or
direct involvement.
(2 mark for correct differentiation)
24 Data visualization is the graphical or pictorial representation of data using 2
graphs, charts, etc. Its primary purpose is to visualize variations or show
relationships between variables, helping users to infer conclusions that
might not be easily visible by looking at raw numerical data.
25 (A) In star topology, each node is directly connected to a central controller 2
(hub or switch).
Advantage: Failure of one node does not affect the rest of the
network.
OR
(B) VoIP stands for Voice over Internet Protocol, which allows voice
transmission over a computer network rather than traditional
telephone lines.
Advantages:
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 2 of 5
Page 4
m
m .co
m .co Very economical/free compared to traditional international calls.
se (1 mark for each correct part)
26 (i) SELECT RIGHT(Ename, 3) FROM EMPLOYEE;
(ii) SELECT INSTR('Informatics', 'ma');
a 2
27 Be Ethical: Do not violate copyright laws; always seek permission before 2
using or sharing copyrighted material.
Be Respectful: Respect the privacy, opinions, and cultural diversity of
others, especially in public online forums.
(1 mark for each correct guidelines)
28 (A) import pandas as pd 2
m
m .co
dict1 = {'a': 10, 'b': 20}
.co m
dict2 = {'a': 5, 'b': 10, 'c': 20}
m
df = pd.DataFrame([dict1, dict2])
s e
s e l a
ag
print(df)
(2 mark for correct program)
a OR
(B) read_csv() is used to load data from a CSV file into a Pandas
DataFrame.
sep: Specifies the delimiter (e.g., comma, semicolon).
Section-C (29 to 32) 4X3 = 12 Marks
29 (i) Phishing 3
(ii) Cyber Bullying
(iii) Be Credible/Use polite language
m
.co
em
30 (A) (i) 3
l as
stock = {'Pens': 150, 'Erasers': 80, 'Sharpeners': 60, 'Notebooks': 200}
Inventory = pd.Series(stock)
print(Inventory)
ag
(ii) Output:
a NaN
b 50.0
c NaN
(2 marks for correct program)
m
(1 mark for correct output)
.co
OR
m
.co m
(B) (i) df['Total'] = [183, 181, 158]
(ii) df.rename(columns={'Name': 'Student'}, inplace=True)
s e
s em (iii) df.drop(columns=['Maths'], inplace=True)
g la 31 (1 mark for each correct part)
a
a (i) SELECT LOWER(PName) FROM HOSPITAL WHERE Dept =
'Cardiology';
3
(ii) SELECT PNo, DAYNAME(DOA) FROM HOSPITAL;
(iii) SELECT PName FROM HOSPITAL ORDER BY PName ASC;
32 (A) (i) 3
UPPER(Name) LENGTH(Name)
VINOD 5
m .
.co m
DAY(DOB) YEAR(DOB)
s e
em
1 2004
s l a
ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 3 of 5
Page 5
(iii)
RIGHT(Name, 3)
man
OR
(B) (i) 9
(ii) INDIA
(iii) 11
Section-D (33 to 34) 2X4 = 8 Marks
33 import matplotlib.pyplot as plt 4
months = ['Jan', 'Feb', 'Mar', 'Apr']
sales = [12000, 15000, 11000, 18000]
plt.plot(months, sales, label="Sales")
plt.title("Sales Performance")
plt.xlabel("Month")
plt.ylabel("Amount")
plt.legend()
plt.show()
(1 mark for correct imports)
(1 mark for correct use of plot with label)
(1/2 mark for title)
(1/2 mark for labels)
(1/2 mark for legend)
(1/2 mark for show)
34 (A) (i) SELECT Game, SUM(Fees) FROM SPORTS GROUP BY Game 4
HAVING SUM(Fees) > 1000;
(ii) SELECT SName, CName FROM SPORTS, COACH WHERE
SPORTS.Game = COACH.Game;
(2 mark for correct part(i), 2 mark for correct part(ii))
OR
(B) (i)
DeptID COUNT(*) MAX(Salary)
D1 2 5200
D2 2 7500
Name DeptName
Riya IT
Kabir IT
(2 mark for correct part(i), 2 mark for correct part(ii))
Section-E (35 to 37) 3X5 = 15 Marks
35 (i) Block D. It is the most suitable because it has the maximum number of 5
computers (150).
(ii) LAN (Local Area Network). The distance is within a single
campus/limited area.
(iii) Switch: Every block (A, B, C, D) should have a switch to connect
multiple computers within that block.
(iv) Dynamic Website. Since it involves user logins and real-time data
updates from a database, a dynamic site is required.
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 4 of 5
Page 6
m
m .co
m .co (v) Between Block A and Block D, & Block C and Block D, because
se Repeaters are needed as distance exceeds ~100m for Ethernet.
36
(i)
a 5
data = {
'Items': pd.Series(['Bread', 'Milk', 'Eggs']),
'Quantity': pd.Series([50, 100, 120]),
'Unit_Price': pd.Series([30, 25, 6])
}
StoreDF = pd.DataFrame(data)
m
m .co
print(StoreDF)
.co m
m
StoreDF.loc[3] = ['Butter', 40, 55]
s e
(iii)
s e l a
l a
print(StoreDF['Items'])
g ag
a
(3 mark for correct part(i), 1 mark for correct part(ii), 1 mark for correct
part(iii))
37 (A) (i) INSERT INTO BOOK VALUES (205, 'The White Tiger', 'Aravind 5
Adiga', 350);
(ii) UPDATE BOOK SET Price = 325 WHERE BookID = 202;
(iii) DELETE FROM BOOK WHERE Author = 'R. K. Narayan';
(iv) ALTER TABLE BOOK ADD Publisher VARCHAR(30);
(v) DROP TABLE BOOK;
m
.co
OR
m
(B) (i) SELECT PName, ROUND(Price, 1) FROM PRODUCT;
s e
(ii) SELECT PName FROM PRODUCT WHERE RIGHT(PName,1) =
's';
a
(iii) SELECT PName, Category FROM PRODUCT WHERE Price <=
500;
(iv) SELECT SUM(Qty) FROM PRODUCT;
(v) SELECT LTRIM(PName) FROM PRODUCT;
m
m .co
m .co s e m
s e g l a
g la a
a
m .
.co s e m
s em l a
ag
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 5 of 5