CBSE Class 12 Question Paper 2026 Solution Informatics Practices

FOR CBSE CLASS 12 EXAM PREPARATION

CBSE Class 12 2026
Question Paper
Solution · Informatics
Practices
EXAM YEAR TYPE SUBJECT

CBSE Class 12 2026 Question Paper Solution Informatics Practices

Notes · Sample Papers · Previous Year Papers · Mock Tests

m
m .co

.co e m
se
m as
Marking Scheme (English Version)
l
ag
Strictly Confidential
(For internal and restricted use only)
Senior Secondary School Examination 2026
SUBJECT NAME: INFORMATICS PRACTICES SUBJECT CODE: 065 (Set 4 Q.P. CODE 90)

General Instructions:

1 The CBSE has decided to introduce On Screen Marking (OSM) for the evaluation of
Class XII answer Book with the 2026 Examination.
m
2
m
You are aware that evaluation is the most important process in the actual and correct
.co
.co e m
assessment of the candidates. A small mistake in evaluation may lead to serious problems

em
which may affect the future of the candidates, education system and teaching profession.
l as
l as
To avoid mistakes, it is requested that before starting evaluation, you must read and
understand the spot evaluation guidelines carefully.
ag
3 ag policy is a confidential policy as it is related to the confidentiality of the
“Evaluation
examinations conducted, evaluation done and several other aspects. Its leakage to the
public in any manner could lead to derailment of the examination system and affect the life
and future of millions of candidates. Sharing this policy/document to anyone, publishing in
any magazine and printing in Newspaper/Website, etc. may invite action under various rules
of the Board and IPC.”

4 Evaluation is to be done as per instructions provided in the Marking Scheme. It should not
be done according to one’s own interpretation or any other consideration. Marking Scheme
m
.co
should be strictly adhered to and religiously followed. However, while evaluating answers
which are based on latest information or knowledge and/or are innovative, they may be

e m
assessed for their correctness otherwise and due marks be awarded to them. In Class-

las
XII, while evaluating two competency-based questions, please try to understand the

ag
given answer and even if the reply is not from the marking scheme but correct
competency is enumerated by the candidate, due marks should be awarded.

5 The Marking scheme carries only suggested value points for the answers.
These are in the nature of Guidelines only and do not constitute the complete answer. The
students can have their own expression and if the expression is correct, the due marks
should be awarded accordingly.

6 The Head-Examiner must go through the first five answer books evaluated by each evaluator
on the first day, to ensure that evaluation has been carried out as per the instructions given
in the Marking Scheme. If there is any variation, the same should be zero after deliberation
m
m .co
and discussion. The remaining answer books meant for evaluation shall be given only after

.co m
ensuring that there is no significant variation in the marking of individual evaluators.

s e
s em Evaluators
7 will mark ( ✓ ) wherever the answer is correct. For wrong a
g l answers CROSS ‘X’ be

l a marked. Evaluators will not put right (✓) while evaluating
a
which gives an impression that

ag answer is correct and no marks are awarded. This is the most common mistake which
evaluators are committing.

8 If a question has parts, please award marks on the right-hand side for each part in the OSM
Portal. Marks awarded for different parts of the question will be totaled up by the OSM
System.

9 If a question does not have any parts, marks must be awarded in the left-hand margin in
the OSM Portal. This may also be followed strictly.

m .
.co s e m
s em l a
ag
[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 1/22 ]

g la
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 1 of 22

10 No marks to be deducted for the cumulative effect of an error. It should be penalized only
once.

11 A full scale of 70 marks has to be used. Please do not hesitate to award full marks if the
answer deserves it.

12 Every examiner has to necessarily do evaluation work for full working hours i.e., 8 hours
every day and evaluate 20 answer books per day in main subjects and 25 answer books per
day in other subjects (Details are given in Spot Guidelines).This is in view of the reduced
syllabus and number of questions in question paper.

13 Ensure that you do not make the following common types of errors committed by the
Examiner in the past :-
● Answers marked as correct, but marks not awarded. (Ensure that the right tick mark is
correctly and clearly indicated. It should merely be a line. Same is with the X for
incorrect answers.)
● Half or a part of the answer marked correct and the rest as wrong, but no marks
awarded.

14 While evaluating the answer books if the answer is found to be totally incorrect, it should
be marked as cross (X) and awarded zero (0) Marks.

15 The Examiners should acquaint themselves with the guidelines given in the “Guidelines for
Spot Evaluation” before starting the actual evaluation.

16 The candidates are entitled to obtain a photocopy of the Answer Book on request on
payment of the prescribed processing fee. All Examiners/Additional Head Examiners/Head
Examiners are once again reminded that they must ensure that evaluation is carried out
strictly as per value points for each answer as given in the Marking Scheme.

17 If a candidate attempts both alternatives/options in a question where only one option/
alternative is required to be attempted, the Evaluator shall award marks in both the
options. The system will take the higher of two scores and disregard the other response.

18 In a question having two options/alternatives, if a candidate has attempted only one,
then the evaluator shall mark “NA” (Not attempted) against the option that has not
been attempted by the candidate.

[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 2/22 ]

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

m
m .co

m .co MARKING SCHEME ase
m
se ag
INFORMATICS PRACTICESl 065
Max. Marks: 70
General Instructions :
(i) All questions are compulsory.

(ii) The examination contains 5 sections - Section A to Section E.

(iii)
m
.co
Section A consists of 21 questions (1 to 21). Each question carries 1 mark.
m
(iv)
.co
Section B consists of 7 questions (22 to 28). Each question carries 2 marks.
m s e m
s e of 4 questions (29 to 32). Each question carries 3 marks. gl a
a
(v) Section C consists

g l a
a D consists of 2 questions (33 to 34). Each question carries 4 marks.
(vi) Section

(vii) Section E consists of 3 questions (35 to 37). Each question carries 5 marks.

(viii) Internal choices have been provided in some questions. Attempt only one of the
choices in such questions.
(ix) All programming questions are to be answered using Python Language only.
m
(x)
.co
In case of MCQs, text of the correct answer should also be written.

s em
Specific Instructions:
g la
a
● The answers given in the marking scheme are SUGGESTIVE. Examiners are requested to award
marks for all alternative correct Solutions/Answers conveying a similar meaning

● All programming questions have to be answered with respect to Python only

● In Python, ignore case sensitivity for identifiers (Variable / Functions / Structures / Class
Names)

m
.co
● In Python indentation is mandatory, however, the number of spaces used for indenting may
m
.co m
vary
s e
●emIn SQL related questions – both ways of text/character entries ashould be acceptable for
as g l
l Example: “AMAR” and ‘amar’ both are acceptable.
a
ag ● In SQL related questions – all date entries should be acceptable for Example: ‘YYYY-MM-DD’,
‘YY-MM-DD’, ‘DD-Mon-YY’, “DD/MM/YY”, ‘DD/MM/YY’, “MM/DD/YY”, ‘MM/DD/YY’ and
{MM/DD/YY} are correct.

● In SQL related questions – semicolon should be ignored for terminating the SQL statements

● In SQL related questions – ignore case sensitivity

m .
.co s e m
s em l a
ag
[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 3/22 ]

g la
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 3 of 22

● In SQL output questions – ignore the column headers

● In SQL output questions – ignore the order of rows until ORDER BY is specified

SECTION - A
1
1. State whether the following statement is True or False :

In Pandas Series, the Positional index can be a string or an integer.

Ans False

(1 mark for writing the correct answer)
1
2. We can add a new row to a DataFrame DF using the _________ method.
(A) DF.add() (B) DF.loc[]
(C) DF.loc() (D) DF.addloc[]

Ans (B) DF.loc[]
(1 Mark for writing the correct option)

1
3. Naveen discarded various types of waste material without realizing that e-waste
contains harmful substances that could pollute the environment. He wants to know
which of the following will be considered as e-waste ?
(A) Plastic Bottle

(B) Broken Smartphone

(C) Aluminium Foil
(D) Banana Peel
Ans (B) Broken Smartphone
(1 Mark for writing the correct option)
4. In which scenario is a bar chart preferred over a line chart ? 1
(A) To visualise monthly temperature trends over a year.

(B) To compare the number of students in different classes.

(C) To show stock price movements over time.

(D) To analyse trends in website traffic over days.

Ans (B) To compare the number of students in different classes
(1 Mark for writing the correct option)

5. Which of the following network topology uses a central cable (backbone) to connect 1
all devices?
(A) Mesh

(B) Star

[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 4/22 ]

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

m
m .co

m .co s e m
se
(C) Tree
g l a
(D) Bus a
Ans (D) Bus
(1 Mark for writing the correct option)

6. State whether the following statement is True or False : 1
In SQL, an aggregate function returns multiple values for each column on which it is
applied.
m
.co
Ans False
m
.co
(1 Mark for writing the correct answer)
m s e m
7.
s e
Rohini has developed a new kind of water purifier that uses a unique filtration method.
g
1l a
l
Which type of
g a Intellectual Property Right should she apply to protect her invention ?
a
a
(A) Trademark
(B) Copyright
(C) Patent
(D) Both Copyright & Trademark
Ans (C) Patent
(1 Mark for writing the correct option)
m
.co
8. Aditya is working on a DataFrame named df. He has written the statement : 1

em
print(df.loc['S2'])
What will the above statement do ?
s
lalabel 'S2'.
g
(A) Display the data of the row having
a
(B) Display the columns of the DataFrame.

(C) Display the data type of the column having label 'S2'.

(D) Display the index numbers of the DataFrame.

Ans (A) Display the data of the row having label 'S2'.

(1 Mark for writing the correct option)
m
om .co
9. What will be the result of the following SQL command ? 1

. c
SELECT LENGTH ('Data Base');
e m
e m (Note: There is a single space between the words Data and Base.)
l as
las (A) 7 (B) 8
ag
ag (C) 9 (D) Error
Ans ( C) 9
(1 Mark for writing the correct option)
10. Which of the following is a key feature of a Static Web Page ? 1
(A) Its content updates very frequently.
(B) It displays different content to different users.
m .
.co s e m
s em l a
ag
[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 5/22 ]

g la
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 5 of 22

(C) It loads slower than a Dynamic Web Page.
(D) It shows the same content unless the code is manually updated.
Ans (D) It shows the same content unless the code is manually updated.
(1 Mark for writing the correct option)

11. Which of the following is the correct expanded form of DML ? 1
(A) Device Management Language
(B) Device Manipulation Language
(C) Data Management Language
(D) Data Manipulation Language

Ans (D) Data Manipulation Language
(1 Mark for writing the correct option)
12. CSV stands for ___________________ Separated Values. 1
(A) Colon
(B) CTRL
(C) Comma
(D) Caret
Ans (C) Comma
(1 Mark for writing the correct option)
13. Which of the following is an example of maintaining good net etiquette ? 1
(A) Spamming emails or messages to strangers.
(B) Ignoring other’s opinions in online discussions.
(C) Not using copyrighted materials without permission of the owner.
(D) Sharing someone’s private information publicly.

Ans (C) Not using copyrighted materials without permission of the owner.
(1 Mark for writing the correct option)
14. In the context of creating a Pandas Series from a dictionary, which of the following 1
statement is correct ?
(A) The values of the dictionary become the indices of the Series.
(B) The keys of the dictionary become the values of the Series.
(C) The keys of the dictionary become the indices of the Series.
(D) The Series will have default integer indices starting from 0, ignoring the dictiona
keys.
Ans (C) The keys of the dictionary become the indices of the Series
(1 Mark for writing the correct option)

15. In Pandas, when extracting a portion of a Series ser1 using ser1[start:end] with 1

[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 6/22 ]

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

m
m .co

m .co s e m
se
positional indices start and end, which of the following statements is true ?
g l a
a
(A) The element at the end index is included in the output.
(B) The element at the end index is excluded from the output.
(C) The elements at both the start and end indices are excluded from the
output.
(D) The element at the start index is excluded from the output.

Ans (B) The element at the end index is excluded from the output.
(1 Mark for the correct answer)
m
m .co
.co
16. Nisha is using an Android app to make a voice call over the internet to her friend in 1
another country. Which protocol is being used in this case ?
e m
(A) Chat
em l as
(B) VoIP
l as ag
ag
(C) Email
(D) TV
Ans (B) VoIP
(1 Mark for the correct answer)
17. State whether the following statement is True or False : 1
The INSTR(string1, string2) function in SQL returns 0 if string2 is not
present as a substring in string1.
Ans True
m
.co
(1 Mark for the correct answer)

18.
s em
In a Pandas DataFrame, which value for the axis will be used to delete a column ? 1
(A) axis = -1
g la
(B) axis = 0
(C) axis = 1 a
(D) axis = 2
Ans (C) axis = 1
(1 Mark for the correct answer)

19. What will be the result of the following SQL command : 1

m
SELECT ROUND(15.678, 2);

m .co
(A) 15.00

.co m
(B) 15.67
s e
em a
(C) 15.68
s g l
la Ans (C) 15.68
(D) 16.00

g a
a (1 Mark for the correct answer)

Q. 20 and Q. 21 are Assertion (A) and Reason (R) Type questions. Choose the correct
option as :
(A) Both (A) and (R) are True, and (R) correctly explains (A).
(B) Both (A) and (R) are True, but (R) does not correctly explain (A).

m .
.co s e m
s em l a
ag
[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 7/22 ]

g la
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 7 of 22

(C) (A) is True, but (R) is False.
(D) (A) is False, but (R) is True.

20. Assertion (A) : Pandas DataFrame can store values of multiple data types in multiple 1
Columns.
Reason (R) : DataFrames are implemented using 2D arrays, which allows only numeric
values.
Ans
(C) (A) is True, but (R) is False.
(1 Mark for writing the correct option)
21. Assertion (A) : The output of the SQL query SELECT COUNT (name) FROM 1
students; will differ from the output of SELECT COUNT (*) FROM students; if
there are some NULL values in the name column.
Reason (R) : COUNT (column_name) returns the count of NON NULL values in that
column, whereas COUNT(*) returns the number of records in the table.
Ans (A) Both (A) and (R) are True, and (R) correctly explains (A).
(1 Mark for writing the correct option)
SECTION - B
22. (a) List any two characteristics of Pandas library in Python. 2

Ans
(a) Characteristics of Pandas library in Python:
Tabular data structure : Works with data in the form of DataFrames (tables)
and Series
Easy data handling: Allows quick reading, writing, and modification of data
Powerful data analysis :Supports filtering, sorting, grouping, and calculations
Handles missing data :Can easily detect and fill/remove missing values
Fast and efficient :Works well even with large datasets
Supports multiple file formats :Can read/write multiple file formats like CSV,
Excel.
(1 Mark each for writing any two correct characteristics)

OR

(b) Briefly explain the purpose of Boolean Indexing with respect to DataFrames.
Support your answer with a suitable example.
Ans
(b) Boolean Indexing is used to filter and extract specific rows from a DataFrame
based on given condition(s). It returns only those rows where the condition is
True.

Example:
import pandas as pd
data = {'Name': ['Ajay', 'Riya', 'David', 'Peter'],
'Age': [25, 30, 35, 40],'Score': [85, 90, 95, 80]}
df = pd.DataFrame(data)
condition = df['Age'] > 30
result = df[condition]

[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 8/22 ]

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

m
m .co

m .co s e m
se
print(result)

g l a
Output a
Name Age Score
2 David 35 95
3 Peter 40 80
(1 Mark for explaining the purpose of Boolean Indexing and 1 Mark for writing
any correct example)
Note:
Full 2 marks if indexing is explained only using example with correct condition
m
m .co
(with or without output).
23.
.co
Anjana had created a website using free design elements sourced from different 2
s e m
em a
creators online. She then published the site for public access but did not mention

as g l
a
the source of the design elements used.
l
ag
(i) Identify one possible violation of IPR in this situation,
(ii) Name any two licensing models that allow legal reuse of digital creative work
with conditions.
Ans
(i) Copyright Infringement/Copyright Violation
(ii) Creative Commons (CC) licenses,
GNU General Public License (GPL)
(1 Mark for part (i) and ½ mark for writing each correct example in part (ii))
NOTE: Open Source to be accepted for part (ii)
m
24. Define the following terms with respect to RDBMS :
.co 2
a. Domain
s em
la that a column (attribute) can contain.
b. Tuple
Domain: The set of all possible g
Ans
a.
b. a a complete record.
values
Tuple: A row in a table representing
a. (1 Mark for writing the correct definition of Domain)
b. (1 Mark for writing the correct definition of Tuple)
25. (a) Explain the role of the following network devices in a network : 2
(I) Modem
(II) Gateway
Ans (a) (I) Modem: Converts digital signals into analog signals and vice versa.
m
.co
(II) Gateway: A gateway acts as a bridge between two different networks.
m
.co m
(1 Mark for explaining correct role of Modem)

s e
em
(1 Mark for explaining correct role of Gateway)

s OR
g l a
g la Ans (b) (b) Differentiate between add-ons and plug-ins in a web browser. a
a
Add-ons Plug-ins

● Add-ons enhance or customize the ● Plug-ins are designed to enable
browser like adding features, the browser to handle specific
blocking ads, managing passwords, types of content.
etc. ● Example: Adobe Flash Player

m .
.co s e m
s em l a
ag
[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 9/22 ]

g la
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 9 of 22

● Example: Mozilla Firefox add-ons
like ad blockers or theme
changers.
(2 Marks for differentiating between Add-ons and Plug-ins
(Full 2 marks to be awarded if difference explained through example)
Note: 1 mark to be awarded if either Add-ons or Plug-ins is explained
26. Write SQL queries to perform the following : 2
(I) Display the month (in numeric form) of the date '2026-01-01'.
(II) Display only the year part from the date '2026-01-01'.
Ans
(I) SELECT MONTH('2026-01-01');
(II) SELECT YEAR('2026-01-01');
(I) (½ mark for writing SELECT, ½ mark for MONTH('2026-01-01'))
(II) (½ mark for writing SELECT, ½ mark for YEAR('2026-01-01'))
27. (a) What is data protection ? 2
(b) Mention any two precautionary measures one can take to avoid the risk of
cybercrime.
Ans (a) Data protection refers to the practice of safeguarding data from unauthorized
access, misuse, loss, or damage.
(1 Mark for writing the correct definition of data protection)
(b) Precautions to avoid cybercrime (Any two):
(i) Use strong passwords and do not share them.
(ii) Avoid clicking on suspicious links or emails.
(iii) Install and regularly update antivirus software.
(iv) Do not share personal or sensitive information online.
(½ Mark for writing each correct precaution)
28. (a) Niharika wants to create a Pandas Series using a NumPy array with three 2
elements ‘a’, ‘b’, and ‘c’, and assign custom indexes ‘first’,’second’ and
‘third’. Help her complete the code below.
import pandas as pd
import ______ as np
arr = np.______ (['a','b','c'])
s = pd._____(arr,______=['first','second','third'])
print(s)

Ans (a) import pandas as pd
import numpy as np
arr = np.array(['a', 'b', 'c'])
s = pd.Series(arr, index=['first', 'second', 'third'])
print(s)

(½ Mark for filling each blank correctly)

Ans OR
(b) Write the output of the following code:
import pandas as pd
s1 = pd.Series ([1,2,3], index = ['a','b','c'])

[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 10/22 ]

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

m
m .co

m .co s e m
se
s2 = pd.Series ([4,5,6], index = ['b','c','d'])
print(s1 + S2)
g l a
(b) a NaN
a
b 6.0
c 8.0
d NaN

(½ Mark for writing each correct row of output)
Note:
● Full 2 marks to be awarded if ERROR in code is mentioned, as in print()
m
m .co
statement S2 is in uppercase

.co m
● Mentioning "dtype:float64" in the output to be ignored.
s e
em
● 1 mark for writing either of the correct column of output

s
● ½ Mark for any 2 correct values in the given output
g l a
l a a
ag SECTION - C
29. Mandeep received an email stating he won a lottery though he had never participated 3
in any such event. He was asked to provide bank details to process the amount.
Mandeep provided the required details but within next few minutes ₹ One lakh was
debited from his account.
Answer the following questions based on the given case study :
(i) Mandeep is the victim of which type of cybercrime ?
Ans (i) Mandeep is a victim of Phishing.
m
(1 Mark for writing correct type of cybercrime)

m .co
e
Note: Online Fraud/Scam to be accepted.

las
(ii) Other than email, mention any two common methods through which this type of

Ans ag
cybercrime is being committed these days.
(ii) Common methods through which this type of cybercrime is being committed are as
follows:
SMS
Voice calls
Social Media
Fake Websites
Whatsapp messages

m
(½ Mark each for mentioning Any two correct methods of cybercrime)

m
(iii) Name one law that safeguards the rights of Internet users in India.
.co
.co e m
Ans (iii) Information Technology (IT) Act 2000

em
OR
l as
s
la 30.
IT Act
ag
g
(1 Mark for naming the correct law)
a (a) Write a Python program to create and display a Pandas Series as shown below :
July 31
3

Aug 31
Sept 30
Oct 31
The index labels are the names of the months - July, Aug, Sept, Oct.

m .
.co s e m
s em l a
ag
[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 11/22 ]

g la
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 11 of 22

The corresponding scalar values are the number of days in these respective months
- 31, 31, 30, 31.
Ans import pandas as pd
months = ['July', 'Aug', 'Sept', 'Oct']
days = [31, 31, 30, 31]
s = pd.Series(days, index=months) OR s = pd.Series(days, months)
print(s)
OR
import pandas as pd
days = pd.Series(data=[31, 31, 30, 31],
index=['July', 'Aug', 'Sept', 'Oct'] )
print(days)

OR
import pandas as pd
days = pd.Series({'July':31, 'Aug':31, 'Sept':30, 'Oct':31})
print(days)
(½ Mark for correct import statement)
(½ Mark for creating index of months)
(½ Mark for creating corresponding values of days)
(1 Mark for pd.Series( ) )
(½ Mark for correct print statement)
OR 3
(b) A CSV file named customer.csv contains records of customers. The first row
of the file represents the header. Sample data from the file is shown below :
Name, Age, City
Rudra,17,Kolkata
Divya,19,Dehradun
Nabeel,22,Lucknow
Write a Python program to import data from the CSV file into a Pandas
DataFrame named DF and display the last two rows.
Ans (b) import pandas as pd
DF = pd.read_csv("customer.csv")
print(DF.tail(2))
(1 Mark for each correct statement)
Note: ignore Path of csv file if mentioned by the student
31. (i) Write an SQL statement to create a table named PRODUCTS with the following 3
specifications :
Column Name Data Type Key
PID Integer Primary Key
PName Varchar of size 30
PCat Char of size 15
Price Decimal Number
Ans CREATE TABLE PRODUCTS (
PID INT PRIMARY KEY,
PName VARCHAR(30),
PCAT CHAR(15),
PRICE FLOAT

[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 12/22 ]

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

m
m .co

m .co );
s e m
se (½ Mark for CREATE TABLE PRODUCTS)
g l a
(½ Mark for correct attributes and datatypes) a
(½ Mark for Primary Key)
(ii) Write an SQL query to increase the price of all the items by 100, whose product
category is Grocery, in the table PRODUCTS.
Ans UPDATE PRODUCTS SET PRICE=PRICE+100 WHERE PCAT='Grocery';
(½ Mark for writing UPDATE PRODUCTS)
(½ Mark for SET PRICE=PRICE+100)
(½ Mark for WHERE PCAT='Grocery')
m
m .co
.co
32. (a) Consider the following tables : 3
e m
s
Table 1 : TEACHER, which stores Teacher ID (TID), Teacher Name (TName),
em
s TName
Experience (Experience) and City (City) that they live in.
g l a
l a a
a1g Kartik
TID Experience City
5 Bhopal
2 Shahnaz 6 Nagpur
3 Rajendra 7 Delhi
4 Tanvi 4 Bhopal
5 Alam 9 Delhi

m
.co
Table 2 : SUBJECT, which stores Subject ID (SID), Subject Name
(SubName) and ID of the teacher(TID) teaching that Subject.
SID SubName
s emTID
101 Physics
g la 1
102 Chemistry a 2
103 Mathematics 3
104 Informatics Practices 4
105 Computer Science 5
Write appropriate SQL query for the following:

m
(I) Delete the record of the subject whose TID is equal to 4.

m
c. o(I) DELETE FROM SUBJECT WHERE TID = 4; m.co
Ans
m s e
s e g l a
g la a
a
(½ Mark for DELETE FROM SUBJECT)
(½ Mark for WHERE TID=4)

(II) Display the names of teachers who have more than 5 years of experience and
who stay in Nagpur.

Ans (II) SELECT TNAME FROM TEACHER WHERE EXPERIENCE>5 AND CITY =
'Nagpur';

m .
.co s e m
s em l a
ag
[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 13/22 ]

g la
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 13 of 22

(½ Mark for SELECT TNAME FROM TEACHER)
(½ Mark for WHERE EXPERIENCE>5 AND CITY='Nagpur')

(III) Display subject names along with their teacher names.

Ans (III) SELECT SUBNAME, TNAME FROM SUBJECT NATURAL JOIN TEACHER;

OR
SELECT SUBNAME, TNAME FROM SUBJECT, TEACHER
WHERE SUBJECT.TID = TEACHER.TID;
OR
SELECT SUBNAME, TNAME FROM SUBJECT S, TEACHER T
WHERE S.TID = T.TID;
OR
SELECT SUBNAME, TNAME FROM SUBJECT S JOIN TEACHER T
ON S.TID = T.TID;

(½ Mark SELECT SUBNAME, TNAME FROM SUBJECT, TEACHER)
(½ Mark NATURAL JOIN TEACHER OR WHERE SUBJECT.TID=TEACHER.TID)

OR
(b) Consider the table LIBRARY as given below.
BookId Title Genre Price
101 Python Basics Technology 278
201 The Silent Patient Fiction 340
301 Data Science Technology 291
401 Oceans Marine Life NULL

(I) Which attribute(s) can be considered as the Candidate keys(s)? Justify your
answer.

Ans (I) BookId
BookId is unique to every row of table.
NOTE:
BookId and Title to be accepted with correct justification
(½ Mark for writing correct attribute)
(½ Mark for Justification)
(II) Write an SQL query to insert a new record with the following values:
BookId : 501
Title : AI for ALL
Genre : Technology
Price : 589
Ans (II) INSERT INTO LIBRARY
VALUES (501, 'AI for ALL', 'Technology', 589);
OR
INSERT INTO LIBRARY (BookId, Title, Genre, Price)
VALUES (501, 'AI for ALL', 'Technology', 589);

(½ Mark for INSERT INTO LIBRARY)
(½ Mark for VALUES((501, 'AI for ALL', 'Technology', 589);)

[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 14/22 ]

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

m
m .co

m .co s e m
(III) Write an SQL query to add a new column Author that is a character data type of
size 20.
g la
se Ans (III) ALTER TABLE LIBRARY ADD COLUMN AUTHOR VARCHAR(20);
a
OR
ALTER TABLE LIBRARY ADD AUTHOR VARCHAR(20) ;
OR
ALTER TABLE LIBRARY ADD COLUMN AUTHOR CHAR(20) ;
OR
ALTER TABLE LIBRARY ADD AUTHOR CHAR(20) ;
(½ Mark for ALTER TABLE LIBRARY)
m
.co
(½ Mark for ADD AUTHOR VARCHAR(20)/CHAR(20))
m
.co
SECTION - D

e m
33.
em
Ms. Anjali, a data analyst, has been assigned the task of creating a histogram to 4
l as
l as
display the age distribution of ten participants in a workshop. She has been provided
with the following list of their ages :
ag
ag
Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23]
She has started writing a Python program for it. However, the code is incomplete.
Help her complete the program by filling in the missing parts, so that the histogram
as shown below is displayed.

m
m .co
s e
g la
a

import matplotlib.pyplot as plt
Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23]

m
binsize = [20,22,24,26,28,30]

m .co
plt._______(Ages, bins=binsize, edgecolor = 'black', label =

.co m
'Participants') # Statement-1

m _____.xlabel('Age') # Statement-2
s e
s e plt.ylabel('Number of Participants')
g l a
g la plt.title("Age Distribution") a
a plt._______
__________
# Statement-3
# Statement-4

(I) Write the suitable code for the blank space in the line marked as Statement-1 which
plots the histogram.
Ans hist

m .
.co s e m
s em l a
ag
[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 15/22 ]

g la
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 15 of 22

(1 Mark for mentioning hist)
(II) Fill in the blank in Statement-2 to use the correct alias of the required module to set
the label on x-axis.
Ans plt
(1 Mark for mentioning plt)
(III) Fill in the blank in Statement-3 with the correct Python code to display the legend on
the graph.
Ans legend()

(1 Mark for mentioning legend())
Note: ½ mark to be awarded if legend is mentioned without ()
(IV) Fill in the blank in Statement-4 with the appropriate Python code to display the
graph.
Ans plt.show()

(1 Mark for mentioning plt.show())
Note: ½ mark to be awarded for plt, ½ mark for show(), if plt.show is
mentioned without () ½ mark should be awarded
34. (a) Shalini, who works as a database designer in the hotel industry, has created a 4
table named Guest to keep track of guest details as shown below :
Table : Guest
GuestID GuestName RoomNumber CheckInDate Charges
G101 Harish 101 2025-04-03 3000
G102 Sunita 101 2025-04-03 3000
G103 Ramesh 102 2025-05-04 5000
G104 Bhumika 103 2025-06-02 3500
Write a suitable SQL query for the following :
(I) Display last 3 characters of guest name in upper case.
Ans SELECT UPPER(RIGHT(GuestName, 3)) FROM Guest;
OR
SELECT UPPER(SUBSTR(GuestName, -3)) FROM Guest;
OR
SELECT UPPER(SUBSTRING(GuestName, -3)) FROM Guest;

(½ Mark for RIGHT() OR SUBSTR() OR SUBSTRING())
(½ Mark for UPPER()/UCASE())

(II) Display the name of the guest along with the day name of check-in date.
Ans SELECT GuestName, DAYNAME(CheckInDate) FROM Guest;
(½ Mark for SELECT GuestName)
(½ Mark for DAYNAME())
(III) Display the remainder when charges are divided by 1000.
Ans SELECT MOD(Charges,1000) FROM Guest;

(½ Mark for SELECT)

[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 16/22 ]

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

m
m .co

m .co s e m
(½ Mark for MOD())
se (IV) Extract and display three characters, starting from the second
g a
lcharacter,
name.
a of each guest

Ans SELECT SUBSTR(GuestName,2,3) FROM Guest;
OR
SELECT MID(GuestName,2,3) FROM Guest;
(½ Mark for SELECT)
(½ Mark for SUBSTR()/ MID())

m
.co
OR
(b)
m
Consider the following table and write the output of the following SQL Queries.
o m
. c
Table : ORDERS
ORDERID mCUSTOMERNAME TOTALAMOUNT DISCOUNT ORDERDATE s e
e Hemant l a
101 as g
l 5000 10 2024-03-01
a
ag
102 Neha 7000 15 NULL
103 Keshav 3000 5 2024-01-20
104 Sandhya 4500 NULL 2023-12-25

Write the output of the following SQL Queries :
I. SELECT CUSTOMERNAME FROM ORDERS WHERE DISCOUNT IS NOT NULL;

Ans
m
CUSTOMERNAME
m .co
Hemant
s e
Neha
g la
Keshav a
(1 Mark for correct output)
II. SELECT CUSTOMERNAME, DISCOUNT FROM ORDERS WHERE DISCOUNT BETWEEN
5 AND 10;
Ans CUSTOMERNAME DISCOUNT

m
.co
Hemant 10

m
c. (1o Mark for correct output) m
Keshav 5

s e
s eIII.m SELECT MONTHNAME(ORDERDATE) FROM ORDERS WHERE ORDERDATE
g l a IS NOT
g la a
a Ans NULL;
MONTHNAME(ORDERDATE)
March
January
December

(1 Mark for correct output)
m .
.co s e m
s em l a
ag
[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 17/22 ]

g la
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 17 of 22

IV. SELECT ORDERID, DAY(ORDERDATE) FROM ORDERS;

Ans ORDERID DAY(ORDERDATE)
101 1
102 NULL
103 20
104 25

(1 Mark for correct output)
SECTION - E

35. My Solutions Pvt. Ltd. is a reputed software development and IT consulting firm. The 5
company’s head office is located in Mysuru, and it has a regional office in Chennai. The
Mysuru office comprises four departments: Human Resources, Research, Design and
Technical Support.

Mysuru Head Office

Human
Research
Resources

Chennai
Design Regional
Technical
Support
The distances between these departments and between Mysuru and Chennai are as
follows :

Human Resources to Research 55 metres
Human Resources to Design 75 metres
Human Resources to Technical Support 140 metres
Research to Design 40 metres
Research to Technical Support 80 metres
Design to Technical Support 60 metres
Mysuru Office to Chennai Office 350 kilometres

The number of computers in each department/office is as follows :
Human Resources 30
Research 80
Design 50
Technical Support 20
Chennai Office 35
As a network engineer, you have to propose solutions for various queries listed from I
to V.

[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 18/22 ]

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

m
m .co

m .co s e m
se
I.
l a
Identify the most suitable department to install the main server in the Mysuru
office. Justify your answer with a valid reason.
ag
Ans Research department.
Justification: Research department has maximum number of computers.

(½ Mark for writing the correct department)
(½ Mark for correct justification)

II. Create a cable layout design to establish Wired network connectivity between the
m
.co
departments in the Mysuru Office.
m
Ans
.co s e m
em Office
MysurusHead
g l a
g la a
aHuman Research
Resources

Design Technical
,

(1 Mark for creating correct cable layout)
m
.co
Note: Any other valid cable layout design to be accepted

e m
s
III. Suggest the appropriate network device to connect multiple computers within the
la
g
Research department.

Ans Switch or Hub a
(1 Mark for writing appropriate network device)

IV. What type of network (LAN, MAN, WAN) would best connect the Mysuru and Chennai
office ?

Ans WAN
m
m
c. oV. Which device should be used if the signal strength weakens while transmitting
(1 Mark for writing correct type of network)
m .co
s e
m between the Human Resources and Technical Support departmentsladue to the data
s e g
l a a
long

ag
distance between them ?

Ans Repeater

(1 Mark for writing the correct device)

36. Consider the DataFrame Scholarship shown below : 3+
1+
Name Course Amount 1=

m .
.co s e m
s em l a
ag
[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 19/22 ]

g la
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 19 of 22

0 Ananya B.Sc. 62000 5
1 Karan B.Tech 67000
2 Simran MCA 64000
3 Rahul BCA 70000
4 Priya BA 69000
Answer the following questions :
I. Write Python code to create and display the given DataFrame using the Dictionary
of Series method.
Ans import pandas as pd
# Creating Series for each column
name = pd.Series(["Ananya", "Karan", "Simran", "Rahul",
"Priya"])
course = pd.Series(["B.Sc.", "B.Tech", "MCA", "BCA", "BA"])
amount = pd.Series([62000, 67000, 64000, 70000, 69000])
# Creating DataFrame using Dictionary of Series
data = {"Name": name, "Course": course, "Amount": amount }
Scholarship = pd.DataFrame(data)
# Display the DataFrame
print(Scholarship)

OR
import pandas as pd
# Creating Series for each column
Name=["Ananya", "Karan", "Simran", "Rahul", "Priya"]
Course=["B.Sc.", "B.Tech", "MCA", "BCA", "BA"]
Amount=[62000, 67000, 64000, 70000, 69000]
name = pd.Series(Name)
course = pd.Series(Course)
amount = pd.Series(Amount)
# Creating DataFrame using Dictionary of Series
data = {"Name": name, "Course": course, "Amount": amount}
Scholarship = pd.DataFrame(data)
# Display the DataFrame
print(Scholarship)
(½ Mark for import pandas as pd)
(½ Mark each for creation of Series for columns - Name, Course and Amount)
(½ Mark for creation of DataFrame using dictionary of Series)
(½ Mark for displaying the DataFrame)
II. Rename row indexes to ['a', 'b', 'c', 'd', 'e']
Ans Scholarship.index = ['a', 'b', 'c', 'd', 'e']
OR
Scholarship = Scholarship.set_axis(['a', 'b', 'c', 'd', 'e'],
axis=0)
OR
Scholarship = Scholarship.rename(index={0: 'a', 1: 'b', 2: 'c',
3: 'd',4: 'e'})
OR

[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 20/22 ]

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

m
m .co

m .co Any other valid method
s e m
se (1 mark for correctly renaming the row indexes)
g l a
OR a
(½ mark for writing set_axis , ½ mark for correct values ['a','b','c','d','e'] )
III. Write Python statement to remove the last row of the given DataFrame
Ans Scholarship = Scholarship.drop(Scholarship.index[-1])
OR
Scholarship = Scholarship.iloc[:-1]
OR
Scholarship = Scholarship.drop('e')
m
OR
m .co
.co
Scholarship = Scholarship.drop(4)
s e m
OR
s em g l a
l a
Scholarship.drop(Scholarship.index[-1], inplace=True)
a
ag
OR
Scholarship = Scholarship.drop(Scholarship.tail(1).index)
(½ mark for writing Scholarship.drop()/iloc[] )
(½ mark for writing correct argument of drop()/iloc[] )
37 (a) Write suitable SQL query for the following : 5
I. To display only the date part from the date/time expression '2026-01-01
10:10:10'
Ans SELECT DATE('2026-01-01 10:10:10');
m
.co
(½ Mark for SELECT)
(½ Mark for DATE () with datetime string)
e m
II.
s
To convert all customer names from the Cust_Name column to lowercase in the
la
Ans
Customer table.
SELECT LOWER(Cust_Name) FROM Customer; ag
OR
SELECT LCASE(Cust_Name) FROM Customer;
(½ Mark for SELECT)
(½ Mark for LOWER ()/LCASE())
III. To extract the first 4 characters from the City_Name column in Location
table.

m
.co
Ans SELECT LEFT(City_Name,4) FROM Location;

m OR

m .co SELECT SUBSTR(City_Name,1,4)FROM Location;
s e m
s e OR
g l a
la a
SELECT MID(City_Name,1,4)FROM Location;

ag ( ½ Mark for SELECT )
( ½ Mark for correct SQL function LEFT() or SUBSTR())
IV. To display the name of the city from the CITY column in EVENT table, after
removing leading spaces.
Ans SELECT LTRIM(CITY) FROM EVENT;
( ½ Mark for SELECT )
( ½ Mark for correct SQL function LTRIM())
V. To find the average salary from Salary column in Employees table.
m .
.co s e m
s em l a
ag
[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 21/22 ]

g la
a For more Question Papers, Sample Papers, Notes & Syllabus visit Page 21 of 22

Ans SELECT AVG(Salary) FROM Employees;
OR
SELECT SUM(Salary)/COUNT(Salary) FROM Employees;
( ½ Mark for SELECT )
( ½ Mark for correct SQL function AVG() OR SUM()/COUNT())
OR
(b) Write suitable SQL query for the following :
I. To display the value of 172 .
Ans SELECT POW(17,2);
OR
SELECT POWER(17, 2);
( ½ Mark for SELECT )
( ½ Mark for correct SQL function POW()/ POWER())
II. To display the day part of the dates in the Hire_Date column of the
Employee table.
Ans SELECT DAY(Hire_Date)FROM Employee;
( ½ Mark for SELECT )
( ½ Mark for correct SQL function DAY())
Note : DAYOFMONTH() also to be accepted
III. To display the maximum value of the Bill_Amount column in the Bill
table.
Ans SELECT MAX(Bill_Amount) FROM Bill;
( ½ Mark for SELECT )
( ½ Mark for correct SQL function MAX())
IV. To remove leading and trailing spaces from the Location column in the
Branch table.
Ans UPDATE Branch SET Location = TRIM(Location);
OR
SELECT TRIM(Location) FROM Branch;
( ½ Mark for UPDATE/SELECT )
( ½ Mark for correct SQL function TRIM())
V. To display total salary from tot_sal column in Employees table.
Ans SELECT SUM(tot_sal) FROM Employees;
( ½ Mark for SELECT )
( ½ Mark for correct SQL function SUM())

Note:
SELECT tot_sal FROM Employees; to be accepted
( ½ Mark for SELECT )
( ½ Mark for correct column)

[ CBSE MS Informatics Practices Subject Code 065 Paper Code 90 Class 12 Main 2026 Page: 22/22 ]

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