CBSE Class 12 Question Paper 2026 Informatics Practices
Download the CBSE Class 12 Question Paper 2026 Informatics Practices PDF for free at AglaSem. Solving this previous year question paper helps you understand the real CBSE Class 12 exam pattern, question types, difficulty level and marking scheme, and reveals important repeated topics — practise it to build speed, accuracy and exam confidence.
Latest News
Finished viewing? Save it for later —
Download CBSE Class 12 Question Paper 2026 Informatics Practices (PDF · 33 pages)Downloaded 101 times
About CBSE Class 12 Question Paper 2026 Informatics Practices
CBSE Class 12 Question Paper 2026 Informatics Practices is available here for free download. Published by CBSE for Class 12, this question paper can be viewed online or downloaded as a PDF (33 pages). Candidates preparing for Class 12 can use CBSE Class 12 Question Paper 2026 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 Question Paper 2026 Informatics Practices?
Open this page and click the Download button to save CBSE Class 12 Question Paper 2026 Informatics Practices as a PDF. It is completely free on AglaSem Docs.
Is CBSE Class 12 Question Paper 2026 Informatics Practices free to download?
Yes. CBSE Class 12 Question Paper 2026 Informatics Practices can be viewed online and downloaded as a PDF free of cost on AglaSem Docs.
How many pages does CBSE Class 12 Question Paper 2026 Informatics Practices have?
CBSE Class 12 Question Paper 2026 Informatics Practices contains 33 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 Question Paper 2026 Informatics Practices – Text
Read the full text of this question paper below — useful to quickly search, copy and reference the content online without downloading the PDF.
📄 View text version (33 pages)
Page 1
FOR CBSE CLASS 12 EXAM PREPARATION
CBSE Class 12 2026
Question Paper ·
Informatics Practices
EXAM YEAR TYPE SUBJECT
CBSE Class 12 2026 Question Paper Informatics Practices
Notes · Sample Papers · Previous Year Papers · Mock Tests
CBSE Class 12 2026
Question Paper ·
Informatics Practices
EXAM YEAR TYPE SUBJECT
CBSE Class 12 2026 Question Paper Informatics Practices
Notes · Sample Papers · Previous Year Papers · Mock Tests
Page 2
m
m .co
m .co s e m
se g l a
Series : QR1SP a SET-4
-
Q.P. Code
90
. - -
Roll No. -
Candidates must write the Q.P. Code
m
.co
on the title page of the answer-book.
{} m
.co s e m
:
s em NOTE :
l a
ag
la - (I) Please check that this question
(I) g
a
31 paper contains 31 printed pages.
(II) - - (II) Q.P. Code given on the right hand
- - side of the question paper should
be written on the title page of the
answer-book by the candidate.
(III) - 37 (III) Please check that this question
m
paper contains 37 questions.
m (IV) Please .co
(IV) ,
- a
e
s
write down the serial
number of the question in the
l
ag answer-book at the given
place before attempting it.
(V) - 15 (V) 15 minute time has been allotted
- to read this question paper. The
question paper will be distributed
10.15 10.15 10.30
at 10.15 a.m. From 10.15 a.m. to
- 10.30 a.m., the candidates will
- read the question paper only and
m on the
will not write any answer
om
answer-book during this period.
. co
. c e m
e m as
s gl
g la a
a INFORMATICS PRACTICES
: 3 : 70
Time allowed : 3 hours Maximum Marks : 70
90* 2399 1 * Page 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 32
m .co
m .co s e m
se g l a
Series : QR1SP a SET-4
-
Q.P. Code
90
. - -
Roll No. -
Candidates must write the Q.P. Code
m
.co
on the title page of the answer-book.
{} m
.co s e m
:
s em NOTE :
l a
ag
la - (I) Please check that this question
(I) g
a
31 paper contains 31 printed pages.
(II) - - (II) Q.P. Code given on the right hand
- - side of the question paper should
be written on the title page of the
answer-book by the candidate.
(III) - 37 (III) Please check that this question
m
paper contains 37 questions.
m (IV) Please .co
(IV) ,
- a
e
s
write down the serial
number of the question in the
l
ag answer-book at the given
place before attempting it.
(V) - 15 (V) 15 minute time has been allotted
- to read this question paper. The
question paper will be distributed
10.15 10.15 10.30
at 10.15 a.m. From 10.15 a.m. to
- 10.30 a.m., the candidates will
- read the question paper only and
m on the
will not write any answer
om
answer-book during this period.
. co
. c e m
e m as
s gl
g la a
a INFORMATICS PRACTICES
: 3 : 70
Time allowed : 3 hours Maximum Marks : 70
90* 2399 1 * Page 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 32
Page 3
:
(i)
(ii) - 5 –
(iii) - 21 (1 21 ) 1
(iv) - 7 (22 28 ) 2
(v) - 4 (29 32 ) 3
(vi) – 2 (33 34 ) 4
(vii) - 3 (35 37 ) 5
(viii)
(ix) Python
(x) (MCQ) , Text
–
1. 1
Pandas Series , (Positional index) (string)
(integer)
2. ______ (method) DataFrame DF (row)
1
(A) DF.add() (B) DF.loc[]
(C) DF.loc() (D) DF.addloc[]
3. -
(e-waste)
- (e-waste) ? 1
(A) (B)
(C) (D)
90* 2 * Page
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 2 of 32
(i)
(ii) - 5 –
(iii) - 21 (1 21 ) 1
(iv) - 7 (22 28 ) 2
(v) - 4 (29 32 ) 3
(vi) – 2 (33 34 ) 4
(vii) - 3 (35 37 ) 5
(viii)
(ix) Python
(x) (MCQ) , Text
–
1. 1
Pandas Series , (Positional index) (string)
(integer)
2. ______ (method) DataFrame DF (row)
1
(A) DF.add() (B) DF.loc[]
(C) DF.loc() (D) DF.addloc[]
3. -
(e-waste)
- (e-waste) ? 1
(A) (B)
(C) (D)
90* 2 * Page
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 2 of 32
Page 4
m
m .co
m .co s e m
se g l a
General Instructions : a
(i) All questions are compulsory.
(ii) The examination paper contains 5 sections – Section A to Section E.
(iii) Section A consists of 21 questions (1 to 21). Each question carries
1 mark.
(iv) Section B consists of 7 questions (22 to 28). Each question carries
2 marks.
m
.co
(v) Section C consists of 4 questions (29 to 32). Each question carries
m
.co m
3 marks.
m s e
(vi) Section D consists of 2 questions (33 to 34). Each question carries 4
s e l a
g l a
marks.
(vii) Section E consists of 3 questions (35 to 37). Each question carries
ag
a 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.
(x) In case of MCQ, text of the correct answer should also be written.
o m
c
SECTION.– A
s em
1.
g la is True or False :
State whether the following statement 1
a index can be a string or an integer.
In Pandas Series, the Positional
2. We can add a new row to a DataFrame DF using the ______ method. 1
(A) DF.add() (B) DF.loc[]
(C) DF.loc() (D) DF.addloc[]
o m
c
3. mNaveen discarded various types of waste material without realizing
. that
c. o e-waste contains harmful substances that could pollute thesenvironment.
m
e m He wants to know which of the following will be consideredlaasee-waste ? 1
l as (A) Plastic Bottle ag
ag (B) Broken Smartphone
(C) Aluminium Foil
(D) Banana Peel
90* 3 * Page 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 32
m .co
m .co s e m
se g l a
General Instructions : a
(i) All questions are compulsory.
(ii) The examination paper contains 5 sections – Section A to Section E.
(iii) Section A consists of 21 questions (1 to 21). Each question carries
1 mark.
(iv) Section B consists of 7 questions (22 to 28). Each question carries
2 marks.
m
.co
(v) Section C consists of 4 questions (29 to 32). Each question carries
m
.co m
3 marks.
m s e
(vi) Section D consists of 2 questions (33 to 34). Each question carries 4
s e l a
g l a
marks.
(vii) Section E consists of 3 questions (35 to 37). Each question carries
ag
a 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.
(x) In case of MCQ, text of the correct answer should also be written.
o m
c
SECTION.– A
s em
1.
g la is True or False :
State whether the following statement 1
a index can be a string or an integer.
In Pandas Series, the Positional
2. We can add a new row to a DataFrame DF using the ______ method. 1
(A) DF.add() (B) DF.loc[]
(C) DF.loc() (D) DF.addloc[]
o m
c
3. mNaveen discarded various types of waste material without realizing
. that
c. o e-waste contains harmful substances that could pollute thesenvironment.
m
e m He wants to know which of the following will be consideredlaasee-waste ? 1
l as (A) Plastic Bottle ag
ag (B) Broken Smartphone
(C) Aluminium Foil
(D) Banana Peel
90* 3 * Page 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 32
Page 5
4. (scenario) (line chart) (bar chart)
? 1
(A)
(B)
(C) -
(D)
5. (network topology) (devices)
(backbone) ? 1
(A) (Mesh) (B) (Star)
(C) (Tree) (D) (Bus)
6. , 1
SQL , (aggregate function) , apply
, (values return)
7. ( )
(unique filtration method)
(Intellectual Property Right)
? 1
(A) (Trademark)
(B) (Copyright)
(C) (Patent)
(D) (Both Copyright & Trademark)
8. df DataFrame 1
print(df.loc['S2'])
?
(A) 'S2' (row)
(B) DataFrame
(C) 'S2' data type
(D) DataFrame
90* 4 * Page
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 4 of 32
? 1
(A)
(B)
(C) -
(D)
5. (network topology) (devices)
(backbone) ? 1
(A) (Mesh) (B) (Star)
(C) (Tree) (D) (Bus)
6. , 1
SQL , (aggregate function) , apply
, (values return)
7. ( )
(unique filtration method)
(Intellectual Property Right)
? 1
(A) (Trademark)
(B) (Copyright)
(C) (Patent)
(D) (Both Copyright & Trademark)
8. df DataFrame 1
print(df.loc['S2'])
?
(A) 'S2' (row)
(B) DataFrame
(C) 'S2' data type
(D) DataFrame
90* 4 * Page
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 4 of 32
Page 6
m
m .co
m .co s em
se g la
4. In which scenario is a bar chart preferred over aaline 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.
m
5. Which of the following network topology uses a central cable (backbone) to
m .co
m .co
connect all devices ? 1
s e m
(A) Mesh
s e l a
l
(B) Star
g a ag
(C)a Tree
(D) Bus
6. State whether the following statement is True or False :
In SQL, an aggregate function returns multiple values for each column on
which it is applied. 1
o m
7. Rohini has developed a new kind ofmwater
c
. purifier that uses a unique
filtration method. Which type of s e
apply to protect her invention g
? l a Intellectual Property Right should she
1
(A) Trademark
a
(B) Copyright
(C) Patent
(D) Both Copyright & Trademark
8. Aditya is working on a DataFrame named df. He has written the statement :
m 1
mprint(df.loc['S2']) c. o
c. o What will the above statement do ? s e m
e m l a
las (A) Display the data of the row having label 'S2'.
ag
ag (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.
90* 5 * Page 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 32
m .co
m .co s em
se g la
4. In which scenario is a bar chart preferred over aaline 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.
m
5. Which of the following network topology uses a central cable (backbone) to
m .co
m .co
connect all devices ? 1
s e m
(A) Mesh
s e l a
l
(B) Star
g a ag
(C)a Tree
(D) Bus
6. State whether the following statement is True or False :
In SQL, an aggregate function returns multiple values for each column on
which it is applied. 1
o m
7. Rohini has developed a new kind ofmwater
c
. purifier that uses a unique
filtration method. Which type of s e
apply to protect her invention g
? l a Intellectual Property Right should she
1
(A) Trademark
a
(B) Copyright
(C) Patent
(D) Both Copyright & Trademark
8. Aditya is working on a DataFrame named df. He has written the statement :
m 1
mprint(df.loc['S2']) c. o
c. o What will the above statement do ? s e m
e m l a
las (A) Display the data of the row having label 'S2'.
ag
ag (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.
90* 5 * Page 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 32
Page 7
9. SQL ? 1
SELECT LENGTH ('Data Base');
( : Data Base )
(A) 7 (B) 8
(C) 9 (D) Error ()
10. (static) ? 1
(A) (content) -
(B) - - (content)
(C) (dynamic) (load)
(D) (content) (code)
(manually)
11. DML ? 1
(A) Device Management Language
(B) Device Manipulation Language
(C) Data Management Language
(D) Data Manipulation Language
12. CSV __________ Separated Values 1
(A) Colon (B) CTRL
(C) Comma (D) Caret
13. (net etiquette) ? 1
(A)
(B)
(C) (owner)
(D)
90* 6 * Page
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 6 of 32
SELECT LENGTH ('Data Base');
( : Data Base )
(A) 7 (B) 8
(C) 9 (D) Error ()
10. (static) ? 1
(A) (content) -
(B) - - (content)
(C) (dynamic) (load)
(D) (content) (code)
(manually)
11. DML ? 1
(A) Device Management Language
(B) Device Manipulation Language
(C) Data Management Language
(D) Data Manipulation Language
12. CSV __________ Separated Values 1
(A) Colon (B) CTRL
(C) Comma (D) Caret
13. (net etiquette) ? 1
(A)
(B)
(C) (owner)
(D)
90* 6 * Page
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 6 of 32
Page 8
m
m .co
m .co s e m
se g l a
9. a ?
What will be the result of the following SQL command 1
SELECT LENGTH ('Data Base');
(Note : There is single space between the words Data and Base.)
(A) 7 (B) 8
(C) 9 (D) Error
m
o m
10. Which of the following is a key feature of a Static Web Page ?
c
1
m .co
m
(A) Its content. updates very frequently. s e
s e different content to different users. l a
(B) It a
g l displays
ag
(C)a It loads slower than a Dynamic Web Page.
(D) It shows the same content unless the code is manually updated.
11. Which of the following is the correct expanded form of DML ? 1
(A) Device Management Language
(B) Device Manipulation Language
m
(C) Data Management Language
m .co
(D) Data Manipulation Language s e
g la
a
12. CSV stands for __________ Separated Values. 1
(A) Colon
(B) CTRL
(C) Comma
(D) Caret
m
m
c.13.o Which of the following is an example of maintaining good netseetiquette
m ? .co
1
s em (A) Spamming emails or messages to strangers. gla
la a
ag (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.
90* 7 * Page 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 32
m .co
m .co s e m
se g l a
9. a ?
What will be the result of the following SQL command 1
SELECT LENGTH ('Data Base');
(Note : There is single space between the words Data and Base.)
(A) 7 (B) 8
(C) 9 (D) Error
m
o m
10. Which of the following is a key feature of a Static Web Page ?
c
1
m .co
m
(A) Its content. updates very frequently. s e
s e different content to different users. l a
(B) It a
g l displays
ag
(C)a It loads slower than a Dynamic Web Page.
(D) It shows the same content unless the code is manually updated.
11. Which of the following is the correct expanded form of DML ? 1
(A) Device Management Language
(B) Device Manipulation Language
m
(C) Data Management Language
m .co
(D) Data Manipulation Language s e
g la
a
12. CSV stands for __________ Separated Values. 1
(A) Colon
(B) CTRL
(C) Comma
(D) Caret
m
m
c.13.o Which of the following is an example of maintaining good netseetiquette
m ? .co
1
s em (A) Spamming emails or messages to strangers. gla
la a
ag (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.
90* 7 * Page 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 32
Page 9
14. (dictionary) Pandas Series ,
? 1
(A) (dictionary) (values) Series
(B) (dictionary) (keys) Series (values)
(C) (dictionary) (keys) Series
(D) (dictionary) (keys) , Series 0
(default integer)
15. Pandas , start end ser1[start :
end] Series ser1 (extract ) ,
? 1
(A) (end index)
(B) (end index)
(C) (start and end indices)
(D) (start index)
16. , , (voice call)
? 1
(A) (Chat)
(B) (VoIP)
(C) (Email)
(D) (TV)
17. : 1
string2, string1 (substring) SQL ,
INSTR (string1, string2) 0 (return)
90* 8 * Page
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 8 of 32
? 1
(A) (dictionary) (values) Series
(B) (dictionary) (keys) Series (values)
(C) (dictionary) (keys) Series
(D) (dictionary) (keys) , Series 0
(default integer)
15. Pandas , start end ser1[start :
end] Series ser1 (extract ) ,
? 1
(A) (end index)
(B) (end index)
(C) (start and end indices)
(D) (start index)
16. , , (voice call)
? 1
(A) (Chat)
(B) (VoIP)
(C) (Email)
(D) (TV)
17. : 1
string2, string1 (substring) SQL ,
INSTR (string1, string2) 0 (return)
90* 8 * Page
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 8 of 32
Page 10
m
m .co
m .co s em
se g la
14. In the context of creating a Pandas Series from a
a dictionary, which of the
following statement is correct ? 1
(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.
m
.co
(D) The Series will have default integer indices starting from 0, ignoring
m
.co
the dictionary keys.
e m
em l as
as g
l when extracting a portion of a Series ser1 usinga
ag
15. In Pandas,
ser1[start:end] with positional indices start and end, which of the
following statements is true ? 1
(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
m
the output.
m .co
e
(D) The element at the start index is excluded from the output.
s
g la
a
16. Nisha is using an Android app to make a voice call over the internet to
her friend in another country. Which protocol is being used in this case ? 1
(A) Chat
(B) VoIP
(C) Email
m
m (D) TV .co
.co s e m
s em g l a
g la 17. State whether the following statement is True or Falsea: 1
a The INSTR(stringl, string2) function in SQL returns 0 if string2
is not present as a substring in string1.
90* 9 * Page 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 32
m .co
m .co s em
se g la
14. In the context of creating a Pandas Series from a
a dictionary, which of the
following statement is correct ? 1
(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.
m
.co
(D) The Series will have default integer indices starting from 0, ignoring
m
.co
the dictionary keys.
e m
em l as
as g
l when extracting a portion of a Series ser1 usinga
ag
15. In Pandas,
ser1[start:end] with positional indices start and end, which of the
following statements is true ? 1
(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
m
the output.
m .co
e
(D) The element at the start index is excluded from the output.
s
g la
a
16. Nisha is using an Android app to make a voice call over the internet to
her friend in another country. Which protocol is being used in this case ? 1
(A) Chat
(B) VoIP
(C) Email
m
m (D) TV .co
.co s e m
s em g l a
g la 17. State whether the following statement is True or Falsea: 1
a The INSTR(stringl, string2) function in SQL returns 0 if string2
is not present as a substring in string1.
90* 9 * Page 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 32
Page 11
18. Pandas DataFrame , (column) (delete )
axis (value) ? 1
(A) axis = -1 (B) axis = 0
(C) axis = 1 (D) axis = 2
19. SQL ? 1
SELECT ROUND (15.678, 2);
(A) 15.00 (B) 15.67
(C) 15.68 (D) 16.00
-20 -21 (Assertion) (A) (Reason) (R)
:
(A) (A) (R) (R), (A)
(B) (A) (R) , (R), (A)
(C) (A) , (R)
(D) (A) , (R)
20. (A) : Pandas DataFrame (columns) (data
type) (values) 1
(R) : DataFrames 2D arrays (implement) ,
(allow )
21. (A) : name NULL (values) , SQL SELECT
COUNT(name) FROM students; SELECT COUNT(*)FROM
students; 1
(R) : COUNT(column_name) column NON NULL (values)
(count) (return) , COUNT(*) (table)
(records) (return)
90* 10 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 10 of 32
axis (value) ? 1
(A) axis = -1 (B) axis = 0
(C) axis = 1 (D) axis = 2
19. SQL ? 1
SELECT ROUND (15.678, 2);
(A) 15.00 (B) 15.67
(C) 15.68 (D) 16.00
-20 -21 (Assertion) (A) (Reason) (R)
:
(A) (A) (R) (R), (A)
(B) (A) (R) , (R), (A)
(C) (A) , (R)
(D) (A) , (R)
20. (A) : Pandas DataFrame (columns) (data
type) (values) 1
(R) : DataFrames 2D arrays (implement) ,
(allow )
21. (A) : name NULL (values) , SQL SELECT
COUNT(name) FROM students; SELECT COUNT(*)FROM
students; 1
(R) : COUNT(column_name) column NON NULL (values)
(count) (return) , COUNT(*) (table)
(records) (return)
90* 10 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 10 of 32
Page 12
m
m .co
m .co s em
se g la
18. In a Pandas DataFrame, which value for axisa will be used to delete a
column ? 1
(A) axis = -1
(B) axis = 0
(C) axis = 1
(D) axis = 2
m
m .co
.co
19. What will be the result of the following SQL command ? 1
s e m
em
SELECT ROUND(15.678, 2);
s l a
la
(A) 15.00
g ag
(B)a 15.67
(C) 15.68
(D) 16.00
Q. 20 and Q. 21 are Assertion (A) and Reason (R) Type questions. Choose
the correct option as :
o m
(A) Both (A) and (R) are True, and (R) correctly explains (A).
. c
(B) Both (A) and (R) are True, but (R)
e mdoes not correctly explain (A).
(C) (A) is True, but (R) is False.as
l
ag
(D) (A) is False, but (R) is True.
20. Assertion (A) : Pandas DataFrame can store values of multiple data
types in multiple Columns. 1
Reason (R) : DataFrames are implemented using 2D arrays, which
allows only numeric values.
m
m
21. Assertion (A) : The output of the SQL query SELECT COUNT (name) .co
m .co em
FROM students; will differ from the output of SELECT COUNT (*)
s
s e g la
FROM students; if there are some NULL values in the name column. 1
g la Reason (R) : COUNT(column_name) returns the a
count of NON NULL
a values in that column, whereas COUNT(*) returns the number of records
in the table.
90* 11 * P a g e 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 32
m .co
m .co s em
se g la
18. In a Pandas DataFrame, which value for axisa will be used to delete a
column ? 1
(A) axis = -1
(B) axis = 0
(C) axis = 1
(D) axis = 2
m
m .co
.co
19. What will be the result of the following SQL command ? 1
s e m
em
SELECT ROUND(15.678, 2);
s l a
la
(A) 15.00
g ag
(B)a 15.67
(C) 15.68
(D) 16.00
Q. 20 and Q. 21 are Assertion (A) and Reason (R) Type questions. Choose
the correct option as :
o m
(A) Both (A) and (R) are True, and (R) correctly explains (A).
. c
(B) Both (A) and (R) are True, but (R)
e mdoes not correctly explain (A).
(C) (A) is True, but (R) is False.as
l
ag
(D) (A) is False, but (R) is True.
20. Assertion (A) : Pandas DataFrame can store values of multiple data
types in multiple Columns. 1
Reason (R) : DataFrames are implemented using 2D arrays, which
allows only numeric values.
m
m
21. Assertion (A) : The output of the SQL query SELECT COUNT (name) .co
m .co em
FROM students; will differ from the output of SELECT COUNT (*)
s
s e g la
FROM students; if there are some NULL values in the name column. 1
g la Reason (R) : COUNT(column_name) returns the a
count of NON NULL
a values in that column, whereas COUNT(*) returns the number of records
in the table.
90* 11 * P a g e 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 32
Page 13
–
22. (a) (Python) Pandas (characteristics)
2
(b) DataFrame (Boolean Indexing)
23. (free design elements)
(public
access) (publish)
(source) 2
(i) (IPR)
(ii) (licensing models)
(digital creative work) (legal reuse)
24. (RDBMS) : 2
a. (Domain)
b. (Tuple)
25. (a) : 2
(I) (Modem)
(II) (Gateway)
(b) - (add-ons) - (plug-ins)
26. SQL (SQL queries) : 2
(I) '2026-01-01' ( )
(II) '2026-01-01' (year part)
90* 12 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 12 of 32
22. (a) (Python) Pandas (characteristics)
2
(b) DataFrame (Boolean Indexing)
23. (free design elements)
(public
access) (publish)
(source) 2
(i) (IPR)
(ii) (licensing models)
(digital creative work) (legal reuse)
24. (RDBMS) : 2
a. (Domain)
b. (Tuple)
25. (a) : 2
(I) (Modem)
(II) (Gateway)
(b) - (add-ons) - (plug-ins)
26. SQL (SQL queries) : 2
(I) '2026-01-01' ( )
(II) '2026-01-01' (year part)
90* 12 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 12 of 32
Page 14
m
m .co
m .co s e m
se g l a
SECTION – B a
22. (a) List any two characteristics of Pandas library in Python. 2
OR
(b) Briefly explain the purpose of Boolean Indexing with respect to
DataFrames. Support your answer with a suitable example.
m
m .co
.co
23. Anjana had created a website using free design elements sourced from e m
em online. She then published the site for public access but glas
different screators
g
did notlamention the source of the design elements used. a 2
a
(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.
24. Define the following terms with respect to RDBMS : 2
a. Domain . c om
e m
b. Tuple
las
ag
25. (a) Explain the role of the following network devices in a network : 2
(I) Modem
(II) Gateway
OR
m
m (b) Differentiate between add-ons and plug-ins in a web browser.
.co
m .co s e m
s e g l a
g la 26. Write SQL queries to perform the following :
a 2
a (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'.
90* 13 * P a g e 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 32
m .co
m .co s e m
se g l a
SECTION – B a
22. (a) List any two characteristics of Pandas library in Python. 2
OR
(b) Briefly explain the purpose of Boolean Indexing with respect to
DataFrames. Support your answer with a suitable example.
m
m .co
.co
23. Anjana had created a website using free design elements sourced from e m
em online. She then published the site for public access but glas
different screators
g
did notlamention the source of the design elements used. a 2
a
(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.
24. Define the following terms with respect to RDBMS : 2
a. Domain . c om
e m
b. Tuple
las
ag
25. (a) Explain the role of the following network devices in a network : 2
(I) Modem
(II) Gateway
OR
m
m (b) Differentiate between add-ons and plug-ins in a web browser.
.co
m .co s e m
s e g l a
g la 26. Write SQL queries to perform the following :
a 2
a (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'.
90* 13 * P a g e 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 32
Page 15
27. (a) (data protection) ? 2
(b) (cyber crime) /
28. (a) 'a', 'b', 'c' NumPy array
Pandas Series , 'first', 'second'
'third' (assign)
2
import pandas as pd
import ______ as np
arr = np._____ (['a' , 'b' , 'c'])
s = pd._____(arr,_____=['first','second','third'])
print(s)
(b) :
import pandas as pd
s1 = pd.Series ([1, 2, 3], index = ['a','b','c'])
s2 = pd.Series ([4, 5, 6], index = ['b' , 'c', 'd'])
print (s1 + S2)
–
29. ,
(process)
3
(case study) :
(i) (cyber crime) ?
(ii) ,
?
(iii)
90* 14 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 14 of 32
(b) (cyber crime) /
28. (a) 'a', 'b', 'c' NumPy array
Pandas Series , 'first', 'second'
'third' (assign)
2
import pandas as pd
import ______ as np
arr = np._____ (['a' , 'b' , 'c'])
s = pd._____(arr,_____=['first','second','third'])
print(s)
(b) :
import pandas as pd
s1 = pd.Series ([1, 2, 3], index = ['a','b','c'])
s2 = pd.Series ([4, 5, 6], index = ['b' , 'c', 'd'])
print (s1 + S2)
–
29. ,
(process)
3
(case study) :
(i) (cyber crime) ?
(ii) ,
?
(iii)
90* 14 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 14 of 32
Page 16
m
m .co
m .co s e m
se g l a
27. (a) What is data protection ? a 2
(b) Mention any two precautionary measures one can take to avoid the
risk of cybercrime.
28. (a) Niharika wants to create a Pandas Series using a NumPy array
with three elements 'a','b', and 'c', and assign custom indexes
m
'first','second' and 'third'. Help her complete the code
m .co
below.
.co 2
s e m
em
import pandas as pd
s l a
g la ______ as np
import ag
a arr = np._____ (['a' , 'b' , 'c'])
s = pd._____(arr,_____=['first','second','third'])
print(s)
OR
(b) Write the output of the following code :
import pandas as pd
o m
c
. = ['a','b','c'])
m
s1 = pd.Series ([1, 2, 3], index
e index = ['b','c','d'])
s2 = pd.Series ([4, 5,a6],
l s
print(s1 + S2) ag
SECTION – C
29. Mandeep received an email stating he won a lottery though he had never
participated 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. o m 3
m c
c. o Answer the following questions based on the given case studyse:m.
s em (i) Mandeep is the victim of which type of cybercrime g? la
g la (ii) Other than email, mention any two common methods a through which
a this type of cybercrime is being committed these days.
(iii) Name one law that safeguards the rights of Internet users in India.
90* 15 * P a g e 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 15 of 32
m .co
m .co s e m
se g l a
27. (a) What is data protection ? a 2
(b) Mention any two precautionary measures one can take to avoid the
risk of cybercrime.
28. (a) Niharika wants to create a Pandas Series using a NumPy array
with three elements 'a','b', and 'c', and assign custom indexes
m
'first','second' and 'third'. Help her complete the code
m .co
below.
.co 2
s e m
em
import pandas as pd
s l a
g la ______ as np
import ag
a arr = np._____ (['a' , 'b' , 'c'])
s = pd._____(arr,_____=['first','second','third'])
print(s)
OR
(b) Write the output of the following code :
import pandas as pd
o m
c
. = ['a','b','c'])
m
s1 = pd.Series ([1, 2, 3], index
e index = ['b','c','d'])
s2 = pd.Series ([4, 5,a6],
l s
print(s1 + S2) ag
SECTION – C
29. Mandeep received an email stating he won a lottery though he had never
participated 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. o m 3
m c
c. o Answer the following questions based on the given case studyse:m.
s em (i) Mandeep is the victim of which type of cybercrime g? la
g la (ii) Other than email, mention any two common methods a through which
a this type of cybercrime is being committed these days.
(iii) Name one law that safeguards the rights of Internet users in India.
90* 15 * P a g e 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 15 of 32
Page 17
30. (a) Pandas Series
(Python program) : 3
July 31
Aug 31
Sept 30
Oct 31
(Index labels) - July, Aug, Sept, Oct
(scalar values) - 31, 31, 30, 31
(b) customer.csv CSV
(header) sample :
Name, Age, City
Rudra,17,Kolkata
Divya,19,Dehradun
Nabeel,22,Lucknow
CSV DF Pandas DataFrame (import)
(rows) (Python
Program)
31. (i) , PRODUCTS (table)
SQL (statement) : 3
Column Name Data Type Key
PID Integer Primary Key
PName Varchar of size 30
PCat Char of size 15
Price Decimal Number
(ii) PRODUCTS , 100 SQL
(query) , (product category) Grocery
90* 16 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 16 of 32
(Python program) : 3
July 31
Aug 31
Sept 30
Oct 31
(Index labels) - July, Aug, Sept, Oct
(scalar values) - 31, 31, 30, 31
(b) customer.csv CSV
(header) sample :
Name, Age, City
Rudra,17,Kolkata
Divya,19,Dehradun
Nabeel,22,Lucknow
CSV DF Pandas DataFrame (import)
(rows) (Python
Program)
31. (i) , PRODUCTS (table)
SQL (statement) : 3
Column Name Data Type Key
PID Integer Primary Key
PName Varchar of size 30
PCat Char of size 15
Price Decimal Number
(ii) PRODUCTS , 100 SQL
(query) , (product category) Grocery
90* 16 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 16 of 32
Page 18
m
m .co
m .co s em
se g la
a a Pandas Series as
30. (a) Write a Python program to create and display
shown below : 3
July 31
Aug 31
Sept 30
Oct 31
m
The index labels are the names of the months – July, Aug, Sept,
m .co
Oct.
.co s e m
s em
The corresponding scalar values are the number of days in these la
g
l a
respective months – 31, 31, 30, 31. a
ag OR
(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
m
Divya,19,Dehradun
.co
Nabeel,22,Lucknow
s em
a
Write a Python programglto import data from the CSV file into a
a DF and display the last two rows.
Pandas DataFrame named
31. (i) Write an SQL statement to create a table named PRODUCTS with the
following specifications : 3
Column Name Data Type Key
m
m PID Integer Primary Key
.co
m .co PName Varchar of size 30
s e m
s e PCat Char of size 15
g l a
g la Price Decimal Number a
a (ii) Write an SQL query to increase the price of all items by 100, whose
product category is Grocery, in the table PRODUCTS.
90* 17 * P a g e 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 17 of 32
m .co
m .co s em
se g la
a a Pandas Series as
30. (a) Write a Python program to create and display
shown below : 3
July 31
Aug 31
Sept 30
Oct 31
m
The index labels are the names of the months – July, Aug, Sept,
m .co
Oct.
.co s e m
s em
The corresponding scalar values are the number of days in these la
g
l a
respective months – 31, 31, 30, 31. a
ag OR
(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
m
Divya,19,Dehradun
.co
Nabeel,22,Lucknow
s em
a
Write a Python programglto import data from the CSV file into a
a DF and display the last two rows.
Pandas DataFrame named
31. (i) Write an SQL statement to create a table named PRODUCTS with the
following specifications : 3
Column Name Data Type Key
m
m PID Integer Primary Key
.co
m .co PName Varchar of size 30
s e m
s e PCat Char of size 15
g l a
g la Price Decimal Number a
a (ii) Write an SQL query to increase the price of all items by 100, whose
product category is Grocery, in the table PRODUCTS.
90* 17 * P a g e 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 17 of 32
Page 19
32. (a) : 3
Table 1:TEACHER, (TID), (TName),
(Experience), (City) store
TID TName Experience City
1 Kartik 5 Bhopal
2 Shahnaz 6 Nagpur
3 Rajendra 7 Delhi
4 Tanvi 4 Bhopal
5 Alam 9 Delhi
Table 2:SUBJECT, (SID), (SubName)
(TID) store
SID SubName TID
101 Physics 1
102 Chemistry 2
103 Mathematics 3
104 Informatics Practices 4
105 Computer Science 5
SQL (query) :
(I) (delete) TID 4
(II) 5
Nagpur
(III)
90* 18 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 18 of 32
Table 1:TEACHER, (TID), (TName),
(Experience), (City) store
TID TName Experience City
1 Kartik 5 Bhopal
2 Shahnaz 6 Nagpur
3 Rajendra 7 Delhi
4 Tanvi 4 Bhopal
5 Alam 9 Delhi
Table 2:SUBJECT, (SID), (SubName)
(TID) store
SID SubName TID
101 Physics 1
102 Chemistry 2
103 Mathematics 3
104 Informatics Practices 4
105 Computer Science 5
SQL (query) :
(I) (delete) TID 4
(II) 5
Nagpur
(III)
90* 18 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 18 of 32
Page 20
m
m .co
m .co s e m
se g l a
32. (a) Consider the following tables : a 3
Table 1 : TEACHER, which stores Teacher ID (TID), Teacher Name
(TName), Experience(Experience) and City (City) that they
live in.
TID TName Experience City
m
1 m Kartik
c. oShahnaz
5 Bhopal
m .co
m s e
2
s e 6 Nagpur
l a
g l3a Rajendra 7 Delhi ag
a 4 Tanvi 4 Bhopal
5 Alam 9 Delhi
Table 2 : SUBJECT, which stores Subject ID (SID), Subject Name
(SubName) and ID of the teacher(TID) teaching that Subject.
m
SID SubName
m .co TID
s e
101 Physics
g la 1
102 Chemistrya 2
103 Mathematics 3
104 Informatics Practices 4
105 Computer Science 5
Write appropriate SQL query for the following :
m
m (I) Delete the record of the subject whose TID is equal to 4.
.co
m .co (II) Display the names of teachers who have more than 5 years of s e m
s e g l a
g la experience and who stay in Nagpur.
a
a (III) Display subject names along with their teacher names.
OR
90* 19 * P a g e 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 19 of 32
m .co
m .co s e m
se g l a
32. (a) Consider the following tables : a 3
Table 1 : TEACHER, which stores Teacher ID (TID), Teacher Name
(TName), Experience(Experience) and City (City) that they
live in.
TID TName Experience City
m
1 m Kartik
c. oShahnaz
5 Bhopal
m .co
m s e
2
s e 6 Nagpur
l a
g l3a Rajendra 7 Delhi ag
a 4 Tanvi 4 Bhopal
5 Alam 9 Delhi
Table 2 : SUBJECT, which stores Subject ID (SID), Subject Name
(SubName) and ID of the teacher(TID) teaching that Subject.
m
SID SubName
m .co TID
s e
101 Physics
g la 1
102 Chemistrya 2
103 Mathematics 3
104 Informatics Practices 4
105 Computer Science 5
Write appropriate SQL query for the following :
m
m (I) Delete the record of the subject whose TID is equal to 4.
.co
m .co (II) Display the names of teachers who have more than 5 years of s e m
s e g l a
g la experience and who stay in Nagpur.
a
a (III) Display subject names along with their teacher names.
OR
90* 19 * P a g e 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 19 of 32
Page 21
(b) LIBRARY
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) / Attribute(s) (Candidate key) ?
(II) (insert) SQL
(query) :
BookId : 501
Title : AI for ALL
Genre : Technology
Price : 589
(III) Author Character data type
(size) 20 , SQL
–
33. , (data analyst), (workshop)
(age distribution)
(histogram) (list)
: 4
Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23]
(Python Program) ,
(missing parts) ,
(display)
90* 20 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 20 of 32
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) / Attribute(s) (Candidate key) ?
(II) (insert) SQL
(query) :
BookId : 501
Title : AI for ALL
Genre : Technology
Price : 589
(III) Author Character data type
(size) 20 , SQL
–
33. , (data analyst), (workshop)
(age distribution)
(histogram) (list)
: 4
Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23]
(Python Program) ,
(missing parts) ,
(display)
90* 20 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 20 of 32
Page 22
m
m .co
m .co s e m
se g l a
(b) Consider the table LIBRARY as given below.a
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) ?
m
m
Justify your answer.
.co
.co
(II) Write an SQL query to insert a new record with the following
m s e m
s e
values :
l a
g l a BookId : 501 ag
a Title : AI for ALL
Genre : Technology
Price : 589
(III) Write an SQL query to add a new column Author that is a
character data type of size 20.
SECTION – D
m
.co
33. Ms. Anjali, a data analyst, has been assigned the task of creating a
m
e
histogram to display the age distribution of ten participants in a
s
g la
workshop. She has been provided with the following list of their ages : 4
a
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
m .co s e m
s e g l a
g la a
a
90* 21 * P a g e 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 21 of 32
m .co
m .co s e m
se g l a
(b) Consider the table LIBRARY as given below.a
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) ?
m
m
Justify your answer.
.co
.co
(II) Write an SQL query to insert a new record with the following
m s e m
s e
values :
l a
g l a BookId : 501 ag
a Title : AI for ALL
Genre : Technology
Price : 589
(III) Write an SQL query to add a new column Author that is a
character data type of size 20.
SECTION – D
m
.co
33. Ms. Anjali, a data analyst, has been assigned the task of creating a
m
e
histogram to display the age distribution of ten participants in a
s
g la
workshop. She has been provided with the following list of their ages : 4
a
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
m .co s e m
s e g l a
g la a
a
90* 21 * P a g e 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 21 of 32
Page 23
import matplotlib.pyplot as plt
Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23]
binsize=[20,22,24,26,28,30]
plt.________(Ages, bins=binsize, edgecolor = 'black',
label = 'Participants') # Statement-1
______.xlabel('Age') # Statement-2
plt.ylabel('Number of Participants')
plt.title("Age Distribution")
plt._______ # Statement-3
_________ # Statement-4
I. Statement-1
II. x (x axis) (label) (module)
(alias) Statement-2
III. (legend) (Python Code)
Statement-3
IV. (Python Code) Statement-4
34. (a) , (database designer)
, (guests) Guest
(table) , 4
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
SQL :
I. 3 (characters) (upper case)
II. Check-in
III. Charges 1000 (remainder)
IV. (characters) ,
(character) , (extract)
90* 22 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 22 of 32
Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23]
binsize=[20,22,24,26,28,30]
plt.________(Ages, bins=binsize, edgecolor = 'black',
label = 'Participants') # Statement-1
______.xlabel('Age') # Statement-2
plt.ylabel('Number of Participants')
plt.title("Age Distribution")
plt._______ # Statement-3
_________ # Statement-4
I. Statement-1
II. x (x axis) (label) (module)
(alias) Statement-2
III. (legend) (Python Code)
Statement-3
IV. (Python Code) Statement-4
34. (a) , (database designer)
, (guests) Guest
(table) , 4
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
SQL :
I. 3 (characters) (upper case)
II. Check-in
III. Charges 1000 (remainder)
IV. (characters) ,
(character) , (extract)
90* 22 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 22 of 32
Page 24
m
m .co
m .co s e m
se g l a
import matplotlib.pyplot as plt a
Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23]
binsize=[20,22,24,26,28,30]
plt._______(Ages, bins=binsize, edgecolor = 'black',
label = 'Participants') # Statement-1
______.xlabel('Age') # Statement-2
plt.ylabel('Number of Participants')
m
.co
plt.title("Age Distribution")
m
.co
plt._______ # Statement-3
e m
_________
em
# Statement-4
s
s the suitable code for the blank space in the line marked as la
I. Write
l a ag
gStatement-1 which plots the histogram.
II. a Fill in the blank in Statement-2 to use the correct alias of the
required module to set the label on x axis.
III. Fill in the blank in Statement-3 with the correct Python code to
display the legend on the graph.
IV. Fill in the blank in Statetment-4 with the appropriate Python code
to display the graph.
m
34. (a)
.co
Shalini, who works as a database designer in the hotel industry, has
m
created a table named Guest to keep track of guest details as shown
s e
below :
Table : Guest g la 4
a
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 :
m
.co
I. Display last 3 characters of guest name in upper case.
m
m .co check-in date. s em
II. Display the name of the guest along with the day name of
s e g la
g la III. Display the remainder when charges are divided by 1000.
a
a IV. Extract and display three characters, starting from the second
character, of each guest name.
OR
90* 23 * P a g e 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 23 of 32
m .co
m .co s e m
se g l a
import matplotlib.pyplot as plt a
Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23]
binsize=[20,22,24,26,28,30]
plt._______(Ages, bins=binsize, edgecolor = 'black',
label = 'Participants') # Statement-1
______.xlabel('Age') # Statement-2
plt.ylabel('Number of Participants')
m
.co
plt.title("Age Distribution")
m
.co
plt._______ # Statement-3
e m
_________
em
# Statement-4
s
s the suitable code for the blank space in the line marked as la
I. Write
l a ag
gStatement-1 which plots the histogram.
II. a Fill in the blank in Statement-2 to use the correct alias of the
required module to set the label on x axis.
III. Fill in the blank in Statement-3 with the correct Python code to
display the legend on the graph.
IV. Fill in the blank in Statetment-4 with the appropriate Python code
to display the graph.
m
34. (a)
.co
Shalini, who works as a database designer in the hotel industry, has
m
created a table named Guest to keep track of guest details as shown
s e
below :
Table : Guest g la 4
a
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 :
m
.co
I. Display last 3 characters of guest name in upper case.
m
m .co check-in date. s em
II. Display the name of the guest along with the day name of
s e g la
g la III. Display the remainder when charges are divided by 1000.
a
a IV. Extract and display three characters, starting from the second
character, of each guest name.
OR
90* 23 * P a g e 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 23 of 32
Page 25
(b) (table) SQL
:
Table : ORDERS
ORDERID CUSTOMERNAME TOTALAMOUNT DISCOUNT ORDERDATE
101 Hemant 5000 10 2024–03-01
102 Neha 7000 15 NULL
103 Keshav 3000 5 2024–01-20
104 Sandhya 4500 NULL 2023-12-25
SQL :
I. SELECT CUSTOMERNAME FROM ORDERS WHERE DISCOUNT IS
NOT NULL;
II. SELECT CUSTOMERNAME, DISCOUNT FROM ORDERS WHERE
DISCOUNT BETWEEN 5 AND 10;
III. SELECT MONTHNAME(ORDERDATE) FROM ORDERS WHERE
ORDERDATE IS NOT NULL;
IV. SELECT ORDERID, DAY(ORDERDATE) FROM ORDERS;
–
35. My Solutions Pvt. Ltd. (software development)
(IT consulting firm) (head office)
Mysuru Chennai (regional office)
Mysuru : (Human Resources),
(Research), (Design) (Technical Support) 5
90* 24 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 24 of 32
:
Table : ORDERS
ORDERID CUSTOMERNAME TOTALAMOUNT DISCOUNT ORDERDATE
101 Hemant 5000 10 2024–03-01
102 Neha 7000 15 NULL
103 Keshav 3000 5 2024–01-20
104 Sandhya 4500 NULL 2023-12-25
SQL :
I. SELECT CUSTOMERNAME FROM ORDERS WHERE DISCOUNT IS
NOT NULL;
II. SELECT CUSTOMERNAME, DISCOUNT FROM ORDERS WHERE
DISCOUNT BETWEEN 5 AND 10;
III. SELECT MONTHNAME(ORDERDATE) FROM ORDERS WHERE
ORDERDATE IS NOT NULL;
IV. SELECT ORDERID, DAY(ORDERDATE) FROM ORDERS;
–
35. My Solutions Pvt. Ltd. (software development)
(IT consulting firm) (head office)
Mysuru Chennai (regional office)
Mysuru : (Human Resources),
(Research), (Design) (Technical Support) 5
90* 24 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 24 of 32
Page 26
m
m .co
m .co s em
se g la
a output of the following
(b) Consider the following table and write the
SQL Queries.
Table : ORDERS
ORDERID CUSTOMERNAME TOTALAMOUNT DISCOUNT ORDERDATE
101 Hemant 5000 10 2024–03-01
102 Neha 7000 15 NULL
m
.co
103 Keshav 3000 5 2024–01-20
104 om
c.Sandhya 4500
e m NULL 2023-12-25
m output of the following SQL Queries :
Writeethe
l as
s
I.a SELECT CUSTOMERNAME FROM ORDERS WHERE DISCOUNT ISag
l NOT NULL;
ag
II. SELECT CUSTOMERNAME, DISCOUNT FROM ORDERS WHERE
DISCOUNT BETWEEN 5 AND 10;
III. SELECT MONTHNAME(ORDERDATE) FROM ORDERS WHERE
ORDERDATE IS NOT NULL;
IV. SELECT ORDERID, DAY(ORDERDATE) FROM ORDERS;
m
SECTION – E .co
s em
35. My Solutions Pvt. Ltd. is ala
ag reputed software development and IT
consulting firm. The 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. 5
m
m .co
m .co s e m
s e g l a
g la a
a
90* 25 * P a g e 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 25 of 32
m .co
m .co s em
se g la
a output of the following
(b) Consider the following table and write the
SQL Queries.
Table : ORDERS
ORDERID CUSTOMERNAME TOTALAMOUNT DISCOUNT ORDERDATE
101 Hemant 5000 10 2024–03-01
102 Neha 7000 15 NULL
m
.co
103 Keshav 3000 5 2024–01-20
104 om
c.Sandhya 4500
e m NULL 2023-12-25
m output of the following SQL Queries :
Writeethe
l as
s
I.a SELECT CUSTOMERNAME FROM ORDERS WHERE DISCOUNT ISag
l NOT NULL;
ag
II. SELECT CUSTOMERNAME, DISCOUNT FROM ORDERS WHERE
DISCOUNT BETWEEN 5 AND 10;
III. SELECT MONTHNAME(ORDERDATE) FROM ORDERS WHERE
ORDERDATE IS NOT NULL;
IV. SELECT ORDERID, DAY(ORDERDATE) FROM ORDERS;
m
SECTION – E .co
s em
35. My Solutions Pvt. Ltd. is ala
ag reputed software development and IT
consulting firm. The 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. 5
m
m .co
m .co s e m
s e g l a
g la a
a
90* 25 * P a g e 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 25 of 32
Page 27
Mysuru Chennai :
Human Resources Research 55 metres
Human Resources Design 75 metres
Human Resources Technical Support 140 metres
Research Design 40 metres
Research Technical Support 80 metres
Design Technical Support 60 metres
Mysuru Office Chennai Office 350 kilometres
/ (computer) :
Human Resources 30
Research 80
Design 50
Technical Support 20
Chennai Office 35
(network engineer) , I V
I. Mysuru (main server) (install)
II. Mysuru (wired network
connectivity) (establish) (cable
layout design)
III. Research department
(network device)
IV. Mysuru Chennai (LAN,
MAN, WAN) ?
V. Human Resources Technical Support
(transmit) (signal strength)
, ?
90* 26 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 26 of 32
Human Resources Research 55 metres
Human Resources Design 75 metres
Human Resources Technical Support 140 metres
Research Design 40 metres
Research Technical Support 80 metres
Design Technical Support 60 metres
Mysuru Office Chennai Office 350 kilometres
/ (computer) :
Human Resources 30
Research 80
Design 50
Technical Support 20
Chennai Office 35
(network engineer) , I V
I. Mysuru (main server) (install)
II. Mysuru (wired network
connectivity) (establish) (cable
layout design)
III. Research department
(network device)
IV. Mysuru Chennai (LAN,
MAN, WAN) ?
V. Human Resources Technical Support
(transmit) (signal strength)
, ?
90* 26 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 26 of 32
Page 28
m
m .co
m .co s em
se g la
a between Mysuru and
The distances between these departments 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
m
c o m
Research to Technical Support 80 metres
m .co
Design to .Technical Support s e
e m 60 metres
l a
Mysuru
l as Office to Chennai Office 350 kilometres g
a
ag
The number of computers in each department/office is as follows :
Human Resources 30
Research 80
Design 50
Technical Support
o m 20
Chennai Office 35 . c
As a network engineer, you haveas
em
to propose solutions for various queries
l
listed from I to V. ag
I. Identify the most suitable department to install the main server in
the Mysuru office. Justify your answer with a valid reason.
II. Create a cable layout design to establish Wired network connectivity
between the departments in the Mysuru Office.
III. Suggest the appropriate network device to connect multiple
m
.co
computers within the Research department.
m
c. o IV. What type of network (LAN, MAN, WAN) would bestsem connect the
s em Mysuru and Chennai office ?
g l a
la a weakens while
ag
V. Which device should be used if the signal strength
transmitting data between the Human Resources and Technical
Support departments due to the long distance between them ?
90* 27 * P a g e 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 27 of 32
m .co
m .co s em
se g la
a between Mysuru and
The distances between these departments 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
m
c o m
Research to Technical Support 80 metres
m .co
Design to .Technical Support s e
e m 60 metres
l a
Mysuru
l as Office to Chennai Office 350 kilometres g
a
ag
The number of computers in each department/office is as follows :
Human Resources 30
Research 80
Design 50
Technical Support
o m 20
Chennai Office 35 . c
As a network engineer, you haveas
em
to propose solutions for various queries
l
listed from I to V. ag
I. Identify the most suitable department to install the main server in
the Mysuru office. Justify your answer with a valid reason.
II. Create a cable layout design to establish Wired network connectivity
between the departments in the Mysuru Office.
III. Suggest the appropriate network device to connect multiple
m
.co
computers within the Research department.
m
c. o IV. What type of network (LAN, MAN, WAN) would bestsem connect the
s em Mysuru and Chennai office ?
g l a
la a weakens while
ag
V. Which device should be used if the signal strength
transmitting data between the Human Resources and Technical
Support departments due to the long distance between them ?
90* 27 * P a g e 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 27 of 32
Page 29
36. scholarship (DataFrame) : 3+1+1=5
Name Course Amount
0 Ananya B.Sc. 62000
1 Karan B.Tech 67000
2 Simran MCA 64000
3 Rahul BCA 70000
4 Priya BA 69000
:
I. (Dictionary of Series)
DataFrame (Python Code)
II. (row index) ['a', 'b', 'c', 'd', 'e']
III. DataFrame (row) delete
(Python statement)
37. (a) SQL : 5
I. / (date/time expression) '2026-01-01 10:10:10'
(date part)
II. Customer Cust_Name
(lowercase)
III. Location City_Name 4 (characters)
(extract )
IV. EVENT CITY (leading spaces)
V. Employees Salary (average salary)
90* 28 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 28 of 32
Name Course Amount
0 Ananya B.Sc. 62000
1 Karan B.Tech 67000
2 Simran MCA 64000
3 Rahul BCA 70000
4 Priya BA 69000
:
I. (Dictionary of Series)
DataFrame (Python Code)
II. (row index) ['a', 'b', 'c', 'd', 'e']
III. DataFrame (row) delete
(Python statement)
37. (a) SQL : 5
I. / (date/time expression) '2026-01-01 10:10:10'
(date part)
II. Customer Cust_Name
(lowercase)
III. Location City_Name 4 (characters)
(extract )
IV. EVENT CITY (leading spaces)
V. Employees Salary (average salary)
90* 28 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 28 of 32
Page 30
m
m .co
m .co s e m
se g l a
a :
36. Consider the DataFrame Scholarship shown below 3+1+1=5
Name Course Amount
0 Ananya B.Sc. 62000
1 Karan B.Tech 67000
2 Simran MCA 64000
m
3 Rahul
m
c. o BA
BCA 70000
m .co
4 Priya 69000
s e
s em l a
g la ag
a the following questions :
Answer
I. Write Python code to create and display the given DataFrame using
the Dictionary of Series method.
II. Rename row indexes to ['a', 'b', 'c', 'd', 'e']
III. Write Python statement to remove the last row of the given DataFrame
m
.co
37. (a)
s em
Write suitable SQL query for the following : 5
la
To display only theg date part from the date/time expression
I.
a
'2026-01-01 10:10:10'
II. To convert all customer names from the Cust_Name column to
lowercase in the Customer table.
III. To extract the first 4 characters from the City_Name column in
Location table.
o m
m c
IV. To display the name of the city from the CITY column .in EVENT
m .co table, after removing leading spaces. s em
s e g la
g la a in Employees
V. To find the average salary from Salary column
a table.
OR
90* 29 * P a g e 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 29 of 32
m .co
m .co s e m
se g l a
a :
36. Consider the DataFrame Scholarship shown below 3+1+1=5
Name Course Amount
0 Ananya B.Sc. 62000
1 Karan B.Tech 67000
2 Simran MCA 64000
m
3 Rahul
m
c. o BA
BCA 70000
m .co
4 Priya 69000
s e
s em l a
g la ag
a the following questions :
Answer
I. Write Python code to create and display the given DataFrame using
the Dictionary of Series method.
II. Rename row indexes to ['a', 'b', 'c', 'd', 'e']
III. Write Python statement to remove the last row of the given DataFrame
m
.co
37. (a)
s em
Write suitable SQL query for the following : 5
la
To display only theg date part from the date/time expression
I.
a
'2026-01-01 10:10:10'
II. To convert all customer names from the Cust_Name column to
lowercase in the Customer table.
III. To extract the first 4 characters from the City_Name column in
Location table.
o m
m c
IV. To display the name of the city from the CITY column .in EVENT
m .co table, after removing leading spaces. s em
s e g la
g la a in Employees
V. To find the average salary from Salary column
a table.
OR
90* 29 * P a g e 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 29 of 32
Page 31
(b) SQL :
I. 172
II. Employee Hire_Date (day
part)
III. Bill Biil_Amount (maximum
value)
IV. Branch Location (leading)
(trailing) (space)
V. Employees tot_sal (total salary)
____________
90* 30 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 30 of 32
I. 172
II. Employee Hire_Date (day
part)
III. Bill Biil_Amount (maximum
value)
IV. Branch Location (leading)
(trailing) (space)
V. Employees tot_sal (total salary)
____________
90* 30 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 30 of 32
Page 32
m
m .co
m .co s e m
se g l a
(b) Write suitable SQL query for the following a
:
I. To display the value of 172 .
II. To display the day part of the dates in the Hire_Date column
of the Employee table.
III. To display the maximum value of the Bill_Amount column in
the Bill table.
m
c o m
IV. To remove leading and trailing spaces from the Location
m .co
. e
as
column in the Branch table.
V. se
m
To display total salary from tot_sal column in Employees gl
g la table. a
a
____________
m
m .co
s e
g la
a
m
m .co
m .co s e m
s e g l a
g la a
a
90* 31 * P a g e 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 31 of 32
m .co
m .co s e m
se g l a
(b) Write suitable SQL query for the following a
:
I. To display the value of 172 .
II. To display the day part of the dates in the Hire_Date column
of the Employee table.
III. To display the maximum value of the Bill_Amount column in
the Bill table.
m
c o m
IV. To remove leading and trailing spaces from the Location
m .co
. e
as
column in the Branch table.
V. se
m
To display total salary from tot_sal column in Employees gl
g la table. a
a
____________
m
m .co
s e
g la
a
m
m .co
m .co s e m
s e g l a
g la a
a
90* 31 * P a g e 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 31 of 32
Page 33
90* 2399 32 * P a g e
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 32 of 32
For more Question Papers, Sample Papers, Notes & Syllabus visit Page 32 of 32
Document Details
| Board / Org | CBSE |
| Exam | Class 12 |
| Type | Question Paper |
| Pages | 33 |
| Language | english |
| Updated | 24 Sep 2026 |