CBSE Class 12 Sample Paper 2025 Solution for Informatics Practices

Central Board of Secondary Education

SAMPLE PAPER
Class 12
2025

Solutions

MARKING SCHEME
CLASS XII SESSION: 2024-25
INFORMATICS PRACTICES (065)

Time allowed: 3 Hours Maximum Marks:70

Q No. Section-A Marks
1 True
1
(1 mark for correct answer)

2 (B). Filter rows based on a specific condition
1
(1 mark for correct answer)

3 (D). Router
1
(1 mark for correct answer)

4 (A). DROP TABLE
1
(1 mark for correct answer)

5 (D). Electronic devices that are no longer in use
1
(1 mark for correct answer)

6 (B). df['column_name']
1
(1 mark for correct answer)

7 (D). line
1
(1 mark for correct answer)

8 True
1
(1 mark for correct answer)

9 (B). pd.read_csv('filename.csv')
1
(1 mark for correct answer)

10 (A) Using copyrighted material without giving proper acknowledgement to
the source 1
(1 mark for correct answer)

11 (D). Rows
1
(1 mark for correct answer)

12 (A). Star 1

Page 1 of 8

(1 mark for correct answer)

13 (D). 5
1
(1 mark for correct answer)

14 (B). Phishing
1
(1 mark for correct answer)

15 (B). Indices of the Series
1
(1 mark for correct answer)

16 (B). P-2, Q-4, R-1, S-3
1
(1 mark for correct answer)

17 (D). Filtering data based on condition
1
(1 mark for correct answer)

18 (C). Line plot
1
(1 mark for correct answer)

19 (C). LAN
1
(1 mark for correct answer)

20 (A). Both Assertion (A) and Reason (R) are true, and Reason (R) is the correct
explanation of Assertion (A) 1
(1 mark for correct answer)

21 (D). Assertion (A) is False, but Reason (R) is True
1
(1 mark for correct answer)

Q No. Section-B (7 x 2 = 14 Marks) Marks

22 (A) A Series is a one-dimensional array containing a sequence of values of any
data type (int, float, list, string, etc) which by default have numeric data
labels starting from zero.
We can imagine a Pandas Series as a column in a spreadsheet. An
example of a series containing the names of students is given below: 2
Index Value
0 Arnab
1 Samridhi
2 Ramit
3 Divyam
(1 mark for correct definition)

Page 2 of 8

(1 mark for correct example)
OR
(B) Library: A collection of modules providing functionalities for specific tasks.
Pandas: Used for data analysis
Matplotlib: Used for creating plots
(1 mark for correct definition)
(1/2 mark each for correct use of each library)

23 Intellectual Property Rights (IPR)
These are legal rights that protect the creations of the human intellect. The nature
of these works can be artistic, literary or technical etc.
Importance in the digital world
These rights help prevent the unauthorized use or reproduction of digital content 2
and ensure that creators are fairly compensated and incentivized for their original
work.
(1 mark for correct definition)
(1 mark for correct importance)

24 I. SELECT SUBSTRING('Database Management System', 10, 6);
II. SELECT INSTR('Database Management System', 'base'); 2
(1 mark for each correct query)

25 (A) The Internet is a vast network of interconnected computer networks
facilitating global communication and data exchange. The World Wide Web
(WWW), on the other hand, is a system of interlinked hypertext documents
accessed via the Internet.
(1 mark for correct definition)
(1 mark for correct difference)
OR 2
(B) Browser cookies: Small pieces of data stored on our digital devices by
websites to remember information and personalize our experience.
Advantage: Improve user experience by remembering preferences, like our
preferred language and other settings.
(1 mark for correct definition)
(1 mark for correct advantage)

Page 3 of 8

26 Primary Key : A set of attributes that can uniquely identify each row in a table
(relation). It must contain unique values and cannot be null.
How it differs from Candidate Key
There can be multiple Candidate Keys in a table (relation), but only one of them 2
is selected as Primary Key.
(1 mark for correct definition)
(1 mark for correct difference)

27 Two health concerns due to excessive use of Digital Devices:
a) Eye strain and vision problems.
2
b) Musculoskeletal issues like neck and back pain.
(1 mark for each correct health concern)

28 (A) import pandas as pd
D1 = {'Name': 'Rakshit', 'Age': 25}
D2 = {'Name': 'Paul', 'Age': 30}
D3 = {'Name': 'Ayesha', 'Age': 28}
data = [D1, D2, D3]
df = pd.DataFrame(data)
print(df)

Changes Made :
i. Changed Pandas to pandas.
ii. Corrected mismatched string quotation marks
iii. Corrected the closing parenthesis in the list data. 2
iv. Changed Dataframe to DataFrame.
(1/2 mark for each correct correction and underlining)

OR

(B) import pandas as pd
data = ['Chennai', 'Lucknow', 'Imphal']
indx = ['Tamil Nadu','Uttar Pradesh','Manipur']
s = pd.Series(data, indx)
print(s)
(1/2 mark for each correct fill in the blank)

Page 4 of 8

Q No Section-C (4 x 3 = 12 Marks) Marks

29 I. E-waste can release harmful substances like lead and mercury into the
environment.
(1 mark for correct answer)
II. They can donate or sell it to a certified e-waste recycling center.
3
(1 mark for correct answer)
III. Recycling e-waste helps conserve natural resources and reduces
pollution.
(1 mark for correct answer)

30 (A) import pandas as pd
d1 = {'Product': 'Laptop', 'Price': 60000}
d2 = {'Product': 'Desktop', 'Price': 45000}
d3 = {'Product': 'Monitor', 'Price': 15000}
d4 = {'Product': 'Tablet', 'Price': 30000}
data = [d1, d2, d3, d4]
df = pd.DataFrame(data)
print(df)
(1 mark for correct import statement)
(1 mark for correct list of dictionary) 3
(1 mark for correct creation of DataFrame)
OR
(B) import pandas as pd
data = {'Russia':'Moscow','Hungary':'Budapest','Switzerland':'Bern'}
s = pd.Series(data)
print(s)
(1 mark for correct import statement)
(1 mark for correct dictionary)
(1 mark for correct creation of Series)

31 I.
CREATE TABLE STUDENTS (
3
StudentID NUMERIC PRIMARY KEY,
FirstName VARCHAR(20),

Page 5 of 8

LastName VARCHAR(10),
DateOfBirth DATE,
Percentage FLOAT(10,2)
);
(2 mark for correct creation of Table)

II.
INSERT INTO STUDENTS (StudentID, FirstName, LastName,
DateOfBirth, Percentage) VALUES (1, 'Supriya', 'Singh', '2010-08-18',
75.5);
(1 Mark for correct insert Query)

32 (A) I. SELECT DEPARTMENT, AVG(SALARY) FROM PAYROLL
GROUP BY DEPARTMENT;
II. SELECT DESIGNATION FROM PAYROLL ORDER BY SALARY
DESC;
III. SELECT EMP_NAME, DEPARTMENT FROM EMPLOYEE E,
PAYROLL P WHERE E.EMP_ID=P.EMP_ID;
(1 mark for each correct query)
OR
3
(B) I. SELECT SPORT,SUM(Medals) FROM MEDALS GROUP BY
SPORT;
II. SELECT UPPER(Name) FROM ATHLETE WHERE COUNTRY
= 'INDIA';
III. SELECT NAME, SPORT FROM ATHLETE A, MEDALS M
WHERE
A.AthleteID= M.AthleteID;
(1 mark for each correct query)

Q No. Section-D (2 x 4 = 8 Marks) Marks

33 I. matplotlib.pyplot
II. books_read
III. ylabel 4
IV. Number of Books Read by Students
(1 mark for each correct answer)

Page 6 of 8

34 (A) I. SELECT LOWER(TITLE) FROM BOOK;
II. SELECT MAX(PRICE) FROM BOOK;
III. SELECT LENGTH(TITLE) FROM BOOK;
IV. SELECT BCODE, PRICE FROM BOOK ORDER BY PRICE DESC;
(1 mark for each correct answer)
OR
(B) I.
LENGTH(MED_NAME)
11
11
7

II.
4
MED_NAME
IBUPROFEN

III.
MED_NAME
PARACETAMOL
COUGH SYRUP
INSULIN

IV.
max(DEL_DATE)
2023-06-15
(1 mark for each correct answer)

Q No. Section-E (3 x 5 = 15 Marks) Marks

35 I. The server should be installed in the HR department as it has the most
number of computers. 5
II. Star topology

Page 7 of 8

III. Switch/Hub
IV. WAN (Wide Area Network) will be created as the offices are located in
different cities.
V. A dynamic website is recommended as it can display the dynamic
performance data (which differs from employee to employee) of each
employee.
(1 mark for each correct answer)

36 I. print(df.head(2))
II. print(df['Title'])
III. df = df.drop(‘Rating’, axis=1)
5
IV. print(df.loc[2:4,'Title'])
V. df.rename(columns={'Title':'Name'}, inplace=True)
(1 mark for each correct answer)

37 (A) I. SELECT AVG(test_results) FROM Exams;
II. SELECT RIGHT(registration_number, 3) FROM Vehicles;
III. SELECT TRIM(username) FROM Users;
IV. SELECT MAX(salary) FROM Employees;
V. SELECT COUNT(*) FROM Suppliers;
(1 mark for each correct query)
OR 5
(B) I. SELECT ROUND(3.14159, 2);
II. SELECT MOD(125, 8);
III. SELECT LENGTH('NewDelhi');
IV. SELECT LEFT('Informatics Practices', 5);
V. SELECT TRIM(email) FROM Students;
(1 mark for each correct query)

Page 8 of 8

CBSE STUDY MATERIAL

CBSE Board

INFORMATION CLASS STUDY MATERIAL

1 Time Table 09 Sample Paper
10 Sample Paper
2 Result
11 Sample Paper
3 Syllabus 12 Sample Paper

OTHER RESOURCES
09 Question Paper
Maps of India, Maps of World
Writing Skill Formats 10 Question Paper
Periodic Table 11 Question Paper
12 Question Paper
Class 9 Notes
Class 10 Notes
NCERT Book
Class 11 Notes
Class 12 Notes NCERT Solutions

ENTRANCE EXAMS

JEE Main CLAT CUET UG
JEE Advanced NEET UG Fashion & Design