aglasem.com
Home Schools Admission Career Mock Test PDF Docs Playground
ClassChoose class
StateSelect state

CBSE Class 12 Sample Paper 2027 for Informatics Practices

Download CBSE Class 12 Sample Paper 2027 for Informatics Practices. Here at aglasem.com get latest CBSE Model Papers with Answers to prepare better for your upcoming board exam 2027. CBSE Class 12 Informatics Practices Sample Question Paper 2027 is given below.
CBSE Class 12 Sample Paper 2027 for Informatics Practices - Page 1 of 8

Finished viewing? Save it for later —

Download CBSE Class 12 Sample Paper 2027 for Informatics Practices (PDF · 8 pages)
Downloaded 31 times

About CBSE Class 12 Sample Paper 2027 for Informatics Practices

CBSE Class 12 Sample Paper 2027 for Informatics Practices is available here for free download. Published by CBSE for Class 12, this sample paper can be viewed online or downloaded as a PDF (8 pages). Candidates preparing for Class 12 can use CBSE Class 12 Sample Paper 2027 for Informatics Practices to understand the exam pattern, the type of questions asked, and the overall difficulty level.

Frequently Asked Questions

How can I download CBSE Class 12 Sample Paper 2027 for Informatics Practices?

Open this page and click the Download button to save CBSE Class 12 Sample Paper 2027 for Informatics Practices as a PDF. It is completely free on AglaSem Docs.

Is CBSE Class 12 Sample Paper 2027 for Informatics Practices free to download?

Yes. CBSE Class 12 Sample Paper 2027 for Informatics Practices can be viewed online and downloaded as a PDF free of cost on AglaSem Docs.

How many pages does CBSE Class 12 Sample Paper 2027 for Informatics Practices have?

CBSE Class 12 Sample Paper 2027 for Informatics Practices contains 8 pages, which you can read online or download together as a single PDF.

Where can I find more Class 12 study material?

You can find more Class 12 question papers, sample papers, syllabus, and answer keys on AglaSem Docs.

CBSE Class 12 Sample Paper 2027 for Informatics Practices – Text

Read the full text of this sample paper below — useful to quickly search, copy and reference the content online without downloading the PDF.

📄 View text version (9 pages)

Page 1

FOR CBSE CLASS 12 PREPARATION

CBSE Class 12 Sample
Paper 2027 for
Informatics Practices
EXAM YEAR TYPE SUBJECT

CBSE Class 12 2027 Sample Paper Informatics Practices

Notes · Sample Papers · Previous Year Papers · Mock Tests

Page 2

m
m .co

m .co s em
se g l a
a No. 065)
INFORMATICS PRACTICES (Code
SAMPLE QUESTION PAPER (THEORY)
Class - XII (2026-27)

Time Allowed: 3 Hours Maximum Marks: 70

m
.co
General Instructions:
m
.co m
 All questions are compulsory.

m s e
a
The examination paper contains five sections, from Section A to Section E.
s e l
ag

a
Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.

g l
Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
 a
Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
 Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
 Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
 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.
 In case of MCQ, text of the correct answer should also be written.

o m
c
.x 1 = 21 Marks
QNO Section-A (1 to 21) 21
e m
A Pandas Series S1 is created withsindex labels ['a', 'b', 'c', 'd', 'e']. State
MARKS
1
a
whether the following statement islTrue or False:
1

ag the same result as S1[1:3]."
"The statement S1['b':'d'] will produce
2 Ravi needs to find the total number of characters in the StudentName 1
column. Which SQL function should he use?
A. COUNT()
B. SIZE()
C. LENGTH()
D. TOTAL()
3 Which type of Intellectual Property Right (IPR) protects an invention by giving 1
m
.co
the creator exclusive rights to make, use, and sell it for a specific period?
m A. Copyright
.co B. Trademark
s e m
em a
C. Patent
s g l
la 4
D. Software License
g While plotting a graph using Matplotlib, which function is used to specify thea 1
a label for the Y-axis?
A. label_y()
B. ylabel()
C. yaxis_name()
D. set_y()
5 I am a networking device that converts digital data from a computer into 1
analog signals for transmission, and then converts incoming analog signals
back into digital data for the computer to understand. Who am I?
m .
.co

m Page | 1 se
m
as e g la
g l a
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 1 of 8

Page 3

A. Repeater
B. Router
C. Modem
D. Switch
6 Which of the following is a Data Manipulation Language (DML) command in 1
SQL?
A. ALTER
B. DROP
C. UPDATE
D. CREATE
7 The process of re-selling old electronic goods after minor repairs or 1
modification is called:
A. Recycling
B. Refurbishing
C. Reducing
D. Leaching
8 What will be the output of the following code? 1

import pandas as pd
print(pd.Series(5, index=[0, 1, 2]))

A. A Series with values 5, 5, 5
B. A Series with value 5 only at index 0
C. A Series with values 0, 1, 2
D. Error
9 Fill in the blank: 1

The SQL clause used to filter the groups formed by the GROUP BY clause
based on a specific condition is ____________.
10 Riya visited an online shopping website, and it saved small text files on her 1
computer to remember her preferences and session details. What are these
files called?
A. Plug-ins
B. Add-ons
C. Cookies
D. Scripts
11 Which keyword is used with the ORDER BY clause to sort data in descending 1
order?
A. DESC
B. DOWN
C. DSC
D. REVERSE
12 If we add two Pandas Series that do not have matching index labels, the 1
result for those non-matching indices will be:
A. 0
B. Error
C. NaN
D. Empty string
13 The process of buying electronic gadgets only when necessary to minimize 1
the generation of electronic waste is an example of which 'R' of e-waste
management?
A. Recycle
Page | 2

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

Page 4

m
m .co

m .co B. Reuse
s e m
se C. Reduce
g l a
14
D. Refurbish a
Which SQL function is used to extract a specific number of characters from 1
a string starting from a given position?
A. LEFT()
B. RIGHT()
C. LENGTH()
D. MID()
15 Aman is exporting a Pandas DataFrame to a CSV file using the to_csv() 1
function. He wants to save only the data and avoid writing the row indices to
m
m .co
the file. Which parameter should he set to False to prevent the indices from

.co m
being included?
A. header
m s e
s e l a
ag
B. sep
l
C. index
g a
16
a
D. columns
Fill in the blank: 1
The process of storing a website on a web server so that it can be accessed
over the internet is known as ________.
17 A HR manager queries an employee database. He wants to retrieve only 1
those records where the Commission field actually contains a value. Which
SQL condition should he use?
A. WHERE Commission != NULL

m
B. WHERE Commission IS NOT NULL

.co
C. WHERE Commission <> NULL

m
D. WHERE Commission NOT NULL
18
s e
When creating a DataFrame from a list of dictionaries, the dictionary keys 1
become:
g la
A. Row indices
B. Data values a
C. Column labels
D. Positional Index
19 State whether the following statement is True or False: 1
In SQL, the BETWEEN operator is inclusive of both the lower and upper
values specified in the range.
Q. 20 and Q. 21 are Assertion (A) and Reason (R) type questions.

m
Choose the correct option as:

.co
A. Both Assertion (A) and Reason (R) are True and Reason (R) is the correct
m
.co m
explanation for Assertion (A).
B. Both Assertion (A) and Reason (R) are True and Reason (R) is not the
s e
s em correct explanation for Assertion (A).
g l a
g la C. Assertion (A) is True and Reason (R) is False.
a
a 20
D. Assertion (A) is False, but Reason (R) is True.
Assertion (A) The statement df.drop('Science', axis=0) will remove the 1
column labeled 'Science' from the DataFrame.
Reason (R) In Pandas drop() method, axis=0 refers to row-wise
operations and axis=1 refers to column-wise operations.
21 Assertion (A) In SQL, the query select * from emp; and SELECT * FROM 1
EMP; will produce the same result.
Reason (R) SQL is a case-sensitive language.
Section-B (22 to 28) 7X2 = 14 Marks
m .
.co

m Page | 3 se
m
as e g la
g l a
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 3 of 8

Page 5

22 (A) (i) Explain the use of the head() function in a Pandas DataFrame. 2
(ii) What happens if the parameter n is not specified in the head()
function?
OR
(B) Explain the concept of Boolean Indexing in DataFrames. Write a small
Python code example to demonstrate it.
23 Differentiate between an Active and a Passive digital footprint. 2
24 Define Data Visualization and state its primary purpose. 2
25 (A) Define Star Topology. Mention one major advantage of using it. 2
OR
(B) What is VoIP? State any one advantages of using VoIP for
communication.
26 Write SQL queries for the following requirements: 2
(i) Display the last 3 characters of the attribute Ename from the EMPLOYEE
table.
(ii) Find the position of the substring 'ma' in the string 'Informatics'.
27 Mention and briefly explain any two guidelines of netiquette. 2
28 (A) Consider the following two dictionaries: 2
dict1 = {'a': 10, 'b': 20}
dict2 = {'a': 5, 'b': 10, 'c': 20}
Write Python code to create a DataFrame from a list containing the
above two dictionaries.
OR
(B) Mention the purpose of read_csv() and explain the use of its sep
parameter.
Section-C (29 to 32) 4X3 = 12 Marks
29 Consider the following digital security scenarios and answer the questions: 3
(i)
Mehak receives an SMS from an unknown number stating she has won a
lottery. To claim it, she must click a link and enter her Aadhaar number and
bank OTP. What type of cybercrime is this?
(ii)
A group of people repeatedly post insulting comments and spread rumors
about a classmate on a social media platform to distress them. What is this
activity called?
(iii)
Suggest one Communication Etiquette that should be followed to maintain
credibility while participating in an online discussion forum.
30 (A) (i) Write a Python program to create a Pandas Series named 3
Inventory from the following dictionary:
stock = {'Pens': 150, 'Erasers': 80, 'Sharpeners': 60, 'Notebooks': 200}.

(ii) Consider two Series S1 and S2:
import pandas as pd
S1 = pd.Series([10, 20], index=['a', 'b'])
S2 = pd.Series([30, 40], index=['b', 'c'])
Write the output of the statement: print(S1 + S2)

OR
(B) Consider a DataFrame df as shown below:
Name IP Maths

Page | 4

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

Page 6

m
m .co

m .co 0 Arpit 95 88
s e m
se 1 Vani 89 92
g l a
2 Chetan 78 80
Write Pandas statements to perform the following actions:
a
(i) Add a new column 'Total' containing the values [183, 181, 158].
(ii) Rename the 'Name' column to 'Student'.
(iii) Delete the 'Maths' column from the DataFrame.
31 Consider the table HOSPITAL, which contains the following columns: 3
Column Name Remark
PNo Patient Number
PName Patient Name
m
Dept
m Department
.co
.co e m
DOA Date of Admission
m
Table: HOSPITAL
e l as
l as
PNo PName Dept DOA
ag
ag 101 Ravi Kumar
102 Anita Sharma
Cardiology
Neurology
2024-05-12
2025-06-01
103 Mohan Das Cardiology 2023-05-18
104 Seema Verma Orthopedics 2022-04-22
105 Rahul Singh Cardiology 2025-03-30

Write SQL queries to perform the following tasks:
(i) Display the names of all patients in the Cardiology department in
lowercase.
m
.co
(ii) Display each patient's number along with the day name of the week on
which they were admitted.
e m
s
(iii) Display the patient names arranged in alphabetical order.
32
la
(A) Consider a table named STUDENT containing the following data:
g
3
ID Name
1 Aman
a DOB
2005-08-15
2 Vinod 2006-01-26
3 Saurabh 2004-01-01
Write the output of the following SQL queries:
(i) SELECT UPPER(Name), LENGTH(Name) FROM STUDENT
WHERE ID = 2;
(ii) SELECT DAY(DOB), YEAR(DOB) FROM STUDENT WHERE ID =
3;
m
m (iii) SELECT RIGHT(Name, 3) FROM STUDENT WHERE ID = 1;
.co
.co m
OR
m s e
a
(B) Write the output of the following SQL queries:
s e (i) SELECT POWER(MOD(13, 5), 2);
g l
g la (ii) SELECT UCASE(MID("Digital India", 9, 5)); a
a (iii) SELECT LENGTH(TRIM(" Informatics "));
Section-D (33 to 34) 2X4 = 8 Marks MARKS
33 Write a Python program using Matplotlib to plot a Line Graph showing the 4
"Monthly Sales" of a shop with the following data:
Months: ['Jan', 'Feb', 'Mar', 'Apr']
Sales: [12000, 15000, 11000, 18000]
The program should include:
 Code to import the required library.
m .
.co

m Page | 5 se
m
as e g la
g l a
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 5 of 8

Page 7

 Code to plot the line graph with a label "Sales".
 A title "Sales Performance".
 Labels for both X-axis ("Month") and Y-axis ("Amount").
 Code to display the legend and show the plot.
34 (A) Consider the following tables: 4
Table: SPORTS
RegNo SName Game Fees
101 Aryan Cricket 500
102 Riya Tennis 600
103 Kabir Cricket 500
104 Ishaan Tennis 600
105 Tejas Football 750

Table: COACH
CoachID CName Game
C1 Venkatesh Cricket
C2 Rameshwar Tennis
C3 Sridhar Football

Write SQL queries for the following:
(i) Display the Game name and the total fees collected for each game,
but only for those games where the total fees exceed 1000.
(ii) Display the Student Name (SName) and their respective Coach
Name (CName).
OR
(B) Consider the following tables:
Table: Employee
EmpID Name DeptID Salary
301 Aarav D1 5200
302 Riya D2 7500
303 Kabir D2 6800
304 Ananya D3 4000
305 Ishaan D1 4900

Table: Department
DeptID DeptName
D1 HR
D2 IT
D3 Sales

Write the output of the following SQL queries:

(i) SELECT DeptID, COUNT(*), MAX(Salary) FROM Employee
GROUP BY DeptID HAVING COUNT(*) > 1 ORDER BY DeptID;
(ii) SELECT Name, DeptName FROM Employee, Department WHERE
Employee.DeptID = Department.DeptID AND Employee.Salary > 6000;

Section-E (35 to 37) 3X5 = 15 Marks

Page | 6

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

Page 8

m
m .co

c. o 35 s e m
em
Tech-Innovate Pvt Ltd is a leading technology solutions provider renowned 5
s g l a
for delivering innovative digital services to clients worldwide. The company
a
operates from a spacious campus comprising four blocks: Block A, Block B,
Block C, and Block D.

Tech-Innovate Pvt Ltd

Block A Block B

m
.co
Block C Block D
m
m .co
To ensure smooth communication, centralized data storage, and high-speed
s e m
s e
connectivity across the campus, the organization plans to set up a structured
l a
l a
network connecting all blocks.
g ag
a
The following tables provide the distances between the blocks and the
number of computers in each block.
From To Distance (meters)
Block A Block B 40 m
Block A Block C 50 m
Block A Block D 160 m
Block B Block C 70 m
Block B Block D 60 m
Block C Block D 120 m
o m
c
Number of. Computers
em
Block
Block A 25
Block B 60la
s
g
Block C a15
Block D 150
As a network engineer, answer the following questions based on the details
given above:
(i) Suggest the most suitable block to install the server. Justify your answer.
(ii) What type of network (PAN, LAN, MAN, or WAN) will be formed within
the campus?
(iii) Suggest the placement of a Switch with suitable justification.
(iv) The company wants to host a website where clients can log in and see
m
m real-time project updates. Should they develop a Static or a Dynamic
.co
.co em
website? Why?

em s
(v) Identify between which blocks a repeater is needed and justify your
la
s
la 36
answer.
a g
ag (i) Create a DataFrame named StoreDF as shown below using dictionary of 3+1+1
series: =5
Items Quantity Unit_Price
0 Bread 50 30
1 Milk 100 25
2 Eggs 120 6
Write suitable Pandas statements to Perform the following operations:
(ii) Add a new row containing data [Butter, 40, 55]
m .
.co

m Page | 7 se
m
as e g la
g l a
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 7 of 8

Page 9

(iii) Display values of Items column only,
37 (A) Refer to the table given below: 5
Table: BOOK
BookID Title Author Price
201 Wings of Fire A P J Abdul Kalam 350
202 The Guide R. K. Narayan 299
203 The God of Small Things Arundhati Roy 399
204 Malgudi Days R. K. Narayan 280
Write SQL commands for the following tasks:
(i) Insert a new record into the table with the values: 205, The White
Tiger, Aravind Adiga, 350.
(ii) Update the Price of the book with BookID 202 to 325.
(iii) Delete the records of all books written by 'R. K. Narayan'.
(iv) Add a new column Publisher of type VARCHAR(30) to the table.
(v) Drop the table BOOK from the database.
OR
(B) Consider a table named PRODUCT, which contains the following
columns: PCode, PName, Category, Qty, Price, ExpiryDate.
The columns are described as follows:
PCode – A unique code assigned to each product.
PName – The name of the product.
Category – The category or type of the product.
Qty – The available quantity of the product.
Price – The unit price of the product.
ExpiryDate – The expiration date of the product.

Write SQL queries for:
(i) Display PName and its Price rounded to one decimal place.
(ii) Display the names of products that end with the letter 's'.
(iii) Display the PName and Category of those products whose Price is
less than or equal to 500.
(iv) Display the total quantity of all products.
(v) Display PName after removing leading spaces only.

Page | 8

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

Document Details

Board / OrgCBSE
ExamClass 12
TypeSample Paper
Pages8
Updated29 Oct 2026