Marking Scheme link is given at every page.

CBSE EXAM 2026 30 Sets

Class : 12th
Sub : Informatics Practices

How to see answers or marking scheme ?

Click above on Every page

If you are unable to click, please open this file using a PDF viewer in Google Drive.

Disclaimer: These papers are based on the SQP released by CBSE and
published by a private organization just for the practice of the students.
CBSE has not released these papers and CBSE is not related to these papers
in any manner. Publisher of these papers clearly state that these paeprs
are only for practice of students and questions may not be come in main
exam.
NODIA APP Sample Paper 01 Page 1

Sample Paper 01
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

SECTION A
1. State whether the following statement is True or False:
The tail() function in Pandas is used to display the first few rows of a Series or DataFrame.

2. What will be the result of the following SQL query?s

SELECT LENGTH(‘IP Exam 2025’);
(A) 11 (B) 12
(C) 13 (D) 10ss

3. A student, Rohan, finds that his classmate has been posting embarrassing photos and spreading false rumors
about him on a social media group. This has caused Rohan significant distress. Which type of cybercrime
does this situation represent?
(A) Phishing (B) Hacking
(C) Cyberbullying (D) Plagiarism

4. Which of the following Python statements is used to read data from a CSV file named ‘data.csv’ into a
Pandas DataFrame df?
(A) df = pd.read_csv(‘data.csv’) (B) df = pd.load_csv(‘data.csv’)
(C) df = pd.import_csv(‘data.csv’) (D) df = pd.open_csv(‘data.csv’)
Page 2 Sample Paper 01 CBSE 12th Informatics Practices

5. Which network device operates at the network layer to connect different networks and forward packets
between them based on their destination IP addresses?
(A) Hub (B) Switch
(C) Repeater (D) Router

6. What is the purpose of the UCASE() function in SQL?

(A) It converts a string to all lowercase letters. (B) It capitalizes the first letter of a string.
(C) It removes extra spaces from a string. (D) It converts a string to all uppercase letters.

7. A technology company has developed a unique logo and brand name to distinguish its products from
competitors. Which type of Intellectual Property Right should it use to protect its logo and brand name?
(A) Patent (B) Copyright
(C) Trademark (D) FOSS

8. Which of the following statements is true about a Pandas Series?

(A) It is a two-dimensional data structure. (B) It can store data of multiple different types.
(C) It is a one-dimensional labeled array. (D) Its size cannot be changed once created.

9. In the context of relational databases, what does the term ‘degree’ refer to?
(A) The number of rows in a table. (B) The number of tables in a database.
(C) The number of columns in a table. (D) The number of primary keys in a table.

10. Which of the following network topologies connects all devices to a central node, such as a switch or a hub?
(A) Bus Topology (B) Star Topology
(C) Ring Topology (D) Mesh Topology

11. Which of the following SQL functions is used to find the average value in a numeric column?
(A) SUM() (B) COUNT()
(C) AVG() (D) MIN()

12. When performing a mathematical operation like addition between two Pandas Series with non-aligned
indices, what happens to the indices that do not overlap?
(A) An error is raised.
(B) The operation is only performed on common indices.
(C) The result contains NaN for non-overlapping indices.
(D) The indices of the second Series are ignored.

13. Leaving a trail of data about yourself online through activities like social media posts, browsing history, and
online shopping is known as creating a:
(A) Digital Copyright (B) Digital Footprint
(C) Cyber Profile (D) E-waste trail

14. Which SQL clause is used to filter the results of a query based on a specified condition?
(A) ORDER BY (B) GROUP BY
(C) HAVING (D) WHERE
NODIA APP Sample Paper 01 Page 3

15. Which of the following Python commands correctly selects the row at integer position 0 and the column at
integer position 1 of a DataFrame df?
(A) df.loc[0, 1] (B) df.iloc[1, 0]
(C) df.loc[1, 0] (D) df.iloc[0, 1]

16. What is the primary function of a web browser?

(A) To host a website on a server.
(B) To send and receive emails.
(C) To retrieve and display content from the World Wide Web.
(D) To create and edit web pages.

17. What is the use of the TRIM() function in SQL?

(A) It removes only leading spaces from a string.
(B) It removes only trailing spaces from a string.
(C) It removes both leading and trailing spaces from a string.
(D) It converts a string to title case.

18. Given a Python dictionary D = {‘a’: 10, ‘b’: 20}, which command creates a Pandas Series from it? (Assume
pandas is imported as pd)
(A) pd.Series.from_dict(D) (B) pd.DataFrame(D)
(C) pd.Series(D) (D) pd.create_series(D)

19. Which of the following plots is most suitable for visualizing the frequency distribution of a continuous
variable?
(A) Line Plot (B) Bar Graph
(C) Histogram (D) Scatter Plot

20. Assertion (A): A Pandas DataFrame is considered heterogeneous.

Reason (R): All columns in a single Pandas DataFrame must contain data of the same type.

21. Assertion (A): The GROUP BY clause in SQL is always used with aggregate functions.
Reason (R): The GROUP BY clause groups rows that have the same values in specified columns into
summary rows, on which an aggregate function can be applied.

SECTION B
22. Write any two points of difference between LAN, MAN, and WAN.


o
What is a home page? Mention two advantages of a home page.

23. Meenakshi , a travel agent, has stored passenger data in a table named Travel with columns (Pno, Pname,
Tdate, Km, Coach). She wants to use a command to count the number of passengers grouped by each coach
type in the Travel table.
SELECT PName, COUNT(Coach) FROM Travel ORDER BY Coach;
But she is not getting the desired result.
Help her for identifying the reason of the error and write the correct query by suggesting the possible
correction(s).
Page 4 Sample Paper 01 CBSE 12th Informatics Practices

24. State differences between date functions NOW( ) and DAY( ) of MySQL.

25. The following Python code contains syntax errors. Rewrite it in correct form, underlining the corrections
made.
import Pandas as pd
data = {‘A’: 1, ‘B’: 2, ‘C’: 3)
my_series = Pd.Series(data)
print(my_series)

26. Write the output of the given code.

import pandas as pd
S1=pd.Series([5,6,7,8,10],
index=([‘v’, ‘w’, ‘x’, ‘y’, ‘z’])
l=[2,6,1,4,6]
S2=pd.Series(l, index=[‘z’, ‘y’,
‘a’, ‘w’, ‘v’])
print(S1 — S2)

27. What are digital property rights? List some examples of digital property rights.

28. Complete the given Python code to given two DataFrames ‘df1’ and ‘df2’, merge them on the ‘ID’ column
to get a single DataFrame ‘merged_df’.
import _____ as pd
df1 = pd.DataFrame({‘ID’: [1, 2, 3],
‘Name’ : [‘Riya’,‘Preeti’,‘Neeta’]})
df2 = pd.DataFrame({‘ID’: [1, 2, 4],
‘Age’: [25, 30, 22]))
merged_df = pd.merge(df1, df2, on
=______)
print(merged_df)

SECTION C
29. “The event in-charge at a school received a suggestion from one of the students to use Python Pandas for
data analysis and Matplotlib for data visualization. She then created a DataFrame named ‘df’ to track the
number of First, Second, and Third prizes won by different houses across various events.”.

House First Second Third

0 Chenab 5 7 6
1 Gangas 10 5 4
2 Jamuna 8 13 15
3 Jhelum 12 9 12
4 Ravi 5 11 10
5 Satluj 10 5 3
Help her to write Python commands to do the following questions:
(i) Display the House names where the number of Second prize are in the range of 12 to 20.
(ii) Display all the records in the reverse order.
(iii) Display the bottom 3 records.
NODIA APP Sample Paper 01 Page 5

30. Mr. Rajat works as a data analyst in an organization, where he utilizes Python Pandas and Matplotlib for
his tasks. He received a dataset of passenger information covering January, March, and December from the
years 2021 to 2023.
Year Month Passengers

0 2021 Jan 25
1 2021 Mar 50
2 2023 Jan 35
3 2021 Dec 55
4 2023 Dec 65
Help him to write the Python code to create the above DataFrame.

31. “Class XII students have access to the school’s Wi-Fi network. The network security team, responsible for
managing a registered URL ‘schoolwifi.edu,’ sent emails to all students on 17th September 2017, informing
them about the expiry of their passwords. Students were instructed to renew their passwords within 24
hours by clicking on the provided URL.”
On the bases of the above information, answer the questions:
(i) Identify the name of cyber crime which is done by given information.
(ii) Ideally, what characters should be used in a password to make it strong?
(iii) What are unsolicited E-mails called as?


o
Explain the features of IT Act 2000.

32. Consider the following table Bookhouse.

Table : Bookhouse
S.No Title Author Subject Publisher Qty Price
1 Data Structure Lips Chute DS McGraw 4 217.00
2 DOS Guide Nortron OS PHI 3 175.00
3 Turbo C++ Robort Lafore Prog Galgotia 5 270.00
4 Dbase Dummies Palmer DBMS PustakM 7 130.00
5 Mastering Windows Cowart OS BPB 1 225.00
6 Computer Studies French FND Galgotia 2 75.00
7 COBOL Stern Prog John W 4 1000.00
8 Guide Network Freed NET Zpress 3 200.00
9 Basic for Beginners Norton Prog BPB 3 40.00
10 Advanced Pascal Schildt Prog McGraw 4 350.00
Write the SQL statements for the following
(i) Display number of books and average Price for each type of Publisher.
(ii) Display Title, Price in descending order of Price.
(iii) Display total number of books available in stock published by BPB.


o
Differentiate between COUNT( ) and COUNT (DISTINCT) functions. Explain with the help of example.
Page 6 Sample Paper 01 CBSE 12th Informatics Practices

SECTION D
33. Naman has created the following DataFrame “Climate” to record the data about climatic conditions of four
years:

Year Max Temp Min Temp Rainfall

2017 32 20 123
2018 33 22 140
2019 35 21 135
2020 34 23 160
(a) What will be the output of the following?
(i) Climate.iloc[1:3, 1:2]
(ii) print(Climate.head(2))
(b) Write the Python code to display the temperature difference between MaxTemp and MinTemp for all
the rows in the DataFrame Climate.
(c) List 1st, 2nd and 3rd rows.

o

(Option for part (c) only)
The exact number of values in each column of the DataFrame?

34. Consider the table Sports given below. Write commands in SQL for the following:

Table : Sports
StudentNo Class Name Game1 Grade Game2 Grade2
10 7 Sammer Cricket B Swimming A
11 8 Sujit Tennis A Skating C
12 7 Kamal Swimming B Football B
13 7 Venna Tennis C Tennis A
14 9 Archana Basketball A Cricket A
15 10 Arpit Cricket A Athletics C
(i) Display the names of the students who have grade ‘A’ in either Game1 or Game2 or both.
(ii) Display the number of students having game ‘Cricket’.
(iii) Display the names of students who have same game for both Game1 and Game2.
(iv) Display the highest class of the students who has opted for swimming as Game1 or Game2.

SECTION E
35. Eduminds University of India is starting its first campus in a small town Parampur of central India with its
centre admission office in Delhi. The university has three major buildings comprising of Admin Building,
Academic Building and Research Building in the 5 km area campus. As a network expert, you need to
suggest the network plan as per (i) to (v) to the authorities keeping in mind the distances and other given
parameters.
NODIA APP Sample Paper 01 Page 7

Expected wire distances between various locations:

Research Building to Admin Building 90 m
Research Building to Academic Building 80 m
Academic Building to Admin Building 15 m
Delhi Admission office to Parampur Campus 1450 km
Expected number of computers. to be installed at various locations in the university are as follows:

Research Building 20
Academic Building 150
Admin Building 35
Delhi Admission Office 5
(i) Suggest the authorities, the cable layout amongst various buildings inside the university campus for
connecting the building.
(ii) Suggest the most suitable place (i.e. building) to house the server of this organisation, with a suitable
reason.
(iii) Suggest an efficient device to be installed in each of the buildings to connect all computers.
(iv) University is planning to provide online facility to students for clearing their doubts.Which of the
following is the online textual or multimedia conversation will they use?
(a) VoIP
(b) Chatting
(c) HTML
(d) None of these
(v) Which software will students use to connect to Internet, create websites and view sites on web?

36. Write the Python code to create a plot as given below:

Page 8 Sample Paper 01 CBSE 12th Informatics Practices

o
Draw the approximate graph which display the multiline in same plot.
import matplotlib.pyplot as plt
x1 = [10,20,40]
y1 = [20,50,10]
plt.plot(x1, y1, label = “line 1”)
x2 = [10,20,30]
y2 = [40,10,20]
plt.plot(x2, y2, label = “line 2”)
plt.xlabel(‘X - axis’)
plt.ylabel(‘Y - axis’)
plt.title(‘Multiline’)
plt.legend()
plt.show()

37. Write the output of following queries.

(i) SELECT POWER(9, 3);
(ii) SELECT MID(‘SHUCHI GOYAL’, 8,5);
(iii) SELECT RIGHT(‘Dushyant’, 5);
(iv) SELECT INSTR(‘SQL FUNCTIONS’,
‘C’);
(v) SELECT LEFT(‘Arihant’, 2);


o
Consider the following table CLUB.

Table : CLUB
COAC H_ID COACH NAME AGE SPORTS Date_of_ Joining PAY
1 Rajesh 30 Karate 1999-08-25 1000
2 Anuj 35 Swimming 2000-01-05 750
3 Shuchi 25 Basketball 2005-01-04 1200
4 Reetika 28 Badminton 2002-08-25 1400
5 Virendra 32 Cricket 1996-05-17 1500
Give the answer of the following questions on the basis of the above table.
(i) Write a query to display the substring of 4 characters of the name of each coach, starting from second
character, with their age.
(ii) What will be the output of the following query?
mysql>SELECT CONCAT (COACHNAME,
AGE) FROM CLUB WHERE AGE> 30;
(iii) Write a query to display the day for the Date_of Joining column.
(iv) What will be the ouput of the following query?
mysql>SELECT PAY *0.25 + 1000
FROM CLUB
WHERE COACHNAME LIKE ‘R%’;
(v) Write a query to display 3 characters from left of coach name.

******
NODIA APP Sample Paper 02 Page 1

Sample Paper 02
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

SECTION A
1. State whether the following statement is True or False:
The HAVING clause in a SQL query can be used to filter rows without a GROUP BY clause.

2. What will be the result of the following SQL query?

SELECT MONTHNAME(‘2025-10-20’);
(A) 10 (B) October
(C) 20 (D) Oct

3. A student downloads an essay from the internet and submits it as their own work for a school assignment
without giving credit to the original author. This act is a direct example of which unethical practice?
(A) Hacking (B) Phishing
(C) Plagiarism (D) Cyberbullying

4. Which of the following methods is correctly used to change the column label ‘StuName’ to ‘StudentName’
in a Pandas DataFrame df?
(A) df.relabel(columns={‘StuName’:’StudentName’})
(B) df.modify(columns={‘StuName’:’StudentName’})
(C) df.rename(columns={‘StuName’:’StudentName’})
(D) df.set_column(old=’StuName’, new=’StudentName’)
Page 2 Sample Paper 02 CBSE 12th Informatics Practices

5. Which network device connects multiple computers in a LAN and forwards data packets to the specific
intended recipient device using its MAC address?
(A) Hub (B) Switch
(C) Repeater (D) Modem

6. What is the primary purpose of the POWER(base, exponent) function in SQL?

(A) To calculate the square root of a number.
(B) To find the remainder of a division.
(C) To raise a number to the power of another number.
(D) To round a number to a specified decimal place.

7. An inventor has created a completely new and useful machine. To gain exclusive rights to manufacture, use,
and sell this invention for a limited period, which form of Intellectual Property Right should they apply for?
(A) Copyright (B) Trademark
(C) Patent (D) License

8. In a Pandas DataFrame df, which attribute would you use to access the row labels?
(A) df.rows (B) df.index
(C) df.labels (D) df.keys()

9. A key that can uniquely identify a row in a table but was not chosen to be the primary key is known as a(n):
(A) Foreign Key (B) Composite Key
(C) Super Key (D) Alternate Key

10. What is the fundamental difference between the Internet and the World Wide Web (WWW)?
(A) They are two different names for the same thing.
(B) The Internet is a software application, while the WWW is hardware.
(C) The Internet is the global network of computers, while the WWW is a service that runs on the Internet.
(D) The WWW is a global network, while the Internet provides access to it.

11. In SQL, what does the COUNT() function return?

(A) The count of non-NULL values in the first column.
(B) The total number of rows selected by the query.
(C) The number of distinct values across all columns.
(D) The count of columns in the table.

12. To permanently remove the ‘Age’ column from a Pandas DataFrame named df, which command is correct?
(A) df.remove(‘Age’, axis=1, inplace=True) (B) df.delete(‘Age’, axis=1, inplace=True)
(C) df.drop(‘Age’, axis=1, inplace=True) (D) df.erase(‘Age’, axis=1, inplace=True)

13. Which of the following best describes Free and Open Source Software (FOSS)?
(A) Software that is provided to users at no monetary cost.
(B) Software whose source code is available for users to view and modify.
(C) Software that can only be used on the Linux operating system.
(D) Software that is developed and maintained by a single company.
NODIA APP Sample Paper 02 Page 3

14. Which SQL clause is used to filter groups that have been created by the GROUP BY clause?
(A) WHERE (B) HAVING
(C) FILTER (D) CONDITION

15. To select only the ‘Name’ and ‘Marks’ columns from a DataFrame df, which syntax should be used?
(A) df(‘Name’, ‘Marks’) (B) df[‘Name’, ‘Marks’]
(C) df[[‘Name’, ‘Marks’]] (D) df.get(‘Name’ & ‘Marks’)

16. A network setup where all devices are connected to a single common cable, and data is transmitted along
this cable, is an example of which topology?
(A) Star (B) Ring
(C) Bus (D) Mesh

17. What is the purpose of the MID() function in SQL?

(A) To find the middle character of a string. (B) To extract a substring from a given string.
(C) To find the position of a substring. (D) To convert a string to lowercase.

18. When creating a Pandas DataFrame from a list of lists, which parameter is used to specify the column
headers?
(A) index (B) headers
(C) names (D) columns

19. The waste generated from discarded electronic devices like computers, mobile phones, and televisions is
known as:
(A) Bio-waste (B) Industrial Waste
(C) E-waste (D) Domestic Waste

20. Assertion (A): Matplotlib is a powerful library for data visualization in Python.
Reason (R): Matplotlib is a built-in part of the Pandas library and cannot be used without first creating a
DataFrame.

21. Assertion (A): The ALTER TABLE command in SQL is a Data Definition Language (DDL) command.
Reason (R): DDL commands are used to define and manage the structure of database objects, such as
tables.

SECTION B
22. What are some factors that have contributed to the rise of cyber crimes?

23. What is the purpose of ORDER BY clause in SQL? Explain with the help of suitable example.

24. Carefully observe the following code:

import pandas as pd
One={‘P’:5000,‘Q’:8000,‘R’:12000,
‘S’: 18000}
Two={‘A’:13000, ‘B’:14000, ‘C’:12000}
totSales={1:One, 2:Two}
df=pd.DataFrame(totSales)
print(df)
Page 4 Sample Paper 02 CBSE 12th Informatics Practices

Answer the following:

(i) List the index of the DataFrame df
(ii) List the column names of DataFrame df.

25. List some benefits of networking. Name any two components required for networking.


o
Give an example of each static web page and dynamic web page.

26. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
Import pandas as pd
Emp = {‘a’ : 10000, ‘b’ : 15000,
‘c’ : 12000}
Sr = pd.Series(Emp)
Print(sr)

27. A character expression name contains ‘try yourself’. Write a command to pick the following set of characters
from it.
(i) First 3 characters
(ii) From 3rd to 7th character

28. Complete the given Python code to get the required output as: 16
import _____ as np
data = [1, 4, 9, 16]
series_data = np._____(data)
print(series_data[______])

SECTION C
29. Consider the table EXAM given below. Write the queries for (i) to (iii).

Table : EXAM
S. No. Name Stip-end Subject Average Division
1 Karan 400 English 68 Ist
2 Aman 680 Mathematics 72 Ist
3 Javed 500 Accounts 67 Ist
4 Bishakh 200 Informatics 55 IInd
5 Sugandha 400 History 35 IIIrd
6 Suparna 550 Geography 45 IIIrd
(i) To list the names of those students, who have obtained division as Ist in ascending order of Name.
(ii) To count the number of students, who have either Accounts or Informatics as Subject.
(iii) To display a report listing Name, Subject and annual Stipend received assuming that the Stipend
column has monthly stipend.
NODIA APP Sample Paper 02 Page 5

o
Reena is working with functions of MySQL.
Explain her following
(i) What is the purpose of NOW( ) function?
(ii) How many parameters does it accept?
(iii) What is the general format of its return type?

30. Given a DataFrame df as shown below

A B C
0 21 12 69
1 45 45 84
2 23 86 70
3 17 33 78
What will be the result of the following code statements?
(i) df[‘D’] = np.NaN
(ii) df[‘D’] = [23, 41, 32]
(iii) df[‘D’] = [23, 41, 32, 9]

31. Give the output of following commands.

(i) mysql>SELECT TRUNCATE (200.91,
1);
(ii) mysql>SELECT LEFT (‘Swati’, 4);
(iii) mysql>SELECT LENGTH
(“Information”);

32. Rahul has recently shifted to a new college and hostel. He does not know many people in his new college
and hostel. But all of a sudden, someone is posting negative, demeaning comments on his social networking
profile etc.
He is also getting repeated mails from unknown people. Every time he goes online, he finds someone chasing
him online.
(i) What is this happening to Rahul?
(ii) What immediate action should he take to handle it?
(iii) Is there any law in India to handle such issues? Discuss briefly.


o
What is software licensing ? Name two types of software licensing with an example of each.
Page 6 Sample Paper 02 CBSE 12th Informatics Practices

SECTION D
33. Mr. Ankit is working in an organisation as data analyst. He uses Python Pandas and Matplotlib for the
same. He got a dataset of the passengers for the year 2010 to 2012 for January, March and December. His
manager wants certain information from him, but he is facing some problems.
Help him by answering few questions given below:

Year Month Passengers

0 2010 Jan 25
1 2010 Mar 50
2 2012 Jan 35
3 2010 Dec 55
4 2012 Dec 65
(i) What will be the output of the following statements?
(a) df.shape( )
(b) df.index=[“AirIndia”, “Indi go”, “Spicejet”, “Jet”, “Emirates”]
(ii) Write the code to get the following output:
Month Passengers
0 Jan 25
2 Jan 35
(iii) Predict the output of print (df[1 : 3])

(Option for part (iii) only)

o
Suppose a DataFrame df contains information about student having columns rollno, name, class and
section. Write the code to transpose DataFrame.

34. Tejasvi Sethi, a car dealer has stored the details of all cars in her showroom in a table CARMARKET. The
table CARMARKET has attributes CARCODE which is a primary key, CARNAME, COMPANY COLOR,
COST (in lakh) of the car and DOM which is the Date of Manufacture of the car.

Table : CARMARKET
CARC-ODE CARNAME COMPANY COLOR COST DOM
C01 BALENO SUZUKI BLUE 5.90 2019-11-07
C02 INDIGO TATA SILVER 12.90 2020-10-15
C03 GLC MERCEDES WHITE 62.38 2020-01-20
C04 A6 AUDI RED 58.55 2018-12-29
C05 INNOVA TOYOTA BLACK 32.82 2017-11-10
C06 WAGON-R SUZUKI WHITE 12.11 2016-11-11
C07 BREZZA SUZUKI GOLDEN 9.80 2016-10-03

Help her by writing answers of the following questions based on the given table.
(i) Display the carname along with the charges rounded off to 1 digit after decimal place.
(ii) Display the carname, name of the company in lower case of all cars whose year (of dom) is 2020.
(iii) Display the number of cars manufactured each year.
(iv) Display the carname, color and position of the character ‘E’ in the color of all the cars.
NODIA APP Sample Paper 02 Page 7

SECTION E
35. Green Valley Public School has 4 buildings in its campus . Distance between the buildings and the number
of computers in each is given below

Building Number of Computers

A 150
B 10
C 25
D 3

Building Distance
A-B 10 m
A-C 1250 m
A-D 25 m
B-C 30 m
B-D 2000 m
(i) Which building is best suitable for placement of server?
(ii) If building A to D is to be connected, which device will be required for strong signals?
(iii) Which building would need a switch/hub?
(iv) Which topology would you suggest for connecting computers in each building?
(v) Suggest and draw cable layout to efficiently connect various buildings within the school campus for a
wired connectivity.

36. Write down the syntax format of the following functions, with one example of each.
(i) LCASE(str)
(ii) UCASE(str)
(iii) RIGHT(str,n)
(iv) POWER(m,n)
(v) RTRIM(str)
Page 8 Sample Paper 02 CBSE 12th Informatics Practices

o
Consider the table DOCTOR given below. Write commands in SQL for (i) to (iv) and answer the question
for (v).

Table : DOCTOR
ID DOCName Department DOJ Gender Salary
1 Amit Kumar Orthopaedics 1993-02-12 M 35000
2 Anita Hans Paediatrics 1998-10-16 F 30000
3 Sunita Maini Gynaecology 1991-08-23 F 40000
4 Joe Thomas Surgery 1994-10-20 M 55000
5 Gurpreet Kaur Paediatrics 1999-11-24 F 52000
6 Anandini Burman Oncology 1994-03-16 F 31000
7 Siddharth Dang Surgery 1995-09-08 M 47000
8 Rama Mukherjee Oncology 2000-06-27 F 54500

(i) Display the names and salaries of doctors in descending order of salaries.
(ii) Display names of each department along with total salary being given to doctors of that department.
(iii) Display the number of doctors in each department.
(iv) To display all the female doctors from the given data.
(v) Identify the primary key from the table DOCTOR.

37. A bar graph is used to show individual figures at a specific time or to compare different items. Similarly, a
bar graph which is showing the marks of different subjects. You have to write the code that will represent
the given graph.

Write a Python code to create a line graph for the data given below based on Games apps rated by the users.
Games = [“Subway Surfer”, “Temple Run”, “CandyCrush”, “Bottle Shot”, “Runner Best”]
Rating= [4.2, 4.8, 5.0, 3.8, 4.1]

******
NODIA APP Sample Paper 03 Page 1

Sample Paper 03
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

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

2. What will be the result of the following SQL query?

SELECT LCASE(‘MySQLExam’);
(A) MYSQLexam (B) Mysqlexam
(C) mysqlexam (D) MySQLExam

3. Riya has been using the internet for several years. Her online shopping history, social media posts, and
search engine queries have created a large trail of data about her preferences and activities. What is this
trail of data called?
(A) Online Persona (B) Digital Footprint
(C) Cyber Profile (D) Data Cache

4. Which of the following is the correct syntax to add a new column named ‘Score’ to a Pandas DataFrame df
and initialize all its values to 0?
(A) df.new_column(‘Score’, 0) (B) df.insert(column=’Score’, value=0)
(C) df[‘Score’] = 0 (D) df.add(‘Score’, 0)
Page 2 Sample Paper 03 CBSE 12th Informatics Practices

5. Which network device is primarily used to regenerate a weak signal to extend the transmission distance over
a network?
(A) Switch (B) Router
(C) Repeater (D) Gateway

6. What is the purpose of the ROUND(number, decimals) function in SQL?

(A) To truncate a number to a specified decimal place.
(B) To return the integer part of a number only.
(C) To round a number to a specified number of decimal places.
(D) To calculate the remainder after division.

7. An author has written a new book of poems. Which type of Intellectual Property Right automatically
protects this literary work from unauthorized copying and publication?
(A) Patent (B) Copyright
(C) Trademark (D) Trade Secret

8. Which attribute of a Pandas DataFrame df returns a tuple representing its dimensions (number of rows,
number of columns)?
(A) df.size (B) df.dim
(C) df.shape (D) df.axes

9. In a relational database, what is a field in one table that uniquely identifies a row of another table called?
(A) Primary Key (B) Foreign Key
(C) Candidate Key (D) Super Key

10. Which of the following technologies enables users to make phone calls over the Internet?
(A) HTTP (B) FTP
(C) SMTP (D) VoIP

11. Which SQL aggregate function is used to find the largest value in a selected column?
(A) LARGE() (B) MAX()
(C) TOP() (D) UPPER()

12. To select all rows from a DataFrame df where the value in the ‘Score’ column is greater than 90, which
syntax is correct?
(A) df.select(‘Score’ > 90) (B) df.where(df[‘Score’] > 90)
(C) df[‘Score’ > 90] (D) df[df[‘Score’] > 90]

13. According to Netiquette (network etiquette), typing an entire message in capital letters is often interpreted
as:
(A) Being polite and formal. (B) Shouting or being angry.
(C) Ensuring the message is read carefully. (D) Indicating high importance.
NODIA APP Sample Paper 03 Page 3

14. Which SQL clause is used to arrange the result-set in ascending or descending order?
(A) SORT BY (B) GROUP BY
(C) ORDER BY (D) ARRANGE BY

15. A DataFrame df has string indices: ‘Mon’, ‘Tue’, ‘Wed’, ‘Thu’. Which command will select the rows from
‘Tue’ to ‘Thu’ (inclusive)?
(A) df.iloc[‘Tue’:’Thu’] (B) df.loc[‘Tue’:’Thu’]
(C) df.loc[‘Tue’:’Wed’] (D) df.iloc[1:3]

16. Which network topology offers the highest level of fault tolerance and redundancy because every node is
connected directly to every other node?
(A) Bus (B) Star
(C) Tree (D) Mesh

17. What does the INSTR(string, substring) function in SQL return?

(A) The length of the string.
(B) A boolean value indicating if substring is present.
(C) The starting position of the first occurrence of substring.
(D) The extracted substring from the string.

18. Which of the following commands is used to create a bar plot from a Pandas Series s?
(A) s.create_plot(kind=’bar’) (B) s.chart(type=’bar’)
(C) s.plot(kind=’bar’) (D) s.bar_plot()

19. What is the full form of URL?

(A) Universal Resource Link (B) Uniform Record Locator
(C) Universal Record Link (D) Uniform Resource Locator

Direction : For questions 20 and 21, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

20. Assertion (A): When a scalar value is added to a Pandas Series, the operation is performed on every element
of the Series.
Reason (R): This feature is known as broadcasting, where the scalar value is stretched to match the shape
of the Series for the operation.

21. Assertion (A): It is unsafe to conduct financial transactions on an unsecured public Wi-Fi network.
Reason (R): Unsecured networks do not encrypt data, allowing attackers on the same network to potentially
intercept sensitive information like passwords and bank details.
Page 4 Sample Paper 03 CBSE 12th Informatics Practices

SECTION B
22. Rajesh, a freelance website developer, has been tasked with designing several web pages for a bookshop.
Help Aman decide whether to create static or dynamic web pages by clearly outlining at least two points of
difference between static and dynamic web pages.


o
Priyanka, a beginner in IT field has just started learning web technologies. Help her in understanding the
difference between website and web pages with the help of a suitable general example of each.

23. List two environmental hazards and two health hazards caused by e-Waste.

24. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
Import pandas as pd
data = {‘Name’: [‘Riya’, ‘Preeti’, ‘Neeta’], ‘Age’: [25, 30, 22]}
df = Pd.DataFrame(Data)
df.to_csv(‘output.csv’)

25. Aryan, a database administrator, has grouped records of a table with the help of GROUP BY clause.
He needs to further filter groups of records generated through GROUP BY clause. Suggest suitable clause
for it and properly, explain its usage with the help of an example.

26. Complete the given Python code: Given a DataFrame ‘df’, select rows where the ‘score’ column is greater
than 80 and ‘age’ column is less than 30.
import _____ as pd
df = pd.DataFrame(‘name’: [‘Riya’,
‘Preeti’, ‘Neeta’], ‘age’: [25,
30, 22], ‘score’: [85, 78, 92]})
selected_rows = df[(df[‘score’]
>_____) & (df[‘age’] <_____)]
print(selected_rows)

27. Riya has given the following command to obtain the highest salary
SELECT MAX (EMP_SALARY) FROM Employee
WHERE GROUP BY DOJ;
But she is not getting the desired output.
Help her by writing the correct command.

28. Consider the following DataFrame df 1:

EName Sal Bonus

0 Kavita 50000 3000
1 Sudha 60000 4000
2 Garima 55000 5000
Write the output of the given command:
NODIA APP Sample Paper 03 Page 5

SECTION C
29. Ritika is a new learner for the Python Pandas and she is aware of some concepts of Python but is unable
to create the DataFrame. Help her by writing proper statements which will create the DataFrame for the
following data.
Name: [‘Manpreet’, ‘Kavil’, ‘Manu’, ‘Ria’]
Phy : [70, 60, 76, 89]
Chem : [30, 70, 50, 65]

30. Saharsh is a student of Class IXth and he is a very frequent user of Internet applications. One day he got
an unpleasant message on his instant messenger.
(i) What do you think he should do?
(ii) Exhibiting proper manners and etiquettes while being online is called as?
(iii) Name the law to handle such issues?


o
Mr. Navneet found that his login id and password are automatically appearing on keypress in the login page.
Explain him how cookies are responsible for this and how they are useful?

31. Ms.Saumya is working on a MySQL table named ‘Hotel’ having following structure:

Table : Hotel
Field Type Null Key Default Extra
user_id varchar(20) YES NULL
name varchar(20) YES NULL
city varchar(20) YES NULL
mobile_no varchar(11) YES NULL

She needs to perform following task on the table.

(i) To fetch last 2 characters from the user_id column.
(ii) To display the values of name column in lower case.
(iii) To display 3 characters from 3rd place from the column city.
Suggest suitable SQL function for the same. Also, write the query to achieve the desired task.


o
While dealing with string data type in MySQL, its observed that sometimes unnecessary space character
comes in between which hampers the successful executing of a string manipulation module. Name the
suitable MySQL function(s) to remove leading, trailing and both type of space characters from a string.
Also, give MySQL queries to depict the same.

32. Predict the output of the following queries.

(i) SELECT INSTR(‘exams@cbse.nic.in’, ‘.’);
(ii) SELECT SUBSTR(‘exams@cbse.nic.in’ , 7, 4);
(iii) SELECT LEFT(‘exams@cbse.nic.in’ ,5);
Page 6 Sample Paper 03 CBSE 12th Informatics Practices

SECTION D
33. Consider the following DataFrame dfn:
A B C
Order 450 180 350
Purchase 330 550 610
Sell 250 410 380
Target 1050 980 1250
(a) Write the output of the following statement.
(i) dfn[[‘A’, ‘B’]]
(ii) dfn.loc [‘Purchase’, :]
(b) Write the code to replace the existing indexes of a DataFrame with O, P, S and T, respectively.
(c) To transpose the DataFrame dfn.

(option for part (c) only)

o
To create another DataFrame S1 and add above DataFrame to it.

34. Consider the above table and write the SQL commands for the following:

Table : Worker
Ecode Name Desig Plevel DOJ DOB
11 Radhey Shyam Supervisor P001 13-Sep-2004 23-Aug-1981
12 Chander Nath Operator P003 22-Feb-2010 12-Jul-1987
13 Fizza Operator P003 14-June-2009 14-Oct-1983
15 Ameen Ahmed Mechanic P002 21-Aug-2006 13-Mar-1984
18 Sanya Clerk P002 19-Dec-2005 09-June-1983
(i) To display the details of all workers in descending order of DOB.
(ii) To display Name and Desig of those workers, whose Plevel is either P001 or P002.
(iii) To display the detail of all the workers, whose DOB is in between ‘19-JAN-1984’ and ‘18-JAN-1987’.
(iv) To add a new row with the following data:
19, ‘Daya kishore’, ‘Operator’, ‘P003’, ‘19-Jun-2008’, ‘11-Jul-1984’

SECTION E
35. Write the code in Pandas to create the following DataFrame
Name Designation Salary
1 Abhi DBA 35000
2 Vanshika Pragrammer 40000
3 Riya Tester 32000
4 Chirag Content Writer 25000
5 Tushar Business Analyst 30000
6 Khushal Sales Executive 37000
7 Mahi Web Designer 42000
NODIA APP Sample Paper 03 Page 7

Write the commands to do the following operations on the Data Frame given above:
(i) To select the column Designation.
(ii) To change index label from 1 to E101, 2 to E102, .... and so on.


o
Write the code for the following bar graph.

36. Based on above table, write the SQL commands for the following:

Table : Furniture
No Itemname Type Date of stock Price Dis-count
1 White lotus Double Bed 23/02/02 30000 25
2 Pink feather Baby Cot 20/01/02 7000 20
3 Dolphin Baby Cot 19/02/02 9500 20
4 Decent Office Table 01/01/02 25000 30
5 Comfort Zone Double Bed 12/01/02 25000 25

(i) To show all information about the baby cots from the Furniture table.s
(ii) To list the Itemname which are priced at more than 15000 from the Furniture table.
(iii) To list Itemname and Type of those items, in which Dateofstock is before 22/01/02 from the Furniture
table in the descending order of Itemname.
(iv) To display Itemname and Dateofstock of those items, whose Type is “Sofa” from Furniture table
(v) To insert a new row in the Furniture table with the following data:
14, “Velvet touch”, “Double Bed”, {25/03/03}, 25000,30


o
Explain the following SQL functions using suitable examples.
(i) RIGHT()
(ii) COUNT()
(iii) YEAR()
(iv) SUM()
(v) MOD()
Page 8 Sample Paper 03 CBSE 12th Informatics Practices

37. JNV School at Hyderabad have their offices according to the following diagram. Go through the details and
answer the questions that follows.

Distance between various wings are given below:

Wings Distance(in metre)

MESS to SCHOOL 60
MESS to DORMETORY 110
MESS to GATE 65
MESS to ADMIN 130
SCHOOL to DORMETORY 40
SCHOOL to GATE 50
SCHOOL to ADMIN 68
DORMETORY to GATE 115
DORMETORY to ADMIN 100
GATE to ADMIN 65
(i) Name the most suitable wing, where the server should be installed. Justify your answer.
(ii) Draw the cable layout to efficiently connect various wings JNV, Hyderabad and also write the topology.
(iii) Suggest a device/software and its placement that would provide data security for the entire network of
the School.
(iv) (a) Which device will you suggest to be placed/installed in each of these wings to efficiently connect all
the computers within these wings.
(b) Suggest the placement of a repeater in the network with justification.
(v) Suggest a device and the protocol that shall be needed to provide wireless Internet access to all smart
phone/laptop users in the campus of.JNV, Hyderabad.

******
NODIA APP Sample Paper 04 Page 1

Sample Paper 04
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

SECTION A
1. State whether the following statement is True or False:
In SQL, the results of COUNT() and COUNT(column_name) will always be identical for any non-empty
table.

2. What will be the result of the following SQL query?

SELECT LENGTH(TRIM(‘ Pandas ‘));
(A) 10 (B) 9
(C) 8 (D) 6

3. A social media company uses its users’ personal data for targeted advertising. It then sells this data to other
companies without the users’ explicit permission. This practice violates principles related to:
(A) Intellectual Property Rights (B) Data Protection
(C) Netiquette (D) Open Source Software

4. Given a Python dictionary data = {‘Name’: [‘Aisha’, ‘Ben’], ‘Score’: [88, 92]}, which command correctly
creates a Pandas DataFrame?
(A) df = pd.create_dataframe(data) (B) df = pd.DataFrame(data)
(C) df = pd.make_df(data) (D) df = DataFrame.from_dict(data)
Page 2 Sample Paper 04 CBSE 12th Informatics Practices

5. A computer network that spans a large geographical area, such as a city, connecting multiple LANs is known
as a:
(A) PAN (Personal Area Network) (B) LAN (Local Area Network)
(C) MAN (Metropolitan Area Network) (D) WAN (Wide Area Network)

6. What is the primary purpose of the NOW() function in SQL?

(A) To return the current system date only. (B) To return the current system time only.
(C) To return the current system date and time. (D) To convert a string into a date-time format.

7. A company uses a copyrighted photograph on its official website for marketing purposes without obtaining
permission or a license from the photographer. This act is an example of:
(A) Plagiarism (B) Copyright Infringement
(C) Digital Footprint (D) Fair Use

8. Which attribute of a Pandas DataFrame df is used to get its transposed form, where rows become columns
and columns become rows?
(A) df.transpose() (B) df.invert()
(C) df.T (D) df.flip()

9. In a database table, any column or a set of columns whose values can uniquely identify a record is known
as a:
(A) Foreign Key (B) Primary Key
(C) Composite Key (D) Candidate Key

10. A web page whose content remains the same for all users and only changes when a web developer manually
edits its source code is called a:
(A) Dynamic Web Page (B) Static Web Page
(C) Hosted Web Page (D) Responsive Web Page

11. To find the number of unique cities present in a ‘Customers’ table, which SQL query should be used?
(A) SELECT COUNT(City) FROM Customers;
(B) SELECT UNIQUE(City) FROM Customers;
(C) SELECT COUNT(DISTINCT City) FROM Customers;
(D) SELECT DISTINCT(COUNT(City)) FROM Customers;

12. Which of the following commands correctly increases every value in the ‘Salary’ column of a DataFrame df
by 5%?
(A) df[‘Salary’] = df[‘Salary’] 1.05 (B) df.update(‘Salary’, multiplier=1.05)
(C) df.apply(‘Salary’, lambda x: x 1.05) (D) df[‘Salary’].add(0.05)

13. Which is the primary legislation in India that governs cybercrime and electronic commerce?
(A) The Indian Penal Code (B) The Copyright Act, 1957
(C) The Information Technology Act, 2000 (D) The Digital Security Act
NODIA APP Sample Paper 04 Page 3

14. In SQL, which clause is used to collect and combine rows with identical values in a specific column into
summary rows?
(A) ORDER BY (B) GROUP BY
(C) AGGREGATE BY (D) SUMMARIZE BY

15. How can you select the first 5 rows and the first 3 columns of a DataFrame df using integer-based indexing?
(A) df.loc[:5, :3] (B) df.iloc[:5, :3]
(C) df.loc[0:4, 0:2] (D) df.iloc[1:5, 1:3]

16. What is the primary function of a modem?

(A) To connect multiple devices within a LAN.
(B) To filter network traffic.
(C) To modulate and demodulate signals for transmission over telephone lines.
(D) To create a wireless network.

17. Which SQL function is used to extract the four-digit year from a date value?
(A) GETYEAR() (B) DATEPART(‘year’, date)
(C) YEAR() (D) EXTRACT(YEAR, date)

18. In Matplotlib, which pair of functions is used to set the descriptive labels for the horizontal and vertical
axes of a plot?
(A) plt.xlabel() and plt.ylabel() (B) plt.xaxis() and plt.yaxis()
(C) plt.set_x() and plt.set_y() (D) plt.label_x() and plt.label_y()

Direction : For questions 19 and 20, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

19. The acronym WWW, which refers to the global system of interlinked hypertext documents, stands for:
(A) Web World Wide (B) Wide World Web
(C) World Web Wide (D) World Wide Web

20. Assertion (A): The drop() method in Pandas can remove both rows and columns from a DataFrame.
Reason (R): The axis parameter of the drop() method is used to specify whether to target rows (axis=0) or
columns (axis=1).

21. Assertion (A): Plagiarism is strictly an ethical issue and has no legal consequences.
Reason (R): Plagiarism can escalate into copyright infringement, which is a legal offense punishable by law.
Page 4 Sample Paper 04 CBSE 12th Informatics Practices

SECTION B
22. What do you understand by degree and cardinality of a table? Give an example.

23. Sahil, a Class X student, has just started understanding the basics of Internet and web technologies. He is
a bit confused in between the terms “World Wide Web” and “Internet”.
Help him in understanding both the terms with the help of suitable examples of each.


o
Ruhani wants to edit some privacy settings of her browser. How can she accomplish her task?

24. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
import pandas as Pd
data = [10, 20, 30, 40, 50]
myseries = pd.Series(data)
result = my_series + 5
print()

25. Shanya Khanna is using a table EMPLOYEE. It has the following columns.
Admno, Name, Agg, Stream [column Agg contains Aggregate marks]
She wants to display highest Agg obtained in each Stream.
She wrote the following statement:
SELECT Stream, MAX(Agg) FROM EMPLOYEE;
But she did not get the desired result. Rewrite the above query with necessary changes to help her get the
desired output.

26. Given a code :

Numseries = pd.Series ([12,14,16])
Write the Python command to:
(i) Display the double of each element of Series.
(ii) Display all odd values of Series.

27. Complete the given Python code: Given the Data Frame ‘df’, drop the ‘salary’ column and display the first
5 rows of the modified Data Frame.
import ______ as pd
df = pd. Data Frame({‘name’: [‘Riya’, ‘Preeti’, ‘Neeta’],
‘age’: [25, 30, 22],
‘salary’: [50000, 60000, 45000]})
df = df._____ (_____, axis=1)
print(df. ______(_____))

28. What are the disadvantages of e-Waste recycling?

NODIA APP Sample Paper 04 Page 5

SECTION C
29. XYZ Company developed software, related to face recognition with a team of 15 software developers. XYZ
company registered the software with a face symbol to easily recognize their software. Before approval of
software by the registering firm, Rohit one of the team member of the software published the same software
in internet under different name as it is his own development. XYZ firm recognized this activity and
informed to the police. The police people arrested the Rohit and removed the software from the internet.
Police advice the XYZ firm to apply for patent as the software is a new invention.
Answer the following questions
(i) XYZ firm registered the software with face symbol to easily recognize their software .In this context,
face symbol is called as _____.
(ii) The activities done by the Rohit is called as _____.
(iii) Among the following options, which is automatically granted to XYZ Company?
(a) Trademark (b) Patent
(c) Copyright (d) None of these


o
Define the content management system of digital property right. List three factors about the reason behind
plagiarism.

30. Consider the following table GARMENT, write SQL commands for the statements (i) to (iii).

Table : GARMENT
GCO-DE DESCRIPTION PRICE FC-ODE READY-DATE
10023 PENCIL SKIRT 1150 F03 19-DEC-08
10001 FORMAL SHIRT 1250 F01 12-JAN-08
10012 INFORMAL SHIRT 1550 F02 06-JUN-08
10024 BABY TOP 750 F03 07-APR-07
10090 TULIP SKIRT 850 F02 31-MAR-07
10019 EVENING GOWN 850 F03 06-JUN-08
10009 INFORMAL PANT 1500 F02 20-OCT-08
10007 FORMAL PANT 1350 F01 09-MAR-08
10020 FROCK 850 F04 09-SEP-07
10089 SLACKS 750 F03 20-OCT-08
(i) To display GCODE and DESCRIPTION of each GARMENT in descending order of GCODE.
(ii) To display the details of all the GARMENT, which have READYDATE in between 08-DEC-07 and 16-
JUN-08 (inclusive if both the dates).
(iii) To display the average PRICE of all the GARMENT, which are made up of fabric with FCODE as F03.

o
Describe different kinds of SQL command with proper examples.
Page 6 Sample Paper 04 CBSE 12th Informatics Practices

31. Consider the table PERSONS given below. Write output for queries (i) to (iii).

Table : PERSONS
PID SurName FirstName Gender City PinCode Salary
1 Sharma Geet F Udhamwara 182141 50000
2 Singh Surinder M Kupwara Nagar 193222 75000
3 Jcob Peter M Bhawani 185155 45000
4 Alvis Thomas M Ahmed Nagar 380025 50000
5 Mohan Gaurav M Nagar Coolangatta 390026 33000
6 Azmi Simi F New Delhi 110021 40000
7 Kaur Manpreet F Udhamwara 182141 42000
(i) SELECT SurName FROM PERSONS WHERE Salary > = 50000;
(ii) SELECT SUM (Salary) FROM PERSONS WHERE Gender = ‘F’;
(iii) SELECT Gender, MIN (Salary) FROM PERSONS GROUP BY Gender;

32. Amit wants to create a DataFrame df whose columns store following data about his friends:

RollNo Name Email

1 Kailash kai@gmail.com
2 Rima rim@gmail.com
3 Sunil sun@gmail.com

Write the Python command to

(i) Display the second row.
(ii) Alter the position of column Name and E-mail.
(iii) Export the DataFrame to CSV file named friends.

SECTION D
33. Given a DataFrame Traindf:

Index Trainno Tname Fare

0 12378 Padatik 8900
1 12344 Rajdhani 2900
2 12450 Gitanjali 5600
(a) Predict the output of the following Python statement.
(i) print(Traindf.loc[2,“Fare”]%2)
(ii) del Traindf[‘Fare’]
print (Traindf)
(b) Write the command that displays output as 9.
(c) To delete the 3rd column.

(Option for part (c) only)

o
Write the command to display second row only.
NODIA APP Sample Paper 04 Page 7

34. Consider the table FANS:

Table : FANS
FAN_ID FAN_NAME FAN_CITY FAN_DOB FAN_MODE
F001 SUSHANT MUMBAI 1998-10-02 MAIL
F001 RIYA MUMBAI 1997-12-12 LETTER
F003 ANIKA DELHI 2001-06-30 BLOG
F004 RUDRA AJMER 2005-08-22 MAIL
F006 MIARA KOLKATTA 1998-11-01 BLOG
Write MySQL queries for the following questions:
(i) To display the details of FANS in descending order of their DOB.
(ii) To display the details of FANS who does not belong to AJMER.
(iii) To count the total number of FANS of each FAN_MODE.
(iv) To display the DOB of the youngest fan.

SECTION E
35. Write the code in Pandas to create the following DataFrame:
df1 df2
Mark1 Mark2 Mark1 Mark2
0 30 20 0 10 15
1 40 45 1 20 25
2 15 30 2 20 30
3 40 70 3 50 30
Write the commands to do the following operations on the dataframes given above:
(i) To display both the dataframes.
(ii) To add dataframes df1 and df2.
(iii) To subtract df2 from df1.
(iv) To rename column Mark1 as Marks1 in both the dataframes df1 and df2.
(v) To change index label of df1 from 0 to zero and 1 to one.


o
Given a plot below, write the Python code to plot the graph.
Page 8 Sample Paper 04 CBSE 12th Informatics Practices

36. Akhilesh a clerical staff in a Doctor’s Dispensary. He maintains records of visiting doctors in a table Doctor.
He wants to analyse some data and find some results such as total number of doctors of certain departments,
average charges in some departments etc. Help him in writing proper queries to get the results.

Table : Doctor
Did Dname Dept Charges VisitDays
D01 R. Sharma ENT 1000 Mon
D02 D. Basak ENT 1500 Wed
D03 M. Agarwal PAED 6000 Sat
D04 E. Joseph Ortho 1200 Sun
D05 M. Fernandes Ortho 4000 Thu
(i) To display the maximum Charges among the Ortho Doctors.
(ii) To display the doctor names in uppercase along with their department names concatenated.
(iii) To display each department and the total number of doctors in them.
(iv) To display each department and the average charges of each.
(v) To display the detail of doctor whose department is ENT.


o
Consider the following table CLUB.

Table : CLUB
COA CH _ID COACH NAME AGE SPORTS Date_of_Joining PAY
1 Rajesh 30 Karate 1999-08-25 1000
2 Anuj 35 Swimming 2000-01-05 750
3 Shuchi 25 Basketball 2005-01-04 1200
4 Reetika 28 Badminton 2002-08-25 1400
5 Virendra 32 Cricket 1996-05-17 1500
Give the answer of the following questions on the basis of the above table.
(i) Write a query to display the substring of 4 characters of the name of each coach, starting from second
character, with their age.
(ii) What will be the output of the following query?
mysql>SELECT CONCAT (COACHNAME,
AGE) FROM CLUB WHERE AGE> 30;
(iii) Write a query to display the day for the Date_of Joining column.
(iv) What will be the output of the following query?
SELECT PAY *0.25 + 1000 FROM CLUB
WHERE COACHNAME LIKE ‘R%’;
(v) Write a query to display 3 characters from left of coach name.

37. Bhartiya Connectivity Association is planning to spread their offices in four major cities of India to provide
regional IT infrastructure support in the field of education and culture.
The company has planned to set up their head office in New Delhi in three locations and have named their
New Delhi offices as Front Office, Back Office and Work Office. The company has three more regional offices
as three major cities of India. A rough layout of the same is as follows:
NODIA APP Sample Paper 04 Page 9

Approximate distances between these offices as per network survey team is as follows:

Place from Place to Distance

Back Office Front Office 10 m
Back Office Work Office 70 m
Back Office East Office 1291 m
Back Office West Office 790 m
Back Office South Office 1952 m
In continuation of the above, the company experts have planned to install the following number of computers
in each of their offices.

Back Office 100 Front Office 20

Work Office 50 East Office 50
West Office 50 South Office 50
(i) Suggest the network type (out of LAN, MAN, WAN) for connecting each of the following set of the their
offices.
(a) Back Office and Work Office
(b) Back Office and South Office
(ii) Which device will you suggest to be procured by the company for connecting all the co computers with
each of their offices out of the following devices?
(a) Switch/Hub
(b) Modem
(iii) Suggest the cable/wiring layout for connecting the company’s local offices located in New Delhi. Also,
suggest an effective method for connecting the company’s regional offices East Office, West Office and
South Office with officeg located in New Delhi.
(iv) Data is converted in a form so as to travel over telpphone lines using this device.
(v) Network device that sends the data over optimising paths through connected loop is
(a) gateway (b) hub
(c) router (d) bridge

******
NODIA APP Sample Paper 05 Page 1

Sample Paper 05
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

SECTION A
1. State whether the following statement is True or False:
In Pandas, the .loc indexer is used exclusively for integer-position based indexing of a DataFrame.

2. What will be the result of the following SQL query?

SELECT RIGHT(‘Informatics’, 4);
(A) Info (B) matics
(C) tics (D) orma

3. An individual illegally bypasses a company’s computer security systems to gain unauthorized access to its
confidential customer database. This criminal act is an example of:
(A) Phishing (B) Hacking
(C) Cyberstalking (D) Plagiarism

4. Which Pandas method is used to detect missing or NaN (Not a Number) values in a Series or DataFrame?
(A) df.has_nan() (B) df.missing()
(C) df.isnull() (D) df.check_null()

5. Which network device is specifically designed to connect two different types of networks that use different
protocols, acting as a protocol translator?
(A) Hub (B) Gateway
(C) Repeater (D) Bridge
Page 2 Sample Paper 05 CBSE 12th Informatics Practices

6. What is the primary role of the LENGTH() function in SQL?

(A) To determine the number of rows in a table.
(B) To return the number of characters in a string.
(C) To set the maximum length for a VARCHAR column.
(D) To count non-NULL values in a column.

7. A software development team creates an application and decides to publish its source code publicly, allowing
anyone to use, study, modify, and share it. What type of license would they use for this purpose?
(A) A proprietary license
(B) A commercial license
(C) A FOSS (Free and Open Source Software) license
(D) An end-user license agreement (EULA)

8. Which attribute of a Pandas Series s would you use to get its underlying data as a NumPy array?
(A) s.data (B) s.array
(C) s.list (D) s.values

9. Which of the following SQL commands belongs to the Data Manipulation Language (DML) subcategory?
(A) CREATE TABLE (B) ALTER TABLE
(C) INSERT INTO (D) DROP TABLE

10. What is a collection of related web pages, including multimedia content, typically identified with a common
domain name and published on at least one web server?
(A) Web Browser (B) Web Server
(C) Website (D) URL

11. To find the total revenue from a ‘Sales’ table, which SQL aggregate function should be applied to the ‘Price’
column?
(A) TOTAL(Price) (B) AVG(Price)
(C) SUM(Price) (D) COUNT(Price)

12. Which method is used to sort a Pandas DataFrame df based on the values of one or more columns?
(A) df.sort() (B) df.order_by()
(C) df.arrange() (D) df.sort_values()

13. Spending long hours working on a computer with incorrect posture can lead to repetitive strain injury (RSI)
and back pain. This is an example of:
(A) A cybercrime hazard. (B) A health concern related to technology usage.
(C) A consequence of e-waste. (D) A violation of netiquette.

14. In SQL, which clause is used to combine rows from two or more tables based on a related column?
(A) MERGE (B) JOIN
(C) COMBINE (D) CONNECT

15. Which of the following will select the ‘City’ column from a DataFrame df and return it as a Pandas Series?
(A) df[[‘City’]] (B) df.loc[‘City’]
(C) df[‘City’] (D) df.get_column(‘City’)
NODIA APP Sample Paper 05 Page 3

16. A network created for connecting personal devices like a laptop, smartphone, and wireless headphones
within the range of an individual is known as:
(A) LAN (Local Area Network) (B) WAN (Wide Area Network)
(C) MAN (Metropolitan Area Network) (D) PAN (Personal Area Network)

17. Which SQL function returns the name of the day (e.g., ‘Friday’) for a specified date?
(A) DAY() (B) DAYOFWEEK()
(C) DAYNAME() (D) WEEKDAY()

18. To add a title to a graph created using Matplotlib (imported as plt), which function should be used?
(A) plt.heading(“My Graph”) (B) plt.label(“My Graph”)
(C) plt.title(“My Graph”) (D) plt.header(“My Graph”)

19. Which of the following activities is NOT considered a form of cybercrime?

(A) Phishing (B) Hacking
(C) Cyberbullying (D) Using FOSS

Direction : For questions 20 and 21, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

20. Assertion (A): In SQL, the WHERE clause filters rows before grouping, while the HAVING clause filters
groups after grouping.
Reason (R): Both WHERE and HAVING clauses can be used interchangeably with aggregate functions.

21. Assertion (A): In a star network topology, the failure of a central device can cause the entire network to fail.
Reason (R): All nodes in a star topology are connected to and communicate through a single central hub
or switch.

SECTION B
22. Amisha aims to organize the result set by grouping it based on the values in a specific column. Additionally,
she wants the grouped results to be displayed in a sorted sequence. In what sequence should she arrange the
two clauses for grouping and sorting? Provide an example to illustrate your answer.

23. The following query is resulting in an error. Identify the error and provide the correct version of the query:
SELECT * FROM EMP ORDER BY NAME WHERE SALARY>=5000;

24. List one function of gateway and switch each.

o
What is a computer network? List down the types of computer networks.
Page 4 Sample Paper 05 CBSE 12th Informatics Practices

25. Answer the following based on the Series given below:

import pandas as pd
list1=[1,2,3,4,5,6,7,8]
list2=[‘swimming’, ‘tt’, ‘skating’,
‘kho kho’, ‘bb’, ‘chess’, ‘football’,
“cricket”]
school=pd.Series(list1,index=list2)
school.name=(“little”)
What will be the output of
(i) print(school*2)
(ii) print(school[“tt”])

26. The Python code below contains syntax errors. Rewrite the code correctly, and underline the corrections
made.
import pandas as pd
data = (‘A’: Pd.Series([1, 2, 3]),
‘B’: Pd.Series([4, 5, 6]))
df = pd.dataframe(data)
Print(df)

27. Complete the given Python code: to read data from the CSV file ‘data.csv’ into a DataFrame and display
the first 5 rows.
import _____ as pd
df = pd.read_csv(_____)
print(df.______(_____))

28. Describe the concepts of password cracking and eavesdropping.

SECTION C
29. Write the Python code to create the above DataFrame ‘tvdf’.
LED OLED Curved
0 Samsung SONY Panorama
1 LG TOSHIBA Weston
2 BPL TATA Microsoft

30. Consider the following DataFrame dfn that contain vegetables.

Color Quantity Price
Capsicum Red 12 60
Capsicum Green 22 100
Chilli Red 50 40
Chilli Green 65 55
Lime Green 20 35
Write the code statement to the following:
(i) Find all rows with the label “Chilli”. Extract all columns.
(ii) List 2nd, 3rd and 4th rows.
(iii) List only the columns Quantity and Price using loc.
NODIA APP Sample Paper 05 Page 5

31. Based on above table Student, write the output of the following queries.

Table : Student
Roll No Name Cla-ss DOB Gen-der City Marks
1 Anand XI 06-06-1997 M Agra 430
2 Chetan XII 07-05-1994 M Mumbai 460
3 Geet XI 06-05-1997 F Agra 470
4 Priti XII 08-08-1995 F Mumbai 492
5 Saniya XII 08-10-1995 F Delhi 360
6 Neha X 08-12-1995 F Burdwan 324
7 Nishant X 12-06-1995 M Burdwan 429
(i) SELECT Name FROM Student WHERE City IN(“Agra”, “Mumbai”);
(ii) SELECT * FROM Student WHERE Gender=“F” AND Class= “XII”ORDER BY Marks;
(iii) SELECT Gender, AVG(Marks) FROM Student GROUP BY Gender HAVING Class=“XI”;


o

Table : Sales
Column Name
Store_ID
Sales_Date
Sales_Amount
Write queries to find:
(i) The amount for each store.
(ii) The list of all the store name whose total Sales amount is over 5000.
(iii) The total number of stores in the Sales table.

32. Riya discovered that her photo, posted on a social networking site, had been altered by merging it with an
unknown person’s image and then published.
(i) What should she do?
(ii) Later she found that after posting some images in social media, some people were writing negative
messages. This is an instance of.
(iii) Using someone’s Twitter handle to post something will be termed as.


o
List e-Waste hazards on environment and on human health.

SECTION D
33. A DataFrame “States” contains data as follows:

SName Covidcases
0 Punjab 2090
1 WB 1600
2 Kerala 4000
Page 6 Sample Paper 05 CBSE 12th Informatics Practices

(a) Give the output of

(i) States.loc[States.SName==
‘Punjab’]
(ii) States.tail(1)
(b) Write Python statement to write the DataFrame to CSV file covid.csv.
(c) Write Python statement to display the last state.

(Option for part (c) only)

o
Give syntax to access multiple columns of the DataFrame.

34. Based on above table WORKER, write the SQL queries for (i) to (iv).

Table : WORKER
WNO NAME DOJ DOB GENDER DCODE
1001 George K 2013-09-02 1991-09-01 MALE D01
1002 Ryma Sen 2012-12-11 1990-12-15 FEMALE D03
1003 Mohitesh 2013-02-03 1987-09-04 MALE D05
1007 Anil Jha 2014-01-17 1984-10-19 MALE D04
1004 Manila Sahai 2012-12-09 1986-11-14 FEMALE D01
1005 R SAHAY 2013-11-18 1987-03-31 MALE D02
1006 Jaya Priya 2014-06-09 1985-06-23 FEMALE D05
(i) To display WNO, NAME, GENDER from the table WORKER in descending order of WNO.
(ii) To display the NAME of all the FEMALE workers from the table WORKER.
(iii) To display the WNO and NAME of those workers from the table WORKER, who are born between
‘1987-01-01’ and ‘1991-12-01’.
(iv) To count and display MALE workers who have joined after ‘1986-01-01’.

SECTION E
35. Write the Python code to plot the graph as shown below:
NODIA APP Sample Paper 05 Page 7

o
Observe the following graph and write the Python code to get the desired graph.

36. Write SQL command for questions (i) to (v) on the basis of table Interiors.
Table : Interiors
No Item name Type Dateofstock Price Disc-ount
1 Red rose Double Bed 23/02/02 32000 15
2 Soft touch Baby Cot 20/01/02 9000 10
3 Jerry’s home Baby Cot 19/02/02 8500 10
4 Rough wood Office Table 01/01/02 20000 20
5 Comfort zone Double Bed 12/01/02 15000 20
6 Jerry look Baby Cot 24/02/02 7000 19
7 Lion king Office Table 20/02/02 16000 20
8 Royal tiger Sofa 22/02/02 30000 25
9 Park sitting Sofa 13/12/01 9000 15
10 Dine Paradise Dining Table 19/02/02 11000 15
11 White wood Double Bed 23/03/03 20000 20
12 James 007 Sofa 20/02/03 15000 15
13 Tom look Baby Cot 21/02/03 7000 10
(i) To show all information about the sofas from the Interiors table.
(ii) To list the Itemname which are priced at more than 10000 from the Interiors table.
(iii) To list Itemname and Type of those items, in which Dateofstock is be 22/01/02 from the Interiors table
in descending order of Itemname.
(iv) To display Itemname and Dateofstock of items whose discount is more than 15.
(v) To insert a new row in the table with the following data:
14, “True Indian”, “Office Table”, {28/03/03}, 15000, 20


o
Define the following terms:
(i) INSERT Command
(ii) SELECT Command
(iii) DELETE Command
(iv) DCL Command
(v) WHERE Clause
Page 8 Sample Paper 05 CBSE 12th Informatics Practices

37. Global Solutions Inc. (GSI) is a professional consultancy firm. The company plans to establish new offices
in India, with its main hub located in Hyderabad. As a network advisor, your role is to understand their
requirements and recommend the best available solutions. Their questions are listed from (i) to (v) below.

Block to block distance (in metre)

Block (From) Block (To) Distance
Human Resource Conference 110
Human Resource Finance 40
Conference Finance 80
Expected number of computers to be in each block

Block Computers
Human Resource 25
Finance 120
Conference 90
(i) Which will be the most appropriate block, where TTC should plan to install their server?
(ii) Draw a block to block cable layout to connect all the buildings in the most appropriate manner for
efficient communication.
(iii) Which of the following device will be suggested by you to connect each computer in each of the
buildings?
(a) Switch
(b) Modem
(c) Gateway
(iv) What are the advantages of networking?
(v) State the use of repeater.

******
NODIA APP Sample Paper 06 Page 1

Sample Paper 06
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

SECTION - A
1. State whether the following statement is True or False:
In a bus network topology, the failure of a single computer or node on the network will cause the entire
network to stop functioning.

2. What will be the result of the following SQL query?

SELECT MOD(17, 5);
(A) 3 (B) 3.4
(C) 2 (D) 4

3. Riya receives an email that looks like it is from her bank. The email warns of a security breach and asks
her to click a link to update her password immediately. The link directs her to a fraudulent website. This
is an example of:
(A) Cyberbullying (B) Hacking
(C) Phishing (D) Spamming

4. Which of the following commands correctly selects the row with the index label ‘Row3’ from a Pandas
DataFrame named df?
(A) df.get(‘Row3’) (B) df[‘Row3’]
(C) df.iloc[‘Row3’] (D) df.loc[‘Row3’]
Page 2 Sample Paper 06 CBSE 12th Informatics Practices

5. Which network device operates at the Physical Layer and simply broadcasts all incoming data packets to
every connected device, without any filtering?
(A) Switch (B) Router
(C) Hub (D) Gateway

6. What is the purpose of the LEFT(string, n) function in SQL?

(A) To remove n characters from the left of a string.
(B) To pad a string with n characters on the left.
(C) To extract the first n characters from a string.
(D) To find the position of a character from the left.

7. The unique shape of a company’s product packaging, which helps consumers identify the brand, can be
protected as a form of:
(A) Patent (B) Copyright
(C) Trademark (D) FOSS License

8. Which attribute of a Pandas DataFrame df returns a Series containing the data types of each column?
(A) df.types (B) df.info()
(C) df.dtypes (D) df.datatypes

9. In a relational database, a field (or a set of fields) that uniquely identifies each record in a table and cannot
contain null values is known as the:
(A) Foreign Key (B) Primary Key
(C) Unique Key (D) Alternate Key

10. What is the primary function of a web server?

(A) To provide an internet connection to a user.
(B) To render and display web pages to a user.
(C) To create and edit HTML documents.
(D) To store website files and respond to browser requests.

11. To find the smallest value in a ‘Price’ column of a ‘Products’ table, which SQL aggregate function should
be used?
(A) LEAST(Price) (B) LOW(Price)
(C) BOTTOM(Price) (D) MIN(Price)

12. Which Pandas method is used to remove duplicate rows from a DataFrame?
(A) df.delete_duplicates() (B) df.unique_rows()
(C) df.drop_duplicates() (D) df.remove_duplicates()

13. What is the term for the set of professional or social rules of conduct that are considered acceptable when
using the internet?
(A) Cyber Law (B) Digital Policy
(C) Netiquette (D) Internet Protocol
NODIA APP Sample Paper 06 Page 3

14. Which SQL command is used to modify existing data in a database table?
(A) ALTER (B) MODIFY
(C) CHANGE (D) UPDATE

15. Which of the following correctly selects rows from a DataFrame df where ‘Score’ is above 80 and ‘Attendance’
is above 90?
(A) df[df[‘Score’] > 80 and df[‘Attendance’] > 90]
(B) df[(df[‘Score’] > 80) & (df[‘Attendance’] > 90)]
(C) df[df[‘Score’] > 80, df[‘Attendance’] > 90]
(D) df.select(‘Score’ > 80 & ‘Attendance’ > 90)

16. A network topology that has a central root node connected to one or more nodes that are one level lower
is known as:
(A) Mesh Topology (B) Ring Topology
(C) Tree Topology (D) Bus Topology

17. Which SQL function is used to convert all characters in a given string to uppercase?
(A) UPPERCASE() (B) CAPITALIZE()
(C) TO_UPPER() (D) UCASE()

18. In Matplotlib, after plotting multiple lines on the same graph with different labels, which function must be
called to display the box that identifies each line?
(A) plt.key() (B) plt.legend()
(C) plt.labels() (D) plt.index()

19. Which of the following is considered a primary application of the World Wide Web?
(A) Voice over IP (VoIP) (B) Email
(C) Web Browsing (D) File Transfer Protocol (FTP)

Direction : For questions 20 and 21, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

20. Assertion (A): A Pandas Series is a homogeneous data structure.

Reason (R): This homogeneity allows for highly efficient, vectorized operations on the data, often leveraging
the performance of NumPy arrays.

21. Assertion (A): The DELETE FROM command in SQL is considered a Data Definition Language (DDL)
command.
Reason (R): The DELETE command is used to remove one or more rows from a table, which is a data
manipulation task.
Page 4 Sample Paper 06 CBSE 12th Informatics Practices

SECTION - B
22. Intellectural property right means that the person who produces the information is the only one who can
use that information. Now, explain the need of protecting intellectual property rights.

23. Rashmi is a travel agent, she has stored the data of all passengers in a table Travel(PNo, PName,TDate,Km,
Coach). She has given the following command to display the name of the traveller whose travel date is in
year 2016. She is encountering an error while executing the following query:
SELECT PName, TDate WHERE TDate= ‘2016’ FROM Travel;
Help her in identifying the reason of the error and write the correct query by suggesting the possible
correction(s).

24. Samadrita wants to find the outputs of the following queries using SUBSTR() and MOD() functions. Help
her to find the outputs.
(i) SELECT SUBSTR(“testcases”, –5, 3);
(ii) SELECT MOD(17.7, 3);

25. Complete the given Python code to concatenate the DataFrames ‘df1’ and ‘df2’ vertically and display the
resulting DataFrame.
import _____ as pd
df1 = pd.DataFrame({‘A’: [1, 2, 3,],
‘B’ : [4, 5, 6]
df2 = pd.DataFrame({‘A’: [7, 8, 9],
‘B’ : [10, 11, 12]})
result_df = pd._____(_____)
print (result_df)

26. Answer the following questions based on the Series given below
import pandas as pd
list1=[1,2,3,4,5,6,7,8]
list2=[‘swimming, ‘tt’, ‘skating’, ‘kho kho’, ‘bb’, ‘chess’, ‘football’,
‘cricket’]
school=pd.Series(list1.index=list2)
What will be the output of the following statements?
(a) print (school*2)
(b) print (school [“tt”])

27. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
import pandas as pd
data1 = {‘ID’: [1, 2, 3], ‘Name’:
[‘Riya’, ‘Preeti’, ‘Neeta’]}
data2 = [‘ID’: [3, 4, 5], ‘Age’ [22,
30, 40]}
df1 = Pd.DataFrame(data1)
df2 = Pd.DataFrame(data2)
result = Pd.merge(df1, df2, on=‘ID’,
how=inner)
print(result)
NODIA APP Sample Paper 06 Page 5

28. Define Voice over Internet Protocol (VoIP). Also, explain its one advantage.


o
Explain any two uses of the Internet.

SECTION - C
29. Write a Python code to create a DataFrame with appropriate column headings from the list given below:
[[P01, ‘Sachin Tendulkar’, ‘India’], [P02, ‘Brian Lara’, ‘West Indies’], [P03, ‘Wasim Akram’, ‘Pakistan’],[P04,
‘Adam Gilchrist’, Australia’]]

30. Consider the following table BOOK.

Table : BOOK
Code Title Author Publication Price
D001 Physics Vikas Sharma xxx 250
D002 Chemistry Preeti Goyal yyy 300
D003 Computer Science Swati Rana zzz 275
D004 English Sanjeev Jain aaa 150
D005 Mathematics Rajiv Rastogi bbb 400
Give the output of the following SQL commands on the basis of the above table BOOK.
(i) SELECT LEFT(Publication, 1) FROM BOOK WHERE Price>280;
(ii) SELECT LCASE(Author) FROM BOOK;
(iii) SELECT SUBSTR (Title, 2, 3) FROM BOOK WHERE Code = ‘D002’;

31. Consider the given table Order.

Table : Order
Ord erno Orderdate CName Cloc Orders (in `) Payments (in `)
1 12/02/2008 Avlon Delhi 100000 90000
2 21/11/2008 Parason Jaipur 230000 230000
3 15/10/2008 Trident Raipur 120000 100000
4 13/01/2008 Avlon Jaipur 240000 240000
5 17/07/2008 Trident Delhi 340000 310000
6 16/06/2008 Nalco Chennai 140000 140000
Write the SQL statements for the following based on above table Order.
(i) Display the maximum and minimum orders placed for each city.
(ii) Find the average of Payments received by Cloc Jaipur.
(iii) List all orders given between 01/01/2008 to 12/10/2008


o
Which type of DIY SQL function accepts only numeric values? What is the use of such functions? Give the
name of some functions of that type.
Page 6 Sample Paper 06 CBSE 12th Informatics Practices

32. Sumit has to prepare a project on “Swachh Bharat Shreshth Bharat”. He decides to get information from
the Internet. He downloads three web pages (webpage1, webpage2, webpage3) containing information on
the given topic.
1. He reads a paragraph from webpage1 and rephrased it in his own words. He finally pasted the rephrased
paragraph in his project.
2. He downloaded three images from webpage2. He made a collage for his project using these images.
3. He also downloaded an icon from webpage3 and pasted it on the front page of his project report.
Now, answer the following questions based on above reading.
(i) Step 1 an example of _____.
(ii) Step 3 an act of _____.
(iii) The process of getting web pages, images and files from a web server to local computer is called
_____.


o
What is cyber stalking? Is cyber stalking a crime? How cyber stalking messages are different from ordinary
spam?

SECTION - D
33. Ms. Jennifer Christiano wants to create a DataFrame “Football” and perform some operations with it.

Football
Index Player Club Charges
0 Ronaldo AC Milan 9.6
1 Pele Real Madrid 10.5
2 Maradona Royal Argentina 19.5

(Assume pandas is imported as pd)

(a) Write the output for the following:
(i) Football[‘Charges’]/2
(ii) Football.size
(b) Help her to write the code for the following:
To set the index as ‘R’, ‘P’ and ‘M’, respectively for the three rows.
(c) To change index Label of Football from 0 to Zero and 1 to One.

(Option for part (c) only)

o
To make all the charges to 11.9
NODIA APP Sample Paper 06 Page 7

34. Army hospital Patna maintains the following table for its patients . They want certain outputs department
wise - like the average charges , total number of patients department wise etc. As a database programmer,
helps them to get the required outputs.

Table : Hospital
Patld Pname Dept Charges
P01 Amit ENT 5600
P02 Sunil Eye 7000
P03 Rina Ortho 2500
P04 Akash Ortho 9000
P05 Amitabh ENT 4000
P06 Preeti Ortho 5000
(i) Display each Dept and the total number of patients in each.
(ii) Display the department wise average Charges
(iii) Display the total number of unique departments.
(iv) Display the minimum Charges among patients whose name starts with “S” or “R”.

SECTION - E
35. “Anutulya Creations”-A start-up fashion house has set up its main centre at Kanpur, Uttar Pradesh for its
dress designing, production and dress supplying activities. It has 4 blocks of buildings:

Distance between the various blocks:

A to D 50 m
A to P 60 m
A to S 110 m
D to S 60 m
P to S 50 m
P to D 150 m
Page 8 Sample Paper 06 CBSE 12th Informatics Practices

Number of computers in each block:

Block A 20
Block D 80
Block P 15
Block S 8
Based on the above specifications, answer the following questions.
(i) Out of LAN, WAN and MAN, what type of network will be formed, if we interconnect different
computers of the campus? Justify.
(ii) Suggest the topology, which should be used to efficiently connect various blocks of buildings within
Kanpur centre for fast communication.
Also, draw the cable layout for the same.
(iii) Suggest the placement of the following device with justification.
(a) Repeater
(b) Switch/Hub
(iv) Now-a-days, video-conferencing software is being used frequently by the company to discuss the product
details with the clients. Name any one video conferencing software.
Also, mention the protocol which is used internally in video conferencing software.
(v) Suggest the suitable place (BLOCK) to house the server, with a suitable reason.

36. Carefully, observe the following table named ‘Stock’.

Table : Stock
Pid PName Category Qty Price
1 Keyboard IO 15 450
2 Mouse IO 10 350
3 Wifi-router NW 5 2600
4 Switch NW 3 3000
5 Monitor O 10 4500
6 Printer O 4 17000
Write SQL queries for the following
(i) To display the records in decreasing order of Price.
(ii) To display Category and category wise total Quantities of products.
(iii) To display the Category and its average Price.
(iv) To display Category and category wise highest Price of the products.
(v) To display product names of the items with price below 200 and quantity less than 5.


o
Briefly explain the purpose of the following SQL functions.
(i) POWER()
(ii) MOD()
(iii) NOW()
(iv) MONTH()
(v) LENGTH()
NODIA APP Sample Paper 06 Page 9

37. Write a Pandas program to sort the DataFrame first by Name in descending order, then by ‘Score’ in
ascending order.
Sample DataFrame :
exam_data={‘Name’: [‘Abhi’, ‘Chirag’,
‘Tarun’, ‘Anjali’, ‘Mahi’, ‘Tushar’,
‘Shubham’, ‘Harsh’, ‘Vanshika’,
‘Kartik’]
‘Score’:[12.5,9,16.5,np.Nan,9,20,
14.5,np.NaN,8,19],
‘Attempts’:[1,3,2,3,2,3,1,1,2,1],
‘Qualify’ : [‘Yes’, ‘No’, ‘Yes’, ‘No’, ‘No’, ‘Yes’, ‘Yes’, ‘No’, ‘No’, ‘Yes’]}
labels = [‘a’, ‘b’, ‘c’, ‘d’, ‘e’,
‘f’, ‘g’, ‘h’, ‘i’, ‘j’]


o
Python provides the facility to draw multiple bar charts in same plot. Shrey used this feature and made
multiple bar charts in same plot but by mistake the code of graph has deleted. Now, help him to write the
code of given graph.

******
NODIA APP Sample Paper 07 Page 1

Sample Paper 07
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

SECTION - A
1. State whether the following statement is True or False:
The UPDATE command in SQL is used to add one or more new rows to a table.

2. What will be the result of the following SQL query?

SELECT ROUND(78.987, 1);
(A) 78.9 (B) 79.0
(C) 79 (D) 78.99

3. An aspiring musician writes an original song and uploads it to a video-sharing platform. A large corporation
uses this song in their television advertisement without seeking her permission. This is a clear violation of
her:
(A) Patent (B) Trademark
(C) Copyright (D) Digital Footprint

4. Given data = [100, 200, 300] and idx = [‘X’, ‘Y’, ‘Z’], which command correctly creates a Pandas Series with
data as values and idx as the index?
(A) pd.Series(data=[idx], index=[data]) (B) pd.Series(data, idx)
(C) pd.Series(data, index=idx) (D) pd.Series({idx: data})
Page 2 Sample Paper 07 CBSE Science Class 10

5. Which network device is responsible for directing data packets between different computer networks by
examining their IP addresses?
(A) Hub (B) Switch
(C) Router (D) Repeater

6. What is the purpose of the MONTH(date) function in SQL?

(A) To return the full name of the month (e.g., ‘January’).
(B) To return the month as a numeric value (1-12).
(C) To return the number of days in that month.
(D) To return the last date of that month.

7. Software that is released under a license that grants users the rights to run, study, change, and distribute
the software and its source code for any purpose is called:
(A) Shareware (B) Freeware
(C) Proprietary Software (D) Free and Open Source Software (FOSS)

8. Which attribute of a Pandas DataFrame returns the total number of elements in it (i.e., rows multiplied by
columns)?
(A) df.shape (B) df.len
(C) df.count() (D) df.size

9. In SQL, a join that links tables based on an equality condition between the values in the common columns
is known as a(n):
(A) Cross Join (B) Equi-Join
(C) Self Join (D) Natural Join

10. In the URL http://www.example.org/index.html, what does the http part represent?
(A) The Domain Name (B) The File Path
(C) The Protocol (D) The Hostname

11. To calculate the class average on a test from a ‘Students’ table with a ‘Marks’ column, which SQL aggregate
function would you use?
(A) MEDIAN(Marks) (B) AVERAGE(Marks)
(C) AVG(Marks) (D) MEAN(Marks)

12. To convert all strings in a Pandas Series s to uppercase, which method would be most appropriate?
(A) s.str.upper() (B) s.upper()
(C) s.apply(upper) (D) s.map(‘upper’)

13. Which of the following is the most environmentally responsible method for disposing of an old, non-
functional laptop?
(A) Throwing it in the regular garbage bin.
(B) Selling it to a local scrap dealer.
(C) Sending it to a certified e-waste recycling facility.
(D) Storing it in the attic indefinitely.
NODIA APP Sample Paper 07 Page 3

14. Which SQL command is used to remove existing records from a table?
(A) DROP (B) REMOVE
(C) DELETE (D) ERASE

15. How do you display the first 10 rows of a Pandas DataFrame df?
(A) df.first(10) (B) df.loc[:9]
(C) df.head(10) (D) df.top(10)

16. In which network topology is each device connected to exactly two other devices, forming a circular pathway
for data?
(A) Star (B) Ring
(C) Bus (D) Mesh

17. Which SQL function is used to remove spaces from the beginning (left side) of a string?
(A) TRIM() (B) RTRIM()
(C) LTRIM() (D) STRIP()

18. To represent the trend of a company’s sales revenue over the past five years, which type of plot would be
most effective?
(A) Bar Graph (B) Histogram
(C) Line Plot (D) Scatter Plot

19. The unauthorized reproduction and distribution of copyrighted material like software, music, or films is
commonly known as:
(A) Plagiarism (B) Hacking
(C) Phishing (D) Piracy

Direction : For questions 20 and 21, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

20. Assertion (A): When adding two Pandas Series that have non-overlapping indices, the result contains NaN
values.
Reason (R): Pandas aligns data by index labels before performing arithmetic operations, and for any label
not present in both Series, the result is considered missing (NaN).

21. Assertion (A): A switch is a more efficient network device than a hub.
Reason (R): A switch forwards data packets to all connected devices, whereas a hub sends packets only to
the specific intended recipient.
Page 4 Sample Paper 07 CBSE Science Class 10

SECTION - B
22. Complete the given Python code: Create a pandas Series from a scalar value ‘10’ and display the last 3
elements of the Series.
import ______ as pd
series_data = pd.Series(_____)
print(series_data._____(_____))

23. What is data protection? List two ways to protect your data.

24. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
import pandas as pd
data = {Name [‘Riya’, ‘Preeti’,
‘Neeta’], ‘Age’: [25, 30, 22]}
df = pd.DataFrame(Data)
for row in df:
print(row)

25. What will be the output of the given code?

import pandas as pd
s = pd.Series([1,2,3,4,5],
index=[‘akram’, ‘brijesh’, ‘charu’,
‘deepika’, ‘era’])
print(s[‘charu’])

26. Mr. Roy is a manager in a hotel and wants to find out some data from a table, where he maintains the hotel
records. He is not very expert with SQL commands and functions. Help him to write the queries.

Table : Hotel
Roomld CName RoomType DtofArrival Charges
R1 Ritesh AC 2016-09-09 1800
R2 Suman Deluxe 2020-08-01 2000
R3 Abhi General 1995-04-05 3000
R4 Ram AC 1994-02-02 2500
R5 Nitin Deluxe NULL 7000
(i) Display count of the different room types from the table Hotel.
(ii) Display the average room charges of “AC” rooms.

27. Navya has just created a website for her company and now need to host it. Briefly discuss the role of a web
server in hosting a website.


o
Write one advantage each of star and bus topology used in networking. Draw a network layout of bus
topology to connect six computers.

28. What is the purpose of GROUP BY clause in MySQL? How is it different from ORDER BY clause?
NODIA APP Sample Paper 07 Page 5

SECTION - C
29. Rahul has written a code with a DataFrame and a CSV file “Emp.csv” containing records of employees as
follows:

Index Eno Ename Eage Esal

0 1 Ritesh 15 5600
1 2 Aakash 16 17000
2 3 Sumit 17 12500
3 4 Ria 20 18000
Write the Python code to read the data from the CSV file, display its first two records and then rewrite the
data to a new CSV file.

30. Consider the following table Games. Write SQL commands for the following statements.

Table : Games
G Code Game Name Type Num-ber Prize Money Schedule Date
101 Carom Board Indoor 2 5000 23/01/2004
102 Badminton Outdoor 2 12000 12/12/2003
103 Table Tennis Indoor 4 8000 14/02/2004
105 Chess Indoor 2 9000 01/01/2004
108 Lawn Tennis Outdoor 4 25000 19/03/2004
(i) To display the details of those Games, which are having Prize Money more than 7000.
(ii) To display sum of Prize Money for each Type of Games.
(iii) To display the total number of games available in the above table Games.

o
Naina works for M/s Anish Steels Ltd. She has written following statements , but is not able to understand
the outputs. Explain her the working of these statements and produce the outputs.
(i) SELECT INSTR(‘computerscience’, ‘sc’);
(ii) SELECT MID(‘funandfood’, 3, 4);
(iii) SELECT ROUND(1334.99);

31. List the guidelines to avoid plagiarism.

o
What are the psychological problems related to the usage of technology?
Page 6 Sample Paper 07 CBSE Science Class 10

32. Write a output for SQL queries (i) to (iii), which are based on the table Student given below:

Table : Student
Roll No Name Class DOB Gender City Marks
1 Nanda X 06-06-1995 M Agra 551
2 Saurabh XII 07-05-1993 M Mumbai 462
3 Sonal XI 06-05-1994 F Delhi 400
4 Trisla XII 08-08-1995 F Mumbai 450
5 Sohan XII 08-10-1995 M Delhi 369
6 Marisla XI 12-12-1994 F Dubai 250
7 Neha X 08-12-1995 F Moscow 377
8 Nishant X 12-06-1995 M Moscow 489
(i) SELECT COUNT(*), City FROM Student GROUP BY City HAVING COUNT(*)>1;
(ii) SELECT MAX(DOB),MIN(DOB) FROM Student;
(iii) SELECT NAME,GENDER FROM Student WHERE City= “Delhi”;

SECTION - D
33. Jacqueline has created the following DataFrame consisting of data of houses of a school and the number of
boys in the houses, shown as follows. She wants to perform certain operation on the data set. Help her with
the correct actions.

House
Index Housename Location Boys
0 Ganga East 20
1 Yamuna West 30
2 Saraswati North 56
(a) What will be the output of the following code?
(i) print(House.shape)
(ii) House.pop(“Location”)
print(House)
(b) She wants the “Housename” column to be the index of the DataFrame. What statement she should
write?
(c) To display total number of elements in the dataframe.

(Option for part (c) only)

o
She wants to see the number of columns. Write the statement which will display the number of columns.
NODIA APP Sample Paper 07 Page 7

34. Consider the table given below and answer the questions
Table : EMP
EMP NO ENAME SEX DOB DOJ DEPT CODE
101 Ram M 1990-05-02 2012-01-02 D01
102 Aman M 1992-03-01 2013-02-04 D03
103 Diya F 1989-01-04 2011-01-06 D04
106 Sandeep M 1993-04-06 2015-01-03 D02
105 Varun M 1995-07-08 2014-02-04 D05
107 Komal F 1994-03-02 2013-03-06 D01
104 Priyanka F 1995-02-01 2012-02-07 D01
(i) To display EMPNO, ENAME, SEX from the table EMP in descending order of EMPNO
(ii) To display the records of all female employee from the table EMP.
(iii) To display the EMPNO and ENAME of those employees from the table EMP who are joined between
‘2011-01-01’ and ‘2013-01-01’.
(iv) To count the number of male employees who have born before ‘1994-01-01’.

SECTION - E
35. Write the Python code for the following graph which display the different style multiline in same plot.

o
Observe the below figure and write the Python code to get the output.
Page 8 Sample Paper 07 CBSE Science Class 10

36. Given below a table Bookhouse, write SQL query for part (i) to (v).

Table : Bookhouse
No Title Author Subject Publisher Qty Price
1 Data Structure Lips chute DS McGraw 4 217.00

2 DOS Guide Nortron OS PHI 3 175.00

3 Turbo C++ Robort Lafore Prog Galgotia 5 270.00
4 Dbase Dummies Palmer DBMS PustakM 7 130.00
5 Mastering Windows Cowart OS BPB 1 225.00

6 Computer Studies French FND Galgotia 2 75.00

7 COBOL Stern Prog John W 4 1000.00
8 Guide Network Freed NET Zpress 3 200.00
9 Basic for Beginners Norton Prog BPB 3 40.00
10 Advanced Pascal Schildt Prog McGraw 4 350.00
(i) Display Publisher wise total stock value (Qty Price).
(ii) Display Title of the book which is costliest.
(iii) Display number of books and total Price for each type of Publisher.
(iv) Display all the books where subject starts with “D” and Qty is less than 3.
(v) Display all information of books whose Price starts with 2.


o
Write the uses of following MySQL functions with one example of each.
(i) MID
(ii) LEFT( )
(iii) TRIM()
(iv) LCASE()
(v) MAX()

37. China Middleton Fashion is planning to expand their network in India, starting with two cities to provide
infrastructure for distribution of their products.
The company has planned to setup their main office in Chennai at three different locations and have named
their offices as Production Unit, Finance Unit and Media Unit. The company has its Corporate Unit in
Delhi.
A rough layout of the same is as follows:
NODIA APP Sample Paper 07 Page 9

Approximate distance between these units is as follows:

From To Distance
Production Unit Finance Unit 70 m
Production Unit Media Unit 15 m
Production Unit Corporate Unit 2112 m
Finance Unit Media Unit 15 m
In continuation of the above, the company experts have planned to install the following number of computers
in each of these units.

To Distance
Production Unit 150
Finance Unit 35
Media Unit 10
Corporate Unit 30
(i) Suggest the kind of network required (out of LAN, MAN, WAN) for each of the following units.
(a) Production Unit and Media Unit
(b) Production Unit and Finance Unit
(ii) Which of the following devices will you suggest for connecting all computers with each of their office
units?
(a) Switch/Hub
(b) Modem
(c) Telephone
(iii) Suggest a cable/wiring layout for connecting the company’s local office units located in Chennai.
(iv) After setting up the lab and Internet in the lab, company now requires to enable videos and animations
to be played on the web browser for it’s employees. Which browser tool /service can be used for the
same?
(v) Give an example of Open Source web browser.

******
NODIA APP Sample Paper 08 Page 1

Sample Paper 08
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

SECTION - A
1. State whether the following statement is True or False:
A single Pandas DataFrame can contain columns with different data types, such as integers, strings, and
floats.

2. What will be the result of the following SQL query?

SELECT INSTR(‘DkATA WAREHOUSE’, ‘WARE’);
(A) 0 (B) 4
(C) 5 (D) 6

3. Kavita develops a new mobile application. To legally protect her creation and prevent others from copying
or selling it, she should rely on which of the following?
(A) Cyber Laws (B) Copyright Laws
(C) Netiquette (D) Data Protection Laws

4. Which of the following Python commands is the correct way to create an empty Pandas DataFrame?
(Assume pandas is imported as pd)
(A) df = pd.DataFrame() (B) df = pd.create_df()
(C) df = pd.DataFrame.new() (D) df = pd.EmptyFrame()
Page 2 Sample Paper 08 CBSE 12th Informatics Practices

5. To connect a computer to the internet using a standard telephone line, which hardware device is essential
for signal conversion?
(A) Router (B) Switch
(C) Hub (D) Modem

6. What is the primary purpose of the RTRIM() function in SQL?

(A) To remove all spaces from a string.
(B) To remove leading (left-side) spaces from a string.
(C) To remove trailing (right-side) spaces from a string.
(D) To replace all spaces within a string.

7. A pharmaceutical company develops a new, unique, and useful drug. To get exclusive rights to manufacture
and sell this invention for a specific period, the company must file for a:
(A) Copyright (B) Patent
(C) Trademark (D) Trade Secret

8. Which attribute of a Pandas DataFrame df is used to access the list of its column labels?
(A) df.headers (B) df.keys()
(C) df.columns (D) df.fields

9. In an SQL query, which clause is required to filter results based on a condition involving an aggregate
function like COUNT() or SUM()?
(A) WHERE (B) HAVING
(C) FILTER BY (D) CONDITION

10. Which of the following is a client-side software application used to access and display content from the
World Wide Web?
(A) Web Server (B) Web Browser
(C) Web Host (D) Search Engine

11. A table Employees has 50 rows. The column Commission has 5 NULL values. What will be the output of
SELECT COUNT(Commission) FROM Employees;?
(A) 50 (B) 45
(C) 5 (D) 0

12. Which Pandas method is used to change the DataFrame’s index to one of its existing columns?
(A) df.reindex() (B) df.set_index()
(C) df.index_col() (D) df.change_index()

13. When you voluntarily post a photo on a social media platform, you are directly contributing to your:
(A) Passive digital footprint (B) Active digital footprint
(C) Digital security (D) Data privacy

14. To add a new record (row) to a table named Students, which SQL command should be used?
(A) ADD ROW INTO Students... (B) INSERT INTO Students...
(C) CREATE RECORD IN Students... (D) NEW ROW FOR Students...
NODIA APP Sample Paper 08 Page 3

15. How can you view the last 5 rows of a Pandas DataFrame named df?
(A) df.last(5) (B) df.loc[-5:]
(C) df.bottom(5) (D) df.tail()

16. A large multinational corporation connects its offices in New York, London, and Tokyo using a dedicated
network. This type of network is classified as a:
(A) LAN (Local Area Network) (B) PAN (Personal Area Network)
(C) WAN (Wide Area Network) (D) MAN (Metropolitan Area Network)

17. Which SQL function is used to return the name of the weekday (e.g., ‘Monday’) from a date?
(A) DAY() (B) DAYNAME()
(C) WEEKDAY() (D) GETDAY()

18. After generating a plot with Matplotlib (imported as plt), which command will save the figure to a file
named my_plot.png?
(A) plt.save(‘my_plot.png’) (B) plt.write_image(‘my_plot.png’)
(C) plt.export(‘my_plot.png’) (D) plt.savefig(‘my_plot.png’)

19. What is the full form of the acronym LAN?

(A) Large Area Network (B) Land Access Network
(C) Local Area Network (D) Logical Access Network

Direction : For questions 19 and 20, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

20. Assertion (A): The .plot() method can be called directly on a Pandas DataFrame to create various types
of graphs.
Reason (R): The plotting functionality in Pandas is a convenient wrapper around the Matplotlib library.

21. Assertion (A): E-waste is harmless and can be safely disposed of in landfills along with regular municipal
waste.
Reason (R): Electronic waste contains toxic heavy metals like lead, mercury, and cadmium, which can leach
into the soil and groundwater, causing severe pollution.

SECTION - B
22. Given a Data Frame created as:
import pandas as p
Stud=p.Series({‘Name’:[‘Ria’,
‘Priya’, ‘Jack’], ‘Eco’:[56,67,89],
‘IP’:[90,87,45], ‘Eng’:[58,78,32]})
Studdf=p.Data Frame(Stud)
print(Studdf[0:2])
What will be the output of the above code?
Page 4 Sample Paper 08 CBSE 12th Informatics Practices

23. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
import pandas as pd
data1 = {ID [1, 2, 3], Name [Riya,
Preeti, Neeta]}
data2 = {ID [4, 5, 6], Name [Siya,
Pratik, Neeraj]}
df1 = pd.DataFrame(data1)
df2 = pd.DataFrame(data2)
result = pd.concat(df1, df2)
print()

24. Complete the given Python code to calculate the mean value of the ‘price’ column in the DataFrame ‘df’.
import _____ as pd
df = pd.DataFrame(‘item’ : [‘A’, ‘B’,
‘C’, ‘D’], ‘price’: [50, 30,
45, 20]})
mean_price = df[‘price’]_____()
print(mean_price)

25. Which SQL function is used to remove leading and trailing spaces from a character expression X, where X
= ‘LEARNING ###MYSQL####’ (# denotes a blank space) and also give the output of X.

26. Which type of MySQL function accepts only numeric values? Give the name of some functions of that type.

27. What do you mean by spyware?

28. What do you mean by network topology? Write different types of topology.


o
Mr. Chandervardhan is not able to identify the domain name in the given URL. Identify and write it for
him. Also, explain what is URL?
http://www.cbsenic.in/aboutus.htm.

SECTION - C
29.

Year Month Passengers

0 2010 Jan 25
1 2010 Mar 50
2 2012 Jan 35
3 2010 Dec 55
4 2012 Dec 65

Write the code to create the above Data Frame:

NODIA APP Sample Paper 08 Page 5

30. Abhishek uses computer and mobile for his personal use. Study the following cases and answer the questions
given below.
(a) Once he got the message in Whatsapp that CBSE is announcing the result of class XII tomorrow
at 12:00 pm. He forwarded the message to his few friends. But later, he came to know that no such
announcement was there in CBSE official website. In this case, he violated_____.
(b) He is getting abuse messages from an unknown number due to which he is thinking of quarreling with
that person. The unknown person can be called as _____.
(c) He registered himself in one website by giving his email id and phone number he is leaving _____.


o
Write some symptoms of a malware attack.

31. Consider the following DataFrame df :

Code Name Price Qty Discount

0 C1 ABC 5500 10 10
1 C2 XYZ 4500 8 5
2 C3 PQR 5200 12 8
3 C4 MNO 3000 9 15
4 C5 LMN 5500 11 12
(i) Write down the command that will give the following output.

Code C1
Name ABC
Price 3000
Qty 8
Discount 5
dtype : object
(ii) Find the most repeat value of a given set of number of DataFrame.
(iii) To sort the index label of DataFrame df in descending order.

32. Mr. Manav, a database administrator in “Global Educational and Training Institute” has created following
table named “Training” for the upcoming training schedule:

Table : Training
Training_Id Name Email Id Topic City Fee
ND01 Mr. Rajan raj@gmail. corn Cyber Security New Delhi 10000
GU01 Ms. Urvashi urv@yahoo.com ICT in Education Gurugram 15000
FD01 Ms. Neena neenarediff.com Cyber Security Faridabad 12000
ND02 Mr. Vinay NULL ICT in Education New Delhi 13000
GU02 Mr. Naveen nav@gmail.com Cyber Security Gurugram NULL

Predict the output of the following queries:

(i) SELECT SUBSTR(City, 2, 4) FROM Training WHERE Topic!= ‘Cyber Security’;
(ii) SELECT NAME FROM Training WHERE INSTR (Email_Id, ‘@’)=0;
(iii) SELECT Topic , COUNT(*) FROM Training GROUP BY Topic;
Page 6 Sample Paper 08 CBSE 12th Informatics Practices

o
Shanya Kumar is working with the following table Customers:

Table : Customers
CNO CNAME CITIES
C1 SANYAM DELHI
C2 SHRUTI DELHI
C3 MEHER MUMBAI
C4 SAKSHI CHENNAI
C5 RITESH INDORE
C6 RAHUL DELHI
C7 AMEER CHENNAI
C8 MINAKSHI BANGLORE
C9 ANSHUL MUMBAI
Write the queries for the following:
(i) To display the city names in lower case letter whose CNO is either C5 or C9.
(ii) To display the length of Customer’s name for those Customers whose NAME end with R or L.
(iii) To display the Customer’s name and their respective CITIES merged together for all the Customers
whose CNO is ending with 8.

SECTION - D
33. Consider the following table named “Product”, showing details of products being sold in a grocery shop.

Table : Product
PCode PName UPrice Manufacture
P01 Washing Powder 120 Surf
P02 Tooth Paste 54 Colgate
P03 Soap 25 Lux
P04 Tooth Paste 65 Pepsodent
P05 Soap 38 Dove
P06 Shampoo 245 Dove
Write SQL queries for the following and output(s) produced by executing the following queries on the basis
of the information given above in the table Product.
(i) Create the table Product with appropriate data types and constraints.
(ii) Identify the PRIMARY KEY in table Product.
(iii) List the Product Code, product Name and Price in with their Product Name for all Dove Manufacture.
(iv) Increase the Price by 12 per.cent for all the products manufactured by Dove.
NODIA APP Sample Paper 08 Page 7

34. Mr. Krishnamurthy, who is a new user of Python Pandas, has created the following Series “Electrical”
carrying names of electrical appliances as values and their wattage as the index. He wants to perform certain
operations on the Series . You are supposed to help him in writing the commands :
Electrical

Index Name

12W LED

200W Fan
1000W Electric Iron

1200W Rice Cooker

(i) He wants to change the index of Electrical series “LED” element to “A”.
(ii) To display the record of ‘Fan”.
(iii) Remove dataset with index 1000 W.

(Option for part (iii) only)

o
Display the last rows of the dataset.

SECTION - E
35. Consider the following graph. Write the code to plot it.

o
Draw the following bar graph representing the quantity of items in each month.
Page 8 Sample Paper 08 CBSE 12th Informatics Practices

36. Consider the following table Graduate and write SQL commands for (i) to (v).

Table : Graduate
SNo Name Stipend Subject Average Div
1 Karan 400 Physics 68 1
2 Divakar 450 Computers 68 1
3 Divya 300 Chemistry 62 2
4 Arun 350 Physics 63 1
5 Sabina 500 Mathematics 70 1
6 John 400 Chemistry 55 2
7 Robert 250 Physics 64 1
8 Rubina 450 Mathematics 68 1
9 Vikas 500 Computers 62 1
10 Mohan 300 Mathematics 57 2
(i) List the Names of those students who obtained Div 1.
(ii) Display a report, listing Name, Stipend, Subject and amount of stipend received in a year assuming that
the Stipend is paid every month.
(iii) Display first three characters of student Name where/whose SNo is 7.
(iv) Display the student Names having 2nd division.
(v) Display division wise Name of students in alphabetical order.


o
Write SQL queries for the questions from (i) to (v) on the basis of table Class.

No Name Stipend Subject AvgMark Grade

01 Vikas 1200 Medical 67 B
02 Boby 1400 Humanities 78.4 B
03 Tarun 1000 Medical 64.8 C
04 Varun 1600 Non-medical 84 A
05 Atul 1800 Non-medical 92 A
(i) Select all the non-medical stream students from the table Class.
(ii) Arrange the records of Class name wise.
(iii) List the records whose grade is B or C.
(iv) Insert the new row with the following data. (06, ‘Jack’, 2800, ‘Humanities’, 98, ‘A’)
(v) Identify the attribute to be best suitable for primary key.
NODIA APP Sample Paper 08 Page 9

37. A company in Mega Enterprises has 4 wings of buildings as shown in the diagram :

Centre to centre distances between various buildings:

W3 to W1 – 50m
W1 to W2 – 60m
W2 to W4 – 25m
W4 to W3 – 170 m
W3 to W2 – 125 m
W1 to W4 – 90 m
Number of computers in each of the wing:

W1 – 150
W2 – 15
W3 – 15
W4 – 25
Computers in each wing are networked but wings are not networked. The company has now decided to
connect the wings also.
(i) Suggest a most suitable cable layout for the above connections.
(ii) Suggest the most appropriate topology of the connection between the wings.
(iii) Suggest the placement of the following devices with justification, if the company wants minimised
network traffic.
(a) Repeater
(b) Hub/Switch
(iv) Expand the following terms:
(a) HTTP
(b) TCP/IP
(v) Suggest the suitable wing to house the server.

******
NODIA APP Sample Paper 09 Page 1

Sample Paper 09
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

SECTION - A
1. State whether the following statement is True or False:
Freeware and Free and Open Source Software (FOSS) refer to the same type of software license.

2. What will be the result of the following SQL query?

SELECT LEFT(‘DATABASE’, 4);
(A) BASE (B) DATA
(C) ABAS (D) TABA

3. On a public online forum, a user intentionally posts provocative and off-topic comments to disrupt the
conversation and upset other members. This behavior is a poor example of:
(A) Data Protection (B) Netiquette
(C) Copyright (D) Plagiarism

4. Which attribute of a Pandas DataFrame df is used to get a tuple representing its dimensions (rows,
columns)?
(A) df.size (B) df.shape
(C) df.axes (D) df.len
Page 2 Sample Paper 09 CBSE 12th Informatics Practices

5. In a Local Area Network (LAN), which device intelligently forwards data packets to their specific destination
ports based on the MAC addresses of the connected devices?
(A) Hub (B) Switch
(C) Repeater (D) Modem

6. What is the primary function of the YEAR(date) function in SQL?

(A) To get the current system year.
(B) To extract the year component from a date value.
(C) To format a date to display only the year.
(D) To add a number of years to a given date.

7. A company creates a unique and recognizable symbol to represent its brand. To legally protect this symbol
from being used by competitors, the company should register it as a:
(A) Patent (B) Copyright
(C) Trademark (D) FOSS License

8. Which attribute is used to access the row labels (index) of a Pandas DataFrame df?
(A) df.rows (B) df.index
(C) df.labels (D) df.row_index

9. Which of the following SQL commands is a part of the Data Definition Language (DDL)?
(A) SELECT (B) INSERT
(C) UPDATE (D) ALTER

10. A web page that retrieves information from a database and displays customized content for different users
is known as a:
(A) Static Web Page (B) Hosted Web Page
(C) Dynamic Web Page (D) Cached Web Page

11. To find the total number of records in a table named Employees, which SQL query is most appropriate?
(A) SELECT SUM() FROM Employees;
(B) SELECT TOTAL(Employees) FROM Employees;
(C) SELECT LENGTH(Employees) FROM Employees;
(D) SELECT COUNT() FROM Employees;

12. Which of the following commands correctly removes the row with the index label ‘Row_5’ from a DataFrame
df?
(A) df.delete(‘Row_5’, axis=0) (B) df.remove(‘Row_5’, axis=0)
(C) df.drop(‘Row_5’, axis=0) (D) df.erase(‘Row_5’)

13. A student copies a paragraph from a website and includes it in his project report without using quotation
marks or citing the source. This is a clear example of:
(A) Hacking (B) Phishing
(C) Plagiarism (D) Cyberbullying
NODIA APP Sample Paper 09 Page 3

14. How would you sort the data in a Products table based on Price from highest to lowest?
(A) ORDER BY Price; (B) SORT BY Price DESC;
(C) ORDER BY Price HIGHEST; (D) ORDER BY Price DESC;

15. How do you access the specific element located at the third row (integer position 2) and second column
(integer position 1) in a DataFrame df?
(A) df.loc[2, 1] (B) df.get(2, 1)
(C) df.iloc[3, 2] (D) df.iloc[2, 1]

16. Which network topology provides the highest level of reliability and redundancy by connecting every node
to every other node?
(A) Star (B) Bus
(C) Ring (D) Mesh

17. Which SQL function is used to return the full name of a month (e.g., ‘September’) from a date value?
(A) MONTH() (B) MONTHNAME()
(C) GETMONTHNAME() (D) NAMEMONTH()

18. To add a descriptive heading at the top of a Matplotlib chart, which function is used?
(A) plt.header() (B) plt.label()
(C) plt.title() (D) plt.caption()

19. Sending a large volume of unsolicited bulk emails, often for commercial advertising, is known as:
(A) Phishing (B) Spamming
(C) Hacking (D) Trolling

Direction : For questions 20 and 21, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

20. Assertion (A): The DROP TABLE command in SQL should be used with extreme caution.
Reason (R): DROP TABLE is a DDL command that permanently deletes the table’s structure, all its data,
and associated objects like indexes, making it irreversible.

21. Assertion (A): A Pandas Series can be created from a standard Python dictionary.
Reason (R): When creating a Series from a dictionary, the dictionary’s values become the index of the
Series, and its keys become the data.
Page 4 Sample Paper 09 CBSE 12th Informatics Practices

SECTION - B
22. For avoiding the plagiarism, what guidelines should we follow?

23. Identify the following devices

(i) An intelligent device that connects several nodes to form a network and redirects the received information
only to intended node(s).
(ii) A device that regenerates (amplifies) the received signal and re-transmits it to its destinations.


o
What is a modem?

24. Write a query to display the Sum, Average, Highest and Lowest marks of the students grouped by subject
and sub-grouped by class.

25. Prachi has given the following command to obtain the highest marks:
SELECT MAX(Marks) FROM Student WHERE GROUP BY Class;
But she is not getting the desired result. Help her by writing the correct command.

26. Given a DataFrame gradedf:

import pandas as pd
gradedf=pd.DataFrame({‘Name’:[‘Rashmi’, ‘Ani’,
‘Sunil’, ‘Becker’], ‘Grade’ : [‘A’,
‘B’, ‘C’, ‘D’]})
print (gradedf.iloc[0 : 2])
Find the output.

27. Complete the given Python code: to rename the column Age to Years in the DataFrame df and display the
updated DataFrame.
import _____ as pd
df = pd.DataFrame({‘Name’: [‘John’,
‘Alice’, ‘Bob’], ‘Age’: [25, 30,
22]})
df._____(columns={‘Age’:_____})
print(df)

28. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
import pandas as Pd
data = {Name [‘Alice’, ‘Bob’,
‘Charlie’], Age [25, 30, 22]}
df = pd.DataFrame(Data)
df[‘Country’] = [‘USA’, ‘Canada’,
‘UK’]
print(df)
NODIA APP Sample Paper 09 Page 5

SECTION - C
29. Given a DataFrame “Cellphone” containing the following data:
Index ModelNo Type Brand
0 A22 4G Samsung
1 N95 3G Nokia
2 XPS12 2G Apple
Write the Python statements to do the following:
(i) To remove the first row
(ii) The command that changes the Brand column to values [‘Realme’, ‘Xiomi’, ‘Samsung’]
(iii) To save the dataframe to a CSV file “Mobiles.csv”

30. (i) Write a query to display current date on your system.

(ii) Display the position of occurrence of string “OR” in the string “CORPORATE LAWYER”
(iii) Mrs. Kumar is using table Students with the following columns:
Rno,AdmNo,Name,Aggregate, display all information of students in descending order of name and with
ascending order of aggregate.


o
Which commands are used to control user’s privileges and how?

31. Predict the output of the following.

(i) SELECT POW(INSTR(“Success@dedication”, “@”), 2);
(ii) SELECT MONTH(“2020-11-15”)*POW(2, 3);
(iii) LTRIM(“ Python Basics ”)

32. Jack received a phone call stating that the call was from his Bank and they asked him his ATM card and
PIN number. Also his colleague Jennifer was trying to see his key locations of fingers on the keyboard, while
he was trying to open his E-mail account.
(i) What this call may be _____?
(ii) What is the symbol © used for ?
(iii) What kind of network threat is Jennifer trying to do?


o
List the advantages of recycling the e-Waste.

SECTION - D
33. Given the following code, where a series is created storing population of some cities:
import pandas as pd
popseries=pd.Series([34567,890,450,
678,900])
(a) What will be the output of following commands?
(i) print(popseries.tail(3).head(2))
(ii) print(popseries/2)
(b) Write the Python statement to display the elements of dataset with value above 500.
(c) Write Python statement for the required output (5,)

(Option for part (c) only)

o
Write Python statement to assign index to the series as 11,12,13,14,15.
Page 6 Sample Paper 09 CBSE 12th Informatics Practices

34. Consider the following table MASTER.

Table : MASTER
SNo Name Age Department Salary
1 Shyam 21 Computer 12000
2 Shiv 25 Maths 15000
3 Rakesh 31 Hindi 14000
4 Sharmila 32 History 20000
5 Dushyant 25 Software 30000
(i) Write a command to update the salary of the employee to 40000, whose SNo is 3.
(ii) Write a query to add a column Date_of_ Joining to the table MASTER.
(iii) Write a query to display Age and Department of those employees whose salary is greater than 12000.
(iv) Write a query to display Name whose Salary is more than 15000 and Department is Computer.

SECTION - E
35. Given the following bar graph, write the Python code to display same as.

o
Write the code to plot the below chart.
NODIA APP Sample Paper 09 Page 7

36. Write SQL queries for the questions from (i) to (v) on the basis of table Class.

Table : Class
No Name Stipend Subject AvgMark Grade
01 Vikas 1200 Medical 67 B
02 Boby 1400 Humanities 78.4 B
03 Tarun 1000 Medical 64.8 C
04 Varun 1600 Non-medical 84 A
05 Atul 1800 Non-medical 92 A
(i) Select all the non-medical stream students from the table Class.
(ii) Arrange the records of Class name wise.
(iii) List the records whose grade is B or C.
(iv) Insert the new row with the following data. (06, ‘Jack’, 2800, ‘Humanities’, 98, ‘A’)
(v) Identify the attribute to be best suitable for primary key.


o
Name 5 major string functions with their purpose.

37. Granuda consultants are setting up a secured network for their office campus at Faridabad for their day-
to-day office and web based activities. They are planning to have connectivity between 3 buildings and the
head office situated in Kolkata.
Answer the questions (i) to (v) after going through the building positions in the campus and other details,
which are given below.

Distance between various buildings

Building RAVI to Building JAMUNA 120 m
Building RAVI to Building GANGA 50 m
Building GANGA to Building JAMUNA 65 m
Faridabad Campus to Head Office 1460 km

Number of computers
Building RAVI 25
Building JAMUNA 150
Building GANGA 51
Head Office 10
(i) Suggest the most suitable place (i.e. Building) to house the server of this organisation. Also, give a
reason to justify your suggested location.
(ii) Suggest a cable layout of connections between the building inside the campus.
(iii) Suggest the placement of the following devices with justification
(a) Switch
(b) Repeater
(iv) Consultancy is planning to connect its office in Faridabad which is more than 10 km from head office.
Which type of network will be formed?
(v) State the use of HUB?

******
NODIA APP Sample Paper 10 Page 1

Sample Paper 10
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

SECTION - A
1. State whether the following statement is True or False:
A column designated as the Primary Key in a SQL table is allowed to contain NULL values.

2. What will be the result of the following SQL query?

SELECT POWER(3, 4);
(A) 12 (B) 27
(C) 64 (D) 81

3. When an old computer or mobile phone is thrown into the regular garbage, it becomes part of a hazardous
waste stream. This type of waste is specifically known as:
(A) Digital Debris (B) E-waste
(C) Technotrash (D) Cyber Waste

4. Which attribute should be used on a Pandas DataFrame df to check the data type of each of its columns?
(A) df.types (B) df.info()
(C) df.get_types() (D) df.dtypes

5. To amplify a weak network signal and extend the range of a LAN or Wi-Fi network, which device should
be installed?
(A) Router (B) Switch
(C) Repeater (D) Gateway
Page 2 Sample Paper 10 CBSE 12th Informatics Practices

6. What is the primary function of the TRIM() function in SQL?

7. A student copies a chapter from a textbook and submits it as his own research paper. This act constitutes:
(A) Plagiarism only
(B) Copyright infringement only
(C) Both plagiarism and copyright infringement
(D) Neither plagiarism nor copyright infringement

8. In Pandas, which indexer is used for selection by integer position?

(A) .loc (B) .ix
(C) .pos (D) .iloc

9. A join that combines rows from two tables based on an equality condition between their common columns
is called a(n):
(A) Self Join (B) Cross Join
(C) Equi-Join (D) Outer Join

10. A single hypertext document on the World Wide Web that is identified by a unique URL is known as a:
(A) Website (B) Webpage
(C) Web server (D) Web browser

11. To find the number of unique countries listed in a Suppliers table, which SQL query is correct?
(A) SELECT TOTAL(UNIQUE Country) FROM Suppliers;
(B) SELECT COUNT(Country) FROM Suppliers;
(C) SELECT COUNT(DISTINCT Country) FROM Suppliers;
(D) SELECT DISTINCT(COUNT(Country)) FROM Suppliers;

12. Which command correctly renames the column ‘EmpID’ to ‘EmployeeID’ in a DataFrame df?
(A) df.relabel(columns={‘EmpID’:’EmployeeID’})
(B) df.rename(columns={‘EmpID’:’EmployeeID’})
(C) df.change_name(‘EmpID’, ‘EmployeeID’)
(D) df.set_column(‘EmpID’, to=’EmployeeID’)

13. The act of intentionally and illegally accessing computer systems, networks, or data without authorization
is called:
(A) Phishing (B) Spamming
(C) Hacking (D) Plagiarism

14. Which SQL clause is used to arrange rows with identical values into summary groups?
(A) ORDER BY (B) WHERE
(C) GROUP BY (D) HAVING

15. Which command correctly selects all rows from a DataFrame df where the ‘Marks’ column is greater than
or equal to 75?
(A) df.get(df[‘Marks’] >= 75) (B) df.select(Marks >= 75)
(C) df[df[‘Marks’] >= 75] (D) df.where(‘Marks’ >= 75)
NODIA APP Sample Paper 10 Page 3

16. A network used for connecting devices like a wireless headset, keyboard, and mouse to a computer is an
example of a:
(A) WAN (Wide Area Network) (B) MAN (Metropolitan Area Network)
(C) LAN (Local Area Network) (D) PAN (Personal Area Network)

17. Which SQL function is used to convert a string’s alphabetic characters to lowercase?
(A) TOLOWER() (B) LCASE()
(C) DOWNCASE() (D) MINUSCULE()

18. To visualize the frequency distribution of a set of continuous numerical data, such as exam scores for a whole
class, which type of plot is most appropriate?
(A) Line Plot (B) Histogram
(C) Bar Graph (D) Scatter Plot

19. In a URL like https://www.google.com, what does the https part signify?
(A) The Domain Name (B) The Path
(C) The Resource (D) The Protocol

Direction : For questions 20 and 21, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

20. Assertion (A): The df.head() method in Pandas, by default, displays the first 5 rows of a DataFrame.
Reason (R): The default value for the n parameter in the head(n=10) method is 10.

21. Assertion (A): Using a unique and complex password for each of your online accounts is a crucial cybersecurity
practice.
Reason (R): This practice ensures that if one account is compromised in a data breach, the stolen credentials
cannot be used to access your other accounts.

SECTION - B
22. Complete the given Python code: to merge two Data Frames ‘df1’ and ‘df2’ based on the ‘ID’ column using
Pandas.
import _____as pd
df1 = pd.DataFrame({‘ID’: [1, 2, 3, 4], ‘Name’: [‘John’, ‘Jane’, ‘Mike’,
‘Emily’]})
df2 = pd.DataFrame({‘ID’ : [2, 4, 5, 6], ‘Age’ : [25, 30, 22, 28]})
merged_df = pd.merge(____,____,____= ‘____’,____= ‘____’)
print(merged_df)
Page 4 Sample Paper 10 CBSE 12th Informatics Practices

23. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
import pandas as pd
data1 = [‘A’ : [1, 2, 3],
‘B’: [4, 5, 6]}
data2 = [‘A’ : [7, 8, 9],
‘B’: [10, 11, 12]}
df1 = Pd.dataFrame(data1)
df2 = Pd.dataFrame(data2)
result = Pd.Concat([df1, df2])

24. What is the web browser? Name any four web browsers.


o
Discuss the structure of an E-mail message in brief.

25. Write difference between degree and cardinality.

26. A series s1 is created as :

import pandas as p
s1=p.Series([1,2,3,4])
print(s1.hasnans)
Write the output of the above code.

27. What is cyber crime? Name two cyber crimes.

28. Shrey is using a table Student. It has following columns

RollNo, Name, Age, Subject
He wants to display highest Age of student in each subject.
He wrote the following statement
SELECT Subject, MAX (Age) FROM Student;
But he did not get the desired result. Rewrite the query with necessary changes to help him get the desired
result.

SECTION - C
29. Consider the following DataFrame df.

Code Name Price Qty Discount

0 C1 ABC 5500 10 10
1 C2 XYZ 4500 8 5
2 C3 PQR 5200 12 8
3 C4 MNO 3000 9 15
4 C5 LMN 5500 11 12
Write the Python statements for the following:
(i) To display the column labels of the Data Frame.
(ii) To sort the index label of Data Frame df in descending order.
(iii) To obtain the avg price of the given set of prices from the Data Frame.
NODIA APP Sample Paper 10 Page 5

30. A Data Frame df stores the details as (Code, Salary). Write a program to join it with a Data Frame df1
storing details as (Name, Designation, Department). Make sure that, all the rows from both the Data
Frames are part of the resultant Data Frame.

31. Anil was using a standalone computer until last month. Since, he has connected his computer to a network
he is facing problems like : slow computing, damaged files, etc.
Based on above reading answer the following questions
(i) Which action would keep him safe?
(ii) State any two sources via which above problem spreads.
(iii) Name any two softwares available in market to avoid above problems from spreading.


o
What are the possible damages caused by viruses?

32. Consider the table Teachers and write SQL query for (i) to (iii).

ID Name Department HireDate Category Gender Salary

1 Tarun Nanda Hindi 17-03-94 TGT M 25000
2 Sanjay Sharma English 12-02-90 PRT M 20000
3 Nikhil Arora Arts 16-05-80 PGT M 30000
4 James Kaur Science 16-10-89 TGT M 25000
5 Jaspreet Sehgal Science 01-08-90 PGT F 22000
6 Siddharth Kapoor English 10-02-80 PRT M 21000
7 Sonali Khanna Arts 02-09-94 TGT F 27000
8 Mukul Roy Computer 14-11-80 TGT M 30000
(i) To display name and ID of teachers of PGT category.
(ii) To display the names of female teachers of Hindi department.
(iii) To display names, departments and hiring dates of all the teachers in ascending order of hiring date.


o
Rama is not able to change a value in a column to NULL. What constraint did she specify when she created
the table? Give proper syntax of the constraint to be used.

SECTION - D
33. Given the following Python code:
import pandas as pd
color=[‘Blue’, ‘Green’, ‘Yellow’,
‘Red’]
newcolor=[‘Magenta’, ‘Cyan’]
s1=pd.Series(color)
s2=pd.Series(newcolor)
(a) What will be the output of the following?
(i) print(s1.size+s2.size)
(ii) print(s1+s2)
Page 6 Sample Paper 10 CBSE 12th Informatics Practices

(b) Write Python statement for the following: To add the elements of s2 to the end of s1.
(c) To display the shape of both Series.

(Option for part (c) only)

o
To add the elements of s1 to a DataFrame df.

34. Consider the following table PROJECTS.

ID ProjName ProjSize StartDate EndDate Cost

1 Payroll-MMS Medium 2006-03-17 2006-09-16 60000
2 Payroll-ITC Large 2008-02-12 2008-01-11 500000
3 IDMgmt-LITL Large 2008-06-13 2009-05-21 300000
4 Recruit-LITL Medium 2008-03-18 2008-06-01 50000
5 IDMgmt-MTC Small 2007-01-15 2007-01-29 20000
6 Recruit-ITC Medium 2007-03-01 2007-06-28 5000

Give output for (i) and (ii) and write statements for (iii) and (iv).
(i) SELECT COUNT (DISTINCT Cost) FROM PROJECTS;
(ii) SELECT MAX (Cost) FROM PROJECTS;
(iii) To list ID, ProjName, ProjSize and Cost of all the projects in descending order of StartDate.
(iv) To display ProjName and Cost of projects that have cost in the range of 20000 to 50000 (both 20000
and 50000 included).

SECTION - E
35. Knowledge supplement organization has set up its new centre at Bangalore for its office and web based
activities. It has 4 blocks of buildings as shown in the diagram below.

Centre to centre distances between various blocks

Block A to Block B 50 m
Block B to Block C 150 m
Block C to Block D 25 m
Block A to Block D 170 m
Block B to Block D 125 m
Block A to Block C 90 m
NODIA APP Sample Paper 10 Page 7

Number of Computers
Block A 25
Block B 50
Block C 125
Block D 10
(i) Suggest a cable layout of connections between the blocks.
(ii) Suggest the most suitable place (i.e. block) to house the server of this organization with a suitable
reason.
(iii) Suggest the placement of the following devices with justification.
(a) Repeater
(b) Hub/Switch
(iv) The organization is planning to link its front office situated in the city in a hilly region, where cable
connection is not feasible, suggest an economic way to connect it with reasonably high speed.
(v) What is the use of gateway in networking?

36. In a database OFFICE, we have one table given below

Table : Garment
GCode Description Price FCode ReadyDate
10023 Pencil Skirt 200 F03 19-Dec-10
10001 Formal Shirt 150 F01 12-Jan-10
10012 Informal Shirt 250 F02 06-Jan-10
10024 Baby Top 300 F03 07-Apr-09
10090 Tulip Skirt 350 F02 31-Mar-09
10019 Evening Gown 400 F03 06-Jun-10
10009 Informal Pant 250 F02 20-Oct-10
10017 Formal Pant 300 F01 09-Mar-09
10020 Frock 380 F04 09-Sep-09
10089 Slacks 150 F03 31-Oct-10
Write the SQL statements for the following:
(i) To display the description of Garment which are formal.
(ii) Identify the primary key in the table Garment. Give reason for your choice.
(iii) Write SQL command to change the FCode to F05 of the Garment with GCode as 10090 in the table
Garment.
(iv) Write query to display description of garment with their price whose FCode is F02.
(v) Write a query to display the detail of garment whose price is more than 300.


o
Define the purpose of following functions with proper syntax and example.
(i) UCASE( )
(ii) ROUND( )
(iii) RIGHT()
(iv) SUBSTRING( )
(v) MOD( )
Page 8 Sample Paper 10 CBSE 12th Informatics Practices

37. Plot a line chart on following data:

Name : ‘Ravi’, ‘Ria’, ‘Priya’, ‘Akashi’
Marks: 45,50,30,65
Title of the chart should be “ Student’s Marks”


o
Write Python code to plot the given graph with heading as “school admissions”.

******
NODIA APP Sample Paper 11 Page 1

Sample Paper 11
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

Section A
1. State whether the following statement is True or False:
The matplotlib.pyplot.show() function is used to save a plot as an image file.

2. What will be the result of the following SQL query?

SELECT UPPER(‘Practice Paper’);
(A) Practice Paper (B) practice paper
(C) PRACTICE PAPER (D) Practice paper

3. When a website places cookies on a user’s browser to track their activity across different websites for
targeted advertising, it contributes to the user’s:
(A) Active digital footprint (B) Passive digital footprint
(C) Digital copyright (D) Netiquette

4. Which command creates a Pandas Series where the value 10 is repeated for each index label in the list [‘a’,
‘b’, ‘c’]?
(A) pd.Series([10], index=[‘a’, ‘b’, ‘c’]) (B) pd.Series(10, index=[‘a’, ‘b’, ‘c’])
(C) pd.Series({‘a’,’b’,’c’: 10}) (D) pd.Series(index=[‘a’, ‘b’, ‘c’], value=10)

5. Which network device is essential for connecting two distinct networks that operate under different protocols,
such as a local office network and the internet?
(A) Hub (B) Switch
(C) Repeater (D) Gateway
Page 2 Sample Paper 11 CBSE 12th Informatics Practices

6. What is the primary function of the INSTR(string, substring) function in SQL?

(A) To check if a substring exists within a string.
(B) To extract the substring from the string.
(C) To return the starting position of a substring in a string.
(D) To insert a substring into a string.

7. An inventor creates a new machine and writes a detailed user manual for it. The invention itself can be
protected by a _____, while the written manual is protected by _____.
(A) Copyright, Patent (B) Patent, Copyright
(C) Trademark, Patent (D) Patent, Trademark

8. Which attribute of a Pandas DataFrame df returns True if the DataFrame has no elements and False
otherwise?
(A) df.is_empty (B) df.has_data
(C) df.empty (D) df.isnull()

9. In the relational database model, what does the term ‘cardinality’ refer to?
(A) The number of columns in a table. (B) The number of rows in a table.
(C) The number of primary keys in a table. (D) The number of tables in the database.

10. The service that stores the files for a website and makes them available to be viewed online is known as:
(A) Web browsing (B) Web hosting
(C) Web server (D) Domain registration

11. To find the earliest date of joining from an ‘Employees’ table, which function should be applied to the
‘JoinDate’ column?
(A) MIN(JoinDate) (B) MAX(JoinDate)
(C) FIRST(JoinDate) (D) EARLIEST(JoinDate)

12. To apply a custom function named calculate_grade to each value in the ‘Marks’ column of a DataFrame
df, which syntax is correct?
(A) df[‘Marks’].run(calculate_grade) (B) df.apply(‘Marks’, calculate_grade)
(C) df[‘Marks’].execute(calculate_grade) (D) df[‘Marks’].apply(calculate_grade)

13. The use of electronic communication to repeatedly send messages in a way that causes harassment or
annoyance to the recipient is a form of:
(A) Hacking (B) Phishing
(C) Cyberbullying (D) Plagiarism

14. Which SQL query will select all students from the Student table whose name starts with the letter ‘A’ ?
(A) SELECT FROM Student WHERE Name = ‘A’;
(B) SELECT FROM Student WHERE Name LIKE ‘A%’;
(C) SELECT FROM Student WHERE Name STARTS WITH ‘A’;
(D) SELECT FROM Student WHERE Name LIKE ‘A_’;
NODIA APP Sample Paper 11 Page 3

15. How would you select only the rows with index labels ‘R1’, ‘R3’, and ‘R5’ from a DataFrame df?
(A) df.loc[‘R1’, ‘R3’, ‘R5’] (B) df.iloc[[‘R1’, ‘R3’, ‘R5’]]
(C) df.loc[[‘R1’, ‘R3’, ‘R5’]] (D) df.get([‘R1’, ‘R3’, ‘R5’])

16. In which network topology is every node connected to a central device like a hub or a switch, and all
communication passes through this central point?
(A) Bus Topology (B) Ring Topology
(C) Star Topology (D) Mesh Topology

17. Which SQL function is used to extract a portion of a string by providing a starting position and a length?
(A) TRIM() (B) SUBSTR()
(C) INSTR() (D) REPLACE()

18. To add a descriptive label to the horizontal axis (x-axis) of a Matplotlib plot, which function should be
used?
(A) plt.title() (B) plt.xlabel()
(C) plt.ylabel() (D) plt.legend()

19. The technology that allows voice calls to be made over an internet connection instead of a traditional
telephone line is known as:
(A) HTTP (B) FTP
(C) VoIP (D) SMTP

Direction : For questions 20 and 21, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

20. Assertion (A): The index of a Pandas Series is immutable, meaning it cannot be changed after creation.
Reason (R): A new list or array of labels can be directly assigned to the Series’ .index attribute to modify it.

21. Assertion (A): The TRUNCATE TABLE command in SQL is a DML command used to delete specific rows.
Reason (R): TRUNCATE is a DDL command that rapidly deletes all rows from a table and cannot be easily
rolled back.

Section B
22. Write the short note on the following
(i) Web server
(ii) Mesh topology


o
Can you list and explain in detail any two major disadvantages of using the internet ?
Page 4 Sample Paper 11 CBSE 12th Informatics Practices

23. Replace the incorrect function names by correct ones in the following statement
SELECT position (“Waterbottle”,
“bot”);
Required : To get the position of “bot” in “Waterbottle”

24. Complete the given Python code: to select rows from the DataFrame ‘df where the ‘Salary’ column is greater
than 50000.
import _____ as pd
data = {‘Name’: [‘John’, ‘Jane’, ‘Mike’, ‘Emily’],
‘Salary’: [45000, 52000, 48000, 55000]}
df = pd.DataFrame(______)
selected_rows = df[df[‘_____’]>_____]
print(selected_rows)

25. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
import pandas as pd
data = {‘A’: [1, 2, 3], ‘B’: [4, 5, 6]}
df = pd.DataFrame()
df[C] = [7, 8, 9]
df = df[‘A’, ‘B’, ‘C’]

26. What will happen to the current transaction if a DDL statement is executed?

27. A series “Subject” comprises of following data

Index Values
0 Mathematics
1 Physics
2 Chemistry
3 Computer Science
What will be output of the following code?
for s in Subject:
if len(s) > 9:
print (s*2)

28. What is plagiarism?

Section C
29. Four dictionaries store the details of four employees as (Code, Name) of the month.
Write a program to create a DataFrame from them.

30. Help mohit to write python statements for the following

(i) To delete the DataFrame permanently .
(ii) To find the number of elements of the DataFrame.
(iii) To find the structure of DataFrame.
NODIA APP Sample Paper 11 Page 5

31. Consider the table PAINT :

Name Code Category Title Status Price Year

G Hussain 2098 Water Demons Sold 70000 2016
J Juneja 3099 Oil Twilight Not Sold 8000 2017
YD Sharma 8001 Collage Masses Sold 9500 2016
AD Souyza 7901 Oil Tresses Sold 13000 2018
Nevill 5400 Water Holiday Not Sold 8900 2019
Consider the above table ‘Paint’ and write the SQL queries for the following.
(i) Display the complete list of all the paintings that belong to category water.
(ii) Display the Title and Code of those painting whose price is more than 9000.
(iii) Increase the price of all painting in the given table by 5%.


o
Write the uses of aggregate functions. Write some examples of it.

32. Albert found that while logging to his E-mail account, the password was coming automatically,
(a) What could be the possible reason for above problem.
(b) In a URL what is the meaning of , https://?
(c) How to secure E-mail account from hackers?


o
Differentiate between intellectual property rights and digital property rights.

Section D
33. Given the Series “Colors” as follows
Colors
Index Value
R Red
G Green
V Violet
Y Yellow
M Magenta
(a) Write the output for the following
(i) Colors.pop(‘Y’)
print(Colors)
(ii) print(Colors[0 : 2])
(b) Write the statement for the following
To replace the value ‘Violet’ with
‘Violet Royal’
(c) Write the statement for the following
To display the shape.

(Option for part (c) only)

o
Write the statement for the following
To create another Series “NewColors” with values same as “Colors”
Page 6 Sample Paper 11 CBSE 12th Informatics Practices

34. Based on above table ORDER write the output for (i) and (ii) and SQL statement for (iii) and (iv).

Table : ORDER
Order ld OrderDate SalesPerson Order Amount
0101 2015-09-12 Ravi Kumar 34000
0102 2015-08-15 Rashmi Arora 50000
0103 2015-11-01 Ravi Kumar 55000
0104 2015-12-09 Manjeet Singh 60000
0105 2015-11-10 Rashmi Arora 50000
(i) SELECT Orderld, OrderAmount FROM Order WHERE OrderAmount BETWEEN 50000 AND
60000;
(ii) SELECT CONCAT (Orderld, SalesPerson), LENGTH (SalesPerson) FROM Order;
(iii) To display names of SalesPersons (without duplicates).
(iv) To list Orderld and respective OrderAmount in descending order of OrderAmount.

Section E
35. Arun Plastics has the following set-up of buildings, with each building equipped with multiple computers.
The distance between the buildings and the number of computers in each is given below

Building Number of Computers

Factory 125
Office 30
Home 20

Building Distance
Factory-Office 45 m
Factory-Home 15 m
Office-Home 120 m
(i) Suggest a suitable cable layout of connectivity between the buildings.
(ii) Suggest placement of server in the network.
(iii) What kind of network(LAN/MAN/WAN) is formed here?
(iv) Which topology should be used to connect the computers in each of the buildings?
(v) Suggest a device and the protocol that shall be needed to provide wireless Internet access.
NODIA APP Sample Paper 11 Page 7

36. Write Python code to plot the given graph

o
Given below is a bar chart showing names of some elements and their atomic numbers. Write code to display
this chart.

37. Consider the tables DOCTORS and PATIENTS given below

Table : DOCTORS
DocID DocName Department OPD_Days
101 M Panday ENT US
102 G P Gupta Paed MWF
201 C K Sharma Ortho MWF

Table : PATIENTS
PatNo PatName Department DocID
1 Neeraj ENT 101
2 Mohit Ortho 201
3 Ragini ENT 101
4 Mohit Paed 102
5 Nandini Ortho 201
Write the SQL queries for the following:
(i) To display the PatNo, PatName, DocID with corresponding DocName for each patient.
(ii) To display the PatName, Department and corresponding DocName whose OPD_Days is MWF.
(iii) To display name of those patients whose name start with ‘N’.
(iv) Identify the primary key in the table PATIENTS. Give reason for your choice.
(v) To change DocID to 202 of the patient with number as 5 in the table PATIENTS.


o
Define the purpose of following functions with proper syntax and example.
(i) MOD() (ii) MIN()
(iii) ROUND() (iv) LTRIM()
(v) LEFT()


******
NODIA APP Sample Paper 12 Page 1

Sample Paper 12
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

Section A
1. State whether the following statement is True or False:
The SQL DELETE command is used to remove the entire structure of a table along with its data.

2. What will be the result of the following SQL query?

SELECT MONTH(‘2025-08-15’);
(A) 2025 (B) 15
(C) 8 (D) August

3. A user receives a text message warning them about a compromised bank account, with a link to a fraudulent
website asking for their login credentials. This type of cyber attack is known as:
(A) Phishing (B) Vishing
(C) Smishing (D) Spamming

4. To get a tuple representing the dimensionality (number of rows, number of columns) of a Pandas DataFrame
df, which attribute is used?
(A) df.size (B) df.dim
(C) df.shape (D) df.axes

5. Which network device is essential for forwarding data packets between different networks, such as a home
LAN and the internet?
(A) Hub (B) Repeater
(C) Switch (D) Router
Page 2 Sample Paper 12 CBSE 12th Informatics Practices

6. What is the primary function of the DAYNAME() function in SQL?

(A) To return the day of the month as a number.
(B) To return the day of the year as a number.
(C) To return the name of the weekday for a given date.
(D) To return the numeric day of the week (1-7).

7. A company designs a unique logo and a catchy slogan for its new product. To protect this brand identity,
the company should apply for a:
(A) Patent (B) Copyright
(C) Trademark (D) Trade Secret

8. Which attribute of a Pandas Series returns its data as a NumPy ndarray?

(A) s.array (B) s.data
(C) s.values (D) s.list

9. To add a new column named ‘Experience’ to an existing Employees table in SQL, which command is used?
(A) UPDATE TABLE Employees ADD Experience INT;
(B) MODIFY TABLE Employees ADD Experience INT;
(C) INSERT COLUMN Experience INT INTO Employees;
(D) ALTER TABLE Employees ADD Experience INT;

10. What is the foundational protocol used for transmitting hypermedia documents, such as HTML, on the
World Wide Web?
(A) FTP (File Transfer Protocol)
(B) SMTP (Simple Mail Transfer Protocol)
(C) TCP/IP (Transmission Control Protocol/Internet Protocol)
(D) HTTP (Hypertext Transfer Protocol)

11. To calculate the total value of all transactions in a ‘Sales’ table, which SQL function should be applied to
the ‘Amount’ column?
(A) COUNT(Amount) (B) SUM(Amount)
(C) AVG(Amount) (D) TOTAL(Amount)

12. Which Pandas method is used to remove rows or columns containing missing values (NaN) from a DataFrame?
(A) df.clean() (B) df.remove_nan()
(C) df.dropna() (D) df.filter_nan()

13. When a user posts a comment on a blog, they are contributing to their:
(A) Passive digital footprint (B) Data privacy policy
(C) Active digital footprint (D) Digital security certificate

14. Which SQL clause is used to filter records and retrieve only those that meet a specific criterion?
(A) HAVING (B) GROUP BY
(C) FILTER (D) WHERE
NODIA APP Sample Paper 12 Page 3

15. How do you select the ‘Name’ and ‘Age’ columns from a DataFrame df, returning the result as a new
DataFrame?
(A) df[‘Name’, ‘Age’] (B) df.loc[‘Name’:’Age’]
(C) df[[‘Name’, ‘Age’]] (D) df.get(‘Name’, ‘Age’)

16. A network that spans a large geographical area, such as a country or continent, by connecting multiple
LANs and MANs is a:
(A) PAN (Personal Area Network) (B) LAN (Local Area Network)
(C) WAN (Wide Area Network) (D) VPN (Virtual Private Network)

17. Which SQL function is used to determine the number of characters in a given string?
(A) LEN() / LENGTH() (B) COUNT()
(C) SIZE() (D) WIDTH()

18. In Matplotlib, which function is used to display the legend that identifies the different data series in a chart?
(A) plt.key() (B) plt.labels()
(C) plt.legend() (D) plt.index()

19. What is the name of the primary legislation in India that deals with cybercrime and provides a legal
framework for e-commerce?
(A) The Indian Copyright Act (B) The Indian Cyber Law
(C) The Information Technology Act, 2000 (D) The Digital India Act

20. Assertion (A): Performing mathematical operations on Pandas Series (vectorization) is significantly faster
than using a Python loop.
Reason (R): Vectorized operations in Pandas leverage highly optimized, pre-compiled C or Cython code to
perform calculations on entire arrays at once.

21. Assertion (A): An idea for a novel is automatically protected by copyright law the moment it is conceived.
Reason (R): Copyright law protects the tangible expression of an idea (e.g., the written manuscript), not
the abstract idea itself.

Section B
22. Given a DataFrame storing marks of some college students as follows:
import pandas as pd
dict = {‘Name’:[‘Martha’, ‘Tim’,
‘Rob’, ‘Georgia’],
‘Maths’ : [87, 91, 97, 95],
‘Science’ : [83, 99, 84, 76]}
df = pd.DataFrame(dict)
df.loc[len(df.index)] = [‘Amy’, 89,
93] #L1
What will be the output of statement L1?
Page 4 Sample Paper 12 CBSE 12th Informatics Practices

23. Complete the given Python code: to display the last 3 rows of the DataFrame df using Pandas.
import _____ as pd
data = {‘Name’: [‘John’, ‘Jane’,
‘Mike’, ‘Emily’],
‘Age’: [25, 30, 22, 28]}
df = pd.DataFrame(_____)
print(df._____(______))

24. Write SQL function which returns the sum of values in given column with proper syntax.

25. Riya wants to add another column ‘Gender’ in the already existing table CUSTOMERS. She has written
the following statement. However, it has error. Rewrite the correct statement.
MODIFY TABLE CUSTOMERS GENDER CHAR(1);

26. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
import pandas as pd
data = {‘A’: [1, 2, 3],
‘B’: [4, 5, 6]}
df = Pd.dataFrame(data)
result = df[df ‘A’ > 1 ‘B’]

27. Discuss the factors that govern the selection of a topology for a network.


o
How does Voice over Internet Protocol (VoIP) work?

28. What are the solutions for phishing and pharming attack?

Section C
29. Write the code to create the following DataFrame:

Name Marks Subject

a Abhi 75 Maths
b Chirag 82 Science
c Tushar 69 English
d Mahi 70 Science
e Vanshika 92 Computer
NODIA APP Sample Paper 12 Page 5

30. Consider the following DataFrame df:

Code Name Price Qty Discount

0 C1 ABC 5500 10 10
1 C2 XYZ 4500 8 5
2 C3 PQR 5200 12 8
3 C4 MNO 3000 9 15
4 C5 LMN 5500 11 12
(i) Write down the command that will give the following output.

Code C1
Name ABC
Price 3000
Qty 8
Discount 5
dtype : object
(ii) To add a new column, Label with the values, ‘A’, ‘A’, ‘B’, ‘A’, ‘B’ to the DataFrame.
(iii) To find the most repeat value of the DataFrame.

31. Write SQL queries for the following:

(i) Add a constraint in table EMP1 that declares column Designation NOT NULL.
(ii) DROP table EMP1.
(iii) Write the command to increase the salary (column_name : Salary) by 10% of all the employee whose
salary less than 20000. The table’s name is ARIHANT.

o
Aryan, a database administrator, has grouped records of a table with the help of GROUP BY clause.
He needs to further filter groups of records generated through GROUP BY clause. Suggest suitable clause
for it and properly, explain its usage with the help of an example.

32. Shraddha, a programmer does not like some of the features of the software MS-Office and she wants to see
the source code of the software and change it .
Now, answer the following questions on the basis of above reading:
(i) What type of software is MS-Office?
(ii) Shraddha has searched for few softwares online, in which she can change the source code.
What are such software called as?
(iii) What kind of illegal activity can happen, if a wrong link/software is clicked?

o
Why should Intellectual Property rights be protected?
Page 6 Sample Paper 12 CBSE 12th Informatics Practices

Section D
33. A series s1 and s2 are created using the code :
import pandas as pd
import numpy as np
data=np.array([54,76,88,99,34])
s1=pd.Series(data,index=[‘a’, ‘b’, ‘c’, ‘d’, ‘e’])
(a) Write the output of the following code.
(i) s2=s1.reindex([‘e’, ‘b’, ‘c’, ‘a’, ‘d’])
print (s2)
(ii) print(s2.loc[‘e’ : ‘b’])
(b) Write command that will give the following output
b 76
c 88
(c) Write command that display the series by adding 10 in each value.


o
Write the output of
print (s1.shape)

34. The content of Item_No and Cost columns of a table ITEMS are given below:
Item_No Cost
101 5000
102 6000
103 NULL
104 NULL
105 6000
Based on this information, find the output of the following queries:
(i) SELECT AVG (Cost) FROM Items;
(ii) SELECT Cost + 100 FROM Items WHERE Item_No>103;
(iii) Write the query to assign cost as 1000 for the items whose cost is NULL.
(iv) Write the query to show the most costly item with its price.

Section E
35. Consider the following graph. Write the code to plot it.
NODIA APP Sample Paper 12 Page 7

o
Write Python code to draw the following bar graph representing the number of items in each category.

36. In the database COMPANY, there are two tables given below :

Table : Handset
SetCode SetName TouchScreen PhoneCost
N1 Nokia 2G N 5000
N2 Nokia 3G Y 8000
B1 Black Berry N 14000

Table : Customer
CustNo SetCode CustAddress
1 N2 Delhi
2 B1 Mumbai
3 N2 Mumbai
4 N1 Kolkata
5 B1 Delhi
Write SQL queries for the following:
(i) Display the CustNo, CustAddress and corresponding SetName for each customer.
(ii) Display the customer details for each customer who use a Nokia handset.
(iii) Increase the PhoneCost in the given table by 500.
(iv) Identify the foreign key in the table CUSTOMER.
(v) Write SQL command to change SetCode to N3 of the SetName with CustNo as 3. In the table
CUSTOMER.


o
Define the purpose of following terms with proper syntax and example.
(i) SUM() (ii) MAX()
(iii) RIGHT() (iv) ORDER BY
(v) WHERE
Page 8 Sample Paper 12 CBSE 12th Informatics Practices

37. Knowledge supplement organisation has set up its new center at Mangalore for its office and web based
activities. It has 4 blocks of buildings as shown in the diagram below

Centre to centre distances between various blocks:

Block P to Block Q 60 m
Block Q to Block R 160 m
Block R to Block S 35 m
Block P to Block S 180 m
Block P to Block R 100 m

Number of computers
Block P 35
Block Q 60
Block R 135
Block S 20
(i) Suggest a cable layout of connections between the blocks.
(ii) Suggest the most suitable place (i.e. block) to house the server of this organisation with a suitable
reason.
(iii) Suggest the placement of the following devices with justification :
(a) Repeater
(b) Hub/Switch
(iv) The organisation is planning to link its front office situated in the city in a hilly region,where cable
connection is not feasible, suggest an economic way to connect it with reasonably high speed?
(v) What is the purpose of modem in networking?

******
NODIA APP Sample Paper 13 Page 1

Sample Paper 13
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

Section A
1. State whether the following statement is True or False:
In a Pandas DataFrame, every column must contain data of the same data type.

2. What will be the result of the following SQL query?

SELECT RIGHT(‘New Delhi’, 5);
(A) Delhi (B) w Del
(C) elhi (D) New D

3. A digital artist creates an original piece of artwork on their computer. This creative work is automatically
protected from unauthorized copying and distribution by which form of Intellectual Property Right?
(A) Patent (B) Trademark
(C) Copyright (D) Trade Secret

4. Given a Python list data_list = [10, 20, 30], which command correctly creates a Pandas Series from it?
(A) pd.create_series(data_list) (B) pd.Series(from=data_list)
(C) pd.Series(data_list) (D) pd.to_series(data_list)

5. Which network device connects multiple computers within a Local Area Network (LAN) and uses MAC
addresses to intelligently forward data only to the intended recipient?
(A) Hub (B) Modem
(C) Repeater (D) Switch
Page 2 Sample Paper 13 CBSE 12th Informatics Practices

6. What is the function of MOD(a, b) in SQL?

(A) To calculate a raised to the power of b. (B) To find the absolute (module) value of a.
(C) To find the remainder when a is divided by b. (D) To round a to b decimal places.

7. Software that grants users the freedom to run the program, as well as to study, modify, and redistribute the
source code is known as:
(A) Freeware (B) Shareware
(C) Proprietary Software (D) Free and Open Source Software (FOSS)

8. Which attribute of a Pandas DataFrame df can be used to get its transpose, effectively swapping its rows
and columns?
(A) df.T (B) df.inverse
(C) df.swap() (D) df.transpose_axes

9. In a relational database, a column in one table that refers to the primary key of another table is called a:
(A) Candidate Key (B) Super Key
(C) Foreign Key (D) Composite Key

10. What is the term for the unique address that identifies a specific resource, such as a webpage or image, on
the internet?
(A) IP Address (B) MAC Address
(C) URL (D) Protocol

11. To find the average salary of all employees in an Employees table, which SQL function should be used on
the Salary column?
(A) SUM(Salary) (B) AVG(Salary)
(C) MIN(Salary) (D) COUNT(Salary)

12. Which of the following is the correct syntax for adding a new column named ‘Discount’ with a constant
value of 0.1 to a DataFrame df?
(A) df.add_column(‘Discount’, 0.1) (B) df.insert(‘Discount’, 0.1)
(C) df[‘Discount’] = 0.1 (D) df.column[‘Discount’] = 0.1

13. What is the term for discarded electrical or electronic devices, which are a source of toxic pollutants if not
disposed of correctly?
(A) Cyber waste (B) Technotrash
(C) E-waste (D) Digital debris

14. Which SQL statement correctly changes the city to ‘Pune’ for the customer with an ID of 501 in the
Customers table?
(A) CHANGE Customers SET City = ‘Pune’ WHERE ID = 501;
(B) UPDATE Customers SET City = ‘Pune’ WHERE ID = 501;
(C) MODIFY Customers SET City = ‘Pune’ FOR ID = 501;
(D) UPDATE Customers City = ‘Pune’ WHERE ID = 501;

15. How would you select rows from integer position 5 up to, but not including, position 10 in a DataFrame df?
(A) df.loc[5:10] (B) df.iloc[5:9]
(C) df.iloc[5:10] (D) df.loc[5:9]
NODIA APP Sample Paper 13 Page 3

16. A network that interconnects users with computer resources in a geographic region the size of a city is
known as a:
(A) LAN (Local Area Network) (B) PAN (Personal Area Network)
(C) WAN (Wide Area Network) (D) MAN (Metropolitan Area Network)

17. Which SQL function returns the current date and time of the server?
(A) CURRENT_TIME() (B) TODAY()
(C) NOW() (D) GETDATE()

18. To compare discrete categories of data, such as the number of students in different school houses, which
type of plot is most suitable?
(A) Line Plot (B) Histogram
(C) Bar Graph (D) Scatter Plot

19. An email that appears to be from a legitimate company but contains a link to a fraudulent website designed
to steal login credentials is an example of:
(A) Spamming (B) Phishing
(C) Cyberbullying (D) Hacking

Direction : For questions 20 and 21, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

20. Assertion (A): The iloc indexer in Pandas is used for selecting data based on its labels.
Reason (R): iloc selects rows and columns by their integer position, while the loc indexer is used for label-
based selection.

21. Assertion (A): In a mesh network topology, the failure of a single cable is likely to cause the entire network
to fail.
Reason (R): A mesh topology is highly fault-tolerant because it provides multiple redundant paths for data
to travel between any two nodes.

Section B
22. Riya has given the following command to obtain the highest salary:
SELECT MAX (EMP_SALARY) FROM Employee
WHERE GROUP BY DOJ:
But she is not getting the desired output. Help her by writing the correct command.

23. In how many ways, we can find the current date using MySQL?

24. Expand the following terms related to computer networks:

(i) HTTP (ii) NNTP
(iii) ISP (iv) TCP/IP


o
What is the difference between star topology and bus topology of network?
Page 4 Sample Paper 13 CBSE 12th Informatics Practices

25. Consider the following DataFrame df 1:

Code Name M1 M2 M3
0 11 Riya 45 39 53
1 12 Shobhit 72 58 49
2 13 Kiyaan 48 62 72
3 14 Vivek 65 70 59
4 15 Aashi 79 81 78
Write the output of the following statements:
(i) df1.max()
(ii) print (df1.count (0))

26. Complete the given Python code: to concatenate DataFrames ‘df1’ and ‘df2’ vertically (along rows) using
Pandas.
import _____ as pd
df1 = pd.DataFrame({‘A’: [1,2,3],
‘B’: [4,5,6]})
df2 = pd.DataFrame({‘A’: [7,8,9],
‘B’: [10, 11, 12]})
result_df = pd. _____([____, ____])
print(result_df)

27. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
import Pandas as Pd
data = (‘Name’: [‘Alice’, ‘Bob’, ‘Charlie’], ‘Age’: [25, 30, 22]}
df = pd.DataFrame(data)
result = [df[‘Age’] > 25]
Print(result)

Section C
28. Give any two measures to avoid online scams.

29. Consider the following DataFrame df.

Name Age Score Percentage

1 Rahul 18 98 80
2 Aaisha 19 72 NaN
3 Kiyaan 17 92 69
4 Riya 20 87 78
5 Ashutosh 19 85 99
6 Nishant 18 99 69
7 Kanak 17 76 73
NODIA APP Sample Paper 13 Page 5

Write the code

(i) To display the column labels of the DataFrame.
(ii) To add a new column Remark.
(iii) To sort the dataframe on column Age.

30. Write the code in Pandas to create the following DataFrame.

Name Subject Marks

1 Abhi Mathematics 46
2 Vanshika Science 76
3 Riya Science 70
4 Chirag Mathematics 82
5 Tushar Commerce 72
6 Khushal Physical 80
7 Mahi Art 78

31. Why are netiquettes important?

o
Give the safety measures to reduce the risk of cyber crime.

32. Consider the Table “Infant” shown below

Table : Infant
Item Code Item Date Purchase UnitPrice Discount
101 Frock 2016-01-23 700 10
102 Cot 2015-09-23 5000 25
103 Soft Toy 2016-06-17 800 10
104 Baby Socks 2014-10-16 100 7
105 Baby Suit 2015-09-20 500 5
Note Discount column stores discount %.
Write the commands in SQL for (i) to (iii).
(i) To display the details about the Cot.
(ii) To list the names of items and their unit price that have unit price less than 800 and discount more than
5%.
(iii) To list the names of items and their date of purchase that were purchased after 31st December, 2015.


o
Write the names of any three date/time functions and their uses.
Page 6 Sample Paper 13 CBSE 12th Informatics Practices

Section D
33. Consider two objects A and B. A is a list whereas B is a Series. Both have same values 20, 35, 75, 110.
(a) What will be the output of the following two statements considering that the above objects have been
created already?
(i) print (A*3)
(ii) print (B*3)
(b) Write the Python statement to retrieve number of bytes of Series B.
(c) Write Python statement to retrieve item size.

(Option for part (c) only)

o
Write the Python statement to retrieve shape of Series B.

34. Consider the following table Salesperson:

Table : Salesperson
SID Name Phone DOB Salary Area
S101 Amit Kumar 98101789654 1967-01-23 67000.00 North
S102 Deepika Sharma 99104567834 1992-09-23 32000.00 South
S103 Vinay Srivastav 98101546789 1991-06-27 35000.00 North
S104 Kumar Mehta 88675345789 1967-10-16 40000.00 East
S105 Rashmi Kumar 98101567434 1972-09-20 50000.00 South
Based on above table, answer the following questions.
(i) Write the output of the following statement.
SELECT Name, Salary FROM
Salesperson
WHERE Salary BETWEEN 30000 AND
40000;
(ii) What is the datatype of column SID?
(iii) To display the names of salesperson in order of highest to lowest Salary.
(iv) To display names of salespersons who have the word ‘Kumar’ anywhere in their names.

Section E
35. Consider the following graph. Write the code to plot it.
NODIA APP Sample Paper 13 Page 7

o
Write the Python code to draw the following bar graph representing the number of employees in each
department.

36. Consider the following tables CONSIGNOR and CONSIGNEE. Write SQL commands for the statements
(i) to (iv) and give output for SQL query (v).

Table : CONSIGNOR
CnorlD CnorName CnorAddress City
ND01 R Singhal 24, ABC Enclave New Delhi
ND02 Amit Kumar 123, Palm Avenue New Delhi
MU15 R Kohli 5/A, South Street Mumbai
MU50 S Kaur 27-K, Westened Mumbai

Table : CONSIGNEE
CneelD CnorlD CneeName CneeAddress CneeCity
MU05 ND01 Rahul Kishore 5, Park Avenue Mumbai
ND08 ND02 P Dhingra 16/J Moore Enclave New Delhi
KU19 MU15 AP Sharma 2A, Central Avenue Kolkata
MU32 ND02 S Mittal P245, AB Colony Mumbai
ND48 MU50 BP Jain 13, Block D, Avihar New Delhi
(i) To display the names of all consignors from Mumbai.
(ii) To display the CneeID, CneeName, CneeAddress of all consignee from New Delhi.
(iii) To display consignee details in ascending order of CneeName.
(iv) To display number of consignors from each City.
(v) SELECT DISTINCT(City) FROM CONSIGNEE;


o
Define the following functions with proper example.
(i) INSTR()
(ii) MOD()
(iii) POW()
(iv) YEAR()
(v) SUBSTR()
Page 8 Sample Paper 13 CBSE 12th Informatics Practices

37. Ideal IT Service Ltd is a software development organisation. It is planning to set up its Indian campus at
Delhi with its head office at Mumbai. The Delhi campus has 4 main buildings PLANNING, ANALYSIS,
DESIGN and IMPLEMENTATION.
You as a network expert have to suggest the best network related solution for their problem raised in (i) to
(v), keeping in the mind the distance between the building and other given parameter.

Shortest distance between various buildings

PLANNING to IMPLEMENTATION 65
PLANNING to DESIGN 100
PLANNING to ANALYSIS 60
IMPLEMENTATION to DESIGN 65
IMPLEMENTATION to ANALYSIS 60
ANALYSIS to DESIGN 55
Mumbai Head Office to Delhi Campus. 1725 km.
Number of computers installed at various buildings are as follows:

PLANNING 130
IMPLEMENTATION 85
DESIGN 50
ANALYSIS 22
Mumbai Head Office 30
(i) Suggest the most appropriate location of the server inside the Delhi campus (out of the 4 buildings), to
get best connectivity for maximum number of computers, justify your answer.
(ii) Suggest and draw the cable layout to efficiently connect various buildings within the Delhi campus for
connecting the computers.
(iii) Which hardware device will you suggest to be procured by the company to be installed to protect and
control the Internet uses within the campus?
(iv) Which of the following communication media, will you suggest to be installed for connecting their Delhi
campus for very effective (High speed) communication?
(a) Telephone line
(b) Optical fibre
(c) Ethernet cable.
(v) What is the use of firewall in building network?

******
NODIA APP Sample Paper 14 Page 1

Sample Paper 14
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

Section A
1. State whether the following statement is True or False:
A router is a less intelligent network device than a hub.

2. What will be the result of the following SQL query?

SELECT LCASE(‘SQL QUERIES’);
(A) SQL QUERIES (B) Sql Queries
(C) sql queries (D) sql Queries

3. A student downloads a research paper from the internet and submits it as their own assignment for a class.
This act of academic dishonesty is known as:
(A) Hacking (B) Cyberbullying
(C) Phishing (D) Plagiarism

4. Which of the following commands correctly selects the ‘Name’ column from a Pandas DataFrame df and
returns it as a Series?
(A) df[[‘Name’]] (B) df.get_column(‘Name’)
(C) df[‘Name’] (D) df.loc[‘Name’]
Page 2 Sample Paper 14 CBSE 12th Informatics Practices

5. What is the primary function of a modem?

(A) To connect multiple devices within a LAN.
(B) To modulate digital signals into analog and demodulate analog signals into digital.
(C) To amplify weak network signals to extend their range.
(D) To filter traffic between different networks.

6. What is the purpose of the LENGTH() function in SQL?

(A) To count the number of rows in a table.
(B) To determine the memory size of a column.
(C) To return the number of characters in a given string.
(D) To set the maximum length of a string column.

7. An engineer invents a new process for manufacturing computer chips more efficiently. To protect this
invention from being used by others, the engineer should file for a:
(A) Copyright (B) Trademark
(C) Patent (D) Trade Secret

8. Which attribute holds the row labels of a Pandas DataFrame df?

(A) df.rows (B) df.index
(C) df.labels (D) df.keys()

9. Which of the following commands is a Data Manipulation Language (DML) command in SQL?
(A) CREATE (B) DELETE
(C) ALTER (D) DROP

10. What is the common name for the software application, such as Chrome or Firefox, that is used to retrieve
and display information from the World Wide Web?
(A) Web Server (B) Web Host
(C) Web Browser (D) Search Engine

11. To identify the most expensive product in a Products table, which SQL function should be applied to the
Price column?
(A) MAX(Price) (B) TOP(Price)
(C) LARGE(Price) (D) HIGH(Price)

12. Which method is used to sort a DataFrame df based on the values in its ‘City’ column in alphabetical order?
(A) df.order_by(‘City’) (B) df.sort_values(by=’City’)
(C) df.arrange(‘City’) (D) df.sort(‘City’)

13. When a website uses your IP address and cookies to track which pages you visit, it is contributing to your:
(A) Active digital footprint (B) Passive digital footprint
(C) Digital identity (D) Cyber profile

14. Which SQL command is used to add new data records into a table?
(A) ADD ROW (B) NEW RECORD
(C) UPDATE TABLE (D) INSERT INTO
NODIA APP Sample Paper 14 Page 3

15. How can you display the last 4 rows of a Pandas DataFrame named df?
(A) df.last(4) (B) df.bottom(4)
(C) df.tail(4) (D) df.loc[-4:]

16. A network connecting all the computers and printers within a single school building is an example of a:
(A) PAN (Personal Area Network) (B) WAN (Wide Area Network)
(C) MAN (Metropolitan Area Network) (D) LAN (Local Area Network)

17. Which SQL function is used to convert all letters in a string to uppercase?
(A) CAPS() (B) UPPER()
(C) TO_UPPER() (D) CAPITALIZE()

18. To visualize the change in a city’s average monthly rainfall over a year, which type of plot would be most
effective?
(A) Histogram (B) Scatter Plot
(C) Bar Graph (D) Line Plot

19. In the URL http://www.example.com/products, what does www.example.com represent?

(A) The Protocol (B) The Path
(C) The Domain Name (D) The Query String

Direction : For questions 20 and 21, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

20. Assertion (A): The expression df[‘my_col’] selects a single column from a DataFrame and returns it as a
DataFrame.
Reason (R): To select a single column as a DataFrame, you must pass a list containing one column name,
such as df[[‘my_col’]].

21. Assertion (A): A good password should be short and easy to remember, like a pet’s name or ‘123456’.
Reason (R): A strong password is typically long and complex, using a mix of uppercase letters, lowercase
letters, numbers, and symbols to make it difficult to guess.

Section B
22. Differentiate between web browser and web server.


o
What is the role of a router as a network device?

23. Given the following code for a series creation, write the output of the following statement.
s1=pd.Series([1, 2, 3, 4])
print(s1[0 : 2]*2)
Page 4 Sample Paper 14 CBSE 12th Informatics Practices

24. Complete the given Python code: to create a DataFrame from the given dictionary ‘data’ and display the
first 3 rows using Pandas.
import _____ as pd
data = {‘Name’: [‘John’, ‘Jane’, ‘Mike’, ‘Emily’],
‘Age’: [25, 30, 22, 28],
‘City’: [‘New York’, ‘London’, ‘Paris’, ‘Sydney’]}
df = pd._____(_____)
print(df._____(_____))

25. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections
made.
import pandas as pd
data = {A [1, 2, 3, 4, 5],
B [6, 7, 8, 9, 10]}
df = pd.DataFrame()
result = df.loc[1 : 4, ‘A’: ‘B’]

26. Find the error in the query and rewrite the correct answer
Select weekdayname (“2020-09-12”);
Required: To get the week’s dayname for the date specified.

27. Write names of any two aggregate functions and one example of each.

28. What is a Freeware Software? Give some examples of freeware software.

Section C
29. Given two identical DataFrames df1 and df2. But df2 has some values missing. Write code so that df2 fills
its missing values from corresponding entries of df1.

30. Roma wants to create a DataFrame “Vehicle” comprising of some vehicles and their prices. She also wants
to perform some operations on the DataFrame, like additions, modification, arrangement of the data etc.
Help her to perform the operations.

Index Vehicle Wheels Price

0 Truck 8 820000
1 Car 4 560000
2 Moped 2 125000
3 eBike 2 150000
Write the Python statements for the following
(i) To make the price as 50% of the current prices
(ii) To modify the values of ‘Wheels’ column by values [9, 5, 3, 2]
(iii) To view only the contents of the ‘Wheels’ column
NODIA APP Sample Paper 14 Page 5

31. A table Cricket is given below, write queries to get the following

Table : Cricket
BID BatsmanName Fifty Hundred
B1 Sourav 120 200
B2 Sachin 150 300
B3 Rahul 75 30
B4 Gayles 100 45
B5 Richards 200 70
(i) Display the first three characters of the batsman names whose hundreds are more than fifties.
(ii) Display the square root of the hundreds scored by each of the batsman.
(iii) Display the hundreds/fifties rounded to 1 decimal place.


o
Help Sunaina with proper statements to get the outputs required in the following cases with respect to the
table Emp given with columns Eno, Ename, Dept and Salary.
(i) To get the 1st three letters from the Ename column from Emp table.
(ii) To get 123.
(iii) To get the string “TIGER” in lowercase.

32. Link softwares had developed a software, but they found that the software code was stolen and sold by
another company with their name.
(i) What is this act called ?
(ii) What does Practice of obtaining contribution from online community is called as?
(iii) Softwares that allow you to try the software for free, before use are called as...


o
List any three good netiquettes.

Section D
33. Given a table Zoo storing details of some animals of a Zoo:

Table : Zoo
AId Aname Type Qty
A01 Zebra Land 25
A02 Lion Land 10
A03 Giraffe Land 15
A04 Crocodile Aquatic 10
A05 Parrots Bird 30
Write outputs of the following statements:
(i) SELECT UCASE (SUBSTR(Aname, 3, 2)) FROM Zoo;
(ii) SELECT MAX(Qty) FROM Zoo;
(iii) SELECT MOD(Qty, 2) FROM Zoo WHERE NOT type = “Land”;
(iv) Write a query to count different types of animals in the zoo.
Page 6 Sample Paper 14 CBSE 12th Informatics Practices

34. A dataframe “Pencil” storing data of pencils is given below

Index Pname Type

0 HB Dark
1 QR Extra dark
2 Silver Color
3 ST OMR
(a) What will be the output of the following?
(i) Pencil.loc[2:2: ‘Type’]
(ii) df[‘Pencil’].nbytes
Write the Python statement to do the following
(b) To add a column storing the discount (Column name : “Disc”) with values [5%,6%,2%,3%]
(c) To display the size of dataframe Pencil.

(Option for part (c) only)

o
To replace the index values with new values as twice the previous index values.

Section E
35. Hindustan Connecting World Association is planning to start their offices in four major cities in India to
provide regional IT infrastructure support in the field of education and culture. The company has planned
to setup their head office in New Delhi in three different locations and have named their New Delhi offices
as Sales Office, Head Office and Tech Office. The company’s regional offices are located at Coimbatore,
Kolkata and Ahmedabad.
A rough layout of the same is as follows:

Approximate distances between these offices as per network survey team is as follows

Place from Place to Distance

Head Office Sales Office 10 m
Head Office Tech Office 70 m
Head Office Kolkata Office 1291 m
Head Office Ahmedabad Office 790 m
Head Office Coimbatore Office 1952 m
NODIA APP Sample Paper 14 Page 7

In continuation of the above, the company experts have planned to install the following number of computers
in each of their offices.

Head Office 100 Sales Office 20

Tech Office 50 Kolkata Office 50
Ahmedabad Office 50 Coimbatore Office 50
Answer the following questions
(i) Suggest the network type (out of LAN, MAN, WAN) for connecting each of the following set of their
offices.
(a) Head Office and Tech Office
(b) Head Office and Coimbatore Office
(ii) Which device will you suggest to be procured by the company for connecting all computers within each
of their offices out of the following devices?
(a) Modem
(b) Telephone
(c) Switch/Hub
(iii) Suggest the cable/wiring layout for connecting the company’s local offices located in New Delhi.
(iv) Suggest a device/software and its placement that would provide data security for the entire network .
(v) Suggest a device and the protocol that shall be needed to provide wireless Internet access to all
smartphone/laptop users.

36. Given a table Drinks, write SQL queries to get the following:

Table : Drinks
DrinkiD Drinkname Type Cost
D01 PepsiCola SoftDrinks 45
D02 CocaCola SoftDrinks 40
D03 MineralWater Gen 25
D04 SodaWater Booster 30
D05 Mangodrink Children 50

(i) Display the last 4 characters of the drinknames in uppercase.

(ii) Display each drinkname and the cost increased to double using a function.
(iii) Display the type and cost of the drinks whose drinkname has the word “cola” in it, using a mysql
function.
(iv) To get drinkname and types concatenated.
(v) To get the total cost of SoftDrinks.


o
Define the purpose of following functions with proper syntax.
(i) TRIM()
(ii) COUNT()
(iii) AVG()
(iv) LENGTH()
(v) MID()
Page 8 Sample Paper 14 CBSE 12th Informatics Practices

37. Write the code to plot the given chart

o
Write the code to plot the given chart

******
NODIA APP Sample Paper 15 Page 1

Sample Paper 15
INFORMATICS PRACTICES (065)
CLASS XII 2025-26
Time: 3 Hours Max. Marks: 70
General Instructions:
1. All questions are compulsory.
2. The examination paper contains five sections, from Section A to Section E.
3. Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
4. Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
5. Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
6. Section D consists of 2 questions (33 to 34). Each question carries 4 Marks.
7. Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
8. There is no overall choice. However, internal choices have been provided in some questions. Attempt only
one of the choices in such questions.
9. All programming questions are to be answered using Python Language only.
10. In case of MCQ, text of the correct answer should also be written.

Section A
1. State whether the following statement is True or False:
The ORDER BY clause in SQL can only sort data in ascending order.

2. What will be the result of the following SQL query?

SELECT MOD(20, 3);
(A) 6 (B) 1
(C) 2 (D) 6.67

3. A company downloads a photograph from a professional photographer’s website and uses it in a national
advertising campaign without permission or payment. This action is a form of:
(A) Plagiarism (B) Fair Use
(C) Copyright Infringement (D) Trademark Violation

4. Given data = [{‘Name’: ‘Arun’, ‘Age’: 20}, {‘Name’: ‘Bina’, ‘Age’: 22}], which command creates a Pandas
DataFrame?
(A) pd.DataFrame(from_list=data) (B) pd.DataFrame(data)
(C) pd.to_dataframe(data) (D) pd.create_df(data)
Page 2 Sample Paper 15 CBSE 12th Informatics Practices

5. Which network device is considered the least intelligent because it simply broadcasts any data it receives to
all other connected devices?
(A) Switch (B) Router
(C) Hub (D) Gateway

6. What is the primary function of the ROUND(number, decimals) function in SQL?

(A) To truncate a number to a certain length.
(B) To round a number to a specified number of decimal places.
(C) To return the nearest integer value of a number.
(D) To format a number as a currency string.

7. The iconic swoosh logo used by Nike is a globally recognized symbol that distinguishes its products. This
logo is protected as a:
(A) Patent (B) Trademark
(C) Copyright (D) Trade Secret

8. Which attribute of a Pandas DataFrame df provides the data types of each of its columns?
(A) df.types (B) df.datatypes
(C) df.info() (D) df.dtypes

9. In a database table, any column (or set of columns) that has the potential to become the primary key is
known as a:
(A) Foreign Key (B) Super Key
(C) Candidate Key (D) Alternate Key

10. The service that enables individuals and organizations to make their websites accessible on the World Wide
Web is called:
(A) Domain Registration (B) Web Development
(C) Web Hosting (D) Internet Service Provider

11. To determine the number of employees working in the ‘Marketing’ department in an Employees table, which
query is correct?
(A) SELECT SUM() FROM Employees WHERE Department = ‘Marketing’;
(B) SELECT COUNT() FROM Employees WHERE Department = ‘Marketing’;
(C) SELECT TOTAL(Department) FROM Employees WHERE Department = ‘Marketing’;
(D) SELECT LENGTH() FROM Employees WHERE Department = ‘Marketing’;

12. Which of the following commands correctly removes the ‘Salary’ column from a Pandas DataFrame df?
(A) df.delete(‘Salary’, axis=1) (B) df.remove(‘Salary’, axis=1)
(C) df.drop(‘Salary’, axis=1) (D) df.erase_column(‘Salary’)

13. Using all capital letters in an email or chat message is generally considered poor netiquette because it is
interpreted as:
(A) Whispering (B) Shouting
(C) Being formal (D) Being sarcastic
NODIA APP Sample Paper 15 Page 3

14. Which SQL clause is used with aggregate functions to combine rows with the same value into summary
groups?
(A) ORDER BY (B) WHERE
(C) GROUP BY (D) HAVING

15. How do you select all rows from index label ‘R2’ through ‘R5’ (inclusive) in a DataFrame df?
(A) df.iloc[‘R2’:’R5’] (B) df.loc[‘R2’:’R5’]
(C) df.loc[‘R2’,’R5’] (D) df.iloc[2:5]

16. In which network topology is each device connected to exactly two others, with data typically flowing in a
single direction?
(A) Star Topology (B) Bus Topology
(C) Mesh Topology (D) Ring Topology

17. Which SQL function removes both leading and trailing spaces from a string?
(A) LTRIM() (B) RTRIM()
(C) TRIM() (D) STRIP()

18. To visualize the frequency distribution of marks obtained by 100 students in an exam, which plot is the
most appropriate choice?
(A) Line Plot (B) Bar Graph
(C) Histogram (D) Scatter Plot

19. What does the acronym WWW stand for?

(A) Wide World Web (B) Web World Wide
(C) World Wide Web (D) World Web Watch

Direction : For questions 20 and 21, two statements are given: one labeled Assertion (A) and the other labeled
Reason (R). Choose the correct option.
(A) Both A and R are True, and R is the correct explanation of A.
(B) Both A and R are True, but R is not the correct explanation of A.
(C) A is True, but R is False.
(D) A is False, but R is True.

20. Assertion (A): Adding a single number to a Pandas Series will cause a TypeError.
Reason (R): Pandas supports a feature called broadcasting, which allows arithmetic operations between
arrays of different shapes, such as adding a scalar to every element of a Series.

21. Assertion (A): It is legal to buy a single-user license for a software and then install copies of it on all your
friends’ computers.
Reason (R): This act is a form of software piracy and is a violation of copyright law, as the license typically
prohibits unauthorized copying and distribution.
Page 4 Sample Paper 15 CBSE 12th Informatics Practices

Section B
22. Using copyright, software piracy can be stopped. How?

23. The Python code written below has syntactical errors. Rewrite the correct code and underline the corections
made.
Import pandas as pd
import Numpy as np
arr = np.array([1, 2, 3, 4, 5])
my_Series = pd.Series(arr)
print(my_series)

24. What is the advantage of using switch over hub?

o
List two differences between a website and a web page.

25. Complete the given Python code to Create a DataFrame from the following dictionary ‘data_dict’, and
print the sum of all the values in the ‘sales’ column.
import_____as pd
data_dict = {‘item’: [‘A’, ‘B’, ‘C’,
‘D’], ‘sales’ : [50, 30, 45, 20]}
df = pd.DataFrame(_____)
print(df[‘sales’]_____( ))

26. Which SQL function is used to remove leading and trailing spaces from a character expression X, where X
= ‘INFORMATION ###PRACTICE####’ (# denotes a blank space) and also give the output of X.

27. Kiyaan, a database administrator needs to display house wise total number of records of ‘Blue’ and ‘Green’
house. He is encountering an error while executing the following query:
SELECT HOUSE, COUNT (*) FROM SCHOOL GROUP BY HOUSE WHERE HOUSE=‘Blue’ OR HOUSE=
‘Green’;
Help him in identifying the reason of the error and write the correct query by suggesting the possible
correction(s).

Section C
28. Consider the following table CLUB.

Table : CLUB
COAC H_ID COACH NAME AGE SPORTS Date_of_Joining PAY
1 Rajesh 30 Karate 1999-08-25 1000
2 Anuj 35 Swimming 2000-01-05 750
3 Shuchi 25 Basketball 2005-01-04 1200
4 Reetika 28 Badminton 2002-08-25 1400
5 Virendra 32 Cricket 1996-05-17 1500
NODIA APP Sample Paper 15 Page 5

Write SQL queries for the following:

(i) To display the substring of 4 characters of the name of each coach, starting from second character, with
their age.
(ii) To display the day for the Date_of Joining column.
(iii) To concat the COACHNAME with AGE where age of coach is above 30 years.


o
What is the purpose of GROUP BY clause in MySQL? How is it different from ORDER BY clause?

29. Write the code to create the following DataFrame:

Name Marks Subject

a Abhi 75 Maths
b Chirag 82 Science
c Tushar 69 English
d Mahi 70 Science
e Vanshika 92 Computer

30. Explain the term plagiarism. Mention any two ways to avoid plagiarism.


o
Smridh has recently changed his school, so he is not aware of the people, but someone is posting negative,
demeaning comments on his social media profile. He is also getting repeated mails from unknown people.
Everytime he goes online, he finds someone chasing him online.
(i) Smridh is a victim of _____
(ii) What should Smridh needs to do inorder to priotqct. his personal information or data from unintentional
and intentional attacks .
(iii) Why are netiquettes important?

31. Consider the following DataFrame dfn that contain vegetables.

Color Quantity Price

Capsicum Red 12 60
Capsicum Green 22 100
Chilli Red 50 40
Chilli Green 65 55
Lime Green 20 35
Write the code statement to the following:
(i) Find all rows with the label “Chilli”. Extract all columns.
(ii) List 2nd, 3rd and 4th rows.
(iii) List only the columns Quantity and Price using loc.

32. Write the output of following queries.

(i) mysql>SELECT POWER(9, 3);
(ii) mysql>SELECT MID(‘SHUCHI GOYAL’, 8, 5);
(iii) mysql>SELECT RIGHT(‘Dushyant’, 5);
Page 6 Sample Paper 15 CBSE 12th Informatics Practices

Section D
33. A Gift Gallery has different stores in India. Database Administrator Abhay wants to maintain database of
their Salesmen in SQL to store the data.
Consider the following records in ‘Salesman’ table and answer the given questions.

Table : Salesman
Scode Sname Address Dtofjoin Sales Area
100 Sushant Delhi 2017/09/29 5000.90 East
101 Sushant Gurgaon 2018/01/01 7000.75 East
102 Priya Noida 2018/04/25 3450.45 West
103 Mohit Delhi 2018/11/03 6000.50 North
104 Priya-nshi Delhi 2019/12/15 8000.62 North
(i) Display Sname and Sales of East and West areas.
(ii) Display the total Sales made in East Area.
(iii) The command to display the Name of the Salesman along with the Sales amount rounded off to one
decimal point.
(iv) The command to display the length of salesman name.

34. Zeenat has created the following DataFrame dataframe 1 to keep track of data Rollno, Name, Marks1 and
Marks2 for various students of her class, where row indexes are taken as the default values:

Rollno Name Marks1 Marks2

1 Swapnil Sharma 30 50
2 Raj Batra 75 45
3 Bhoomi Singh 82 95
4 Jay Gupta 90 95
(a) What will be the output of the following codes?
(i) print(dataframe1.size)
(ii) print(dataframe1[‘Rollno’]==2)
(b) Write the code to print the highest marks obtained in Marks1 and Marks2.
(c) Write the code to add new column “Marks3” with relevant data.

(option for part (c) only)

o
Write the code for delete the 3rd column.

Section E
35. Bias Methodologies is planning to expand their network in India, starting with three cities in India to build
infrastructure for research and development of their chemical products. The company has planned to set
up their main office in Pondicherry at three different locations and have named their offices as Back Office,
Research Lab and Development Unit. The company has one more research office namely Corporate Unit in
Murnbai. A rough layout of the same is as follows:
NODIA APP Sample Paper 15 Page 7

Approximate distance between these offices are as follows:

From To Distance
Research Lab Back Office 110 m
Research Lab Development Unit 16 km
Research Lab Corporate Unit 1800 km
Back Office Development Unit 13 km
In continuation of the above, the company experts have planned to install the following number of computers
in each of their offices

Research Lab 158

Back Office 79
Development Unit 90
Corporate Unit 51
(i) Suggest the type of network required (out of LAN, MAN, WAN) for connecting each of the following
office units.
(a) Research Lab and Back Office
(b) Research Lab and Development Unit.
(ii) Which one of the following device, will you suggest for connecting all the computers with in each of their
office units?
(a) Switch/Hub
(b) Modem
(c) Telephone
(iii) Company is planning to get its website designed which will allow students to see their results after
registering themselves on its server. Out of the static or dynamic, which type of website will you
suggest?
(iv) Suggest a cable/wiring layout for connecting the company’s local office units located in Pondicherry.
Also, suggest an effective method/technology for connecting the company’s office unit located in
Mumbai.
(v) Which building is suitable to install the server with suitable reason?
Page 8 Sample Paper 15 CBSE 12th Informatics Practices

36. Write the code for the following graph which display the different style multiline in same plot.

o
Write a Python code to create a line graph for the data given below based on TV SHOWS rated by the
users.
Shows=[“The Kapil Sharma Show”, “Friends”, “India has Got Talent”,“Big Boss”,
“Dance India Dance”]
Rating=[4.2, 4.8, 5.0, 3.8, 4.1]

37. Consider the following records in ‘Garment’ table.

Table : Garment
Gcode Gname Size Color Price
111 Tshirt XL Red 1400.00
112 Jeans L Blue 1600.00
113 Skirt M Black 1100.00
114 Jacket XL Blue 4000.00
115 Trousers L Brown 1500.00
116 LadiesTop L Pink 1200.00
Write the commands for (i) to (iv) and answer for (v)
(i) To delete the record with Gcode as 116.
(ii) Display the Gname and Price with price highest to lowest.
(iii) To change the color of Garment with code as 116 to “Orange”.
(iv) To display the all details of table Garment.
(v) What is the degree and cardinality of ‘Garment’ table?


o
Explain the given below functions:
(i) INSTR()
(ii) DATE()
(iii) LENGTH()
(iv) SUM()
(v) MOD()


******