Dear Teachers and Students,

Join School of Educators' exclusive WhatsApp, Telegram, and Signal groups for FREE access
to a vast range of educational resources designed to help you achieve 100/100 in exams!
Separate groups for teachers and students are available, packed with valuable content to
boost your performance.

Additionally, benefit from expert tips, practical advice, and study hacks designed to enhance
performance in both CBSE exams and competitive entrance tests.

Don’t miss out—join today and take the first step toward academic excellence!

Join the Teachers and Students

Group by Clicking the Link Below
 Series ARSP/05 Set ~ 5
Roll No. Q.P Code 15/5/5
Candidates must write the Q.P Code
on the title page of the answer-book.

 Please check that this question paper contains 06 printed pages.

 Q.P. Code given on the right hand side of the question paper should be written
on the title page of the answer-book by the candidate.
 Please check that this question paper contains 37 questions.
 Please write down the serial number of the question in the answer-book
before attempting it.
 15 Minute times has been allotted to read this question paper. The question
paper will be distributed at 10:15 a.m. From 10.15 a.m to 10.30 a.m, the students
will read the question paper only and will not write any answer on the answer –
book during this period.

INFORMATICS PRACTICES

Time allowed: 3 hours Maximum Marks: 70

General Instructions:
Please check this question paper contains 37 questions.

All questions are compulsory. However, internal choices have been provided in some questions. Attempt only one of the choices in such questions
The paper is divided into 5 Sections- A, B, C, D and E.

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

Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.

Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.

Section D consists of 2 case study type questions (33 to 34). Each question carries 4 Marks.
Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.

All programming questions are to be answered using Python Language only.

In case of MCQ, text of the correct answer should also be written.

Section A
1. State true or false: [1]
The data value of series object can be modified using value assignment.
2. What is the minimum number of arguments required for plot() function in matplotlib? [1]

a) 3 b) 2

c) 1 d) 4
3. Which of the following device may operate at different network speeds depending on the protocol standard they support? [1]

a) Router b) RJ45 Connector

c) Ethernet card d) Modulator

4. What will be returned by the given query? [1]
SELECT INSTR('INDIA', 'DI');

a) -2 b) -3

c) 3 d) 2
5. Which of the following is not a symptom of a virus attack? [1]

a) Unusual messages and graphics appear on the screen for inexplicable b) Some programs or data files on the computer either become corrupt or
reasons are difficult to locate

c) The computer begins to run slowly d) Your data is copied to another location
6. In URL, http://www.mycbseguide.com/index.htm, which component identifies the path of a web page? [1]

a) http b) All of these

c) /index.htm d) www.mycbseguide.com
7. Network formed between computers which are spread across the continents is called [1]

a) WAN b) WLAN

c) MAN d) LAN
8. State true or false: [1]
CHAR() ignores the NULL value.
9. The first page on the website that allows you to navigate to other pages by menus or links is known as ________. [1]

a) web page b) Home page

c) primary page d) front page

10. A good way to safeguard access to your computer is to protect it. [1]

a) Password b) Safe mode

c) Deadbolt d) Copyright
11. If the substring is not present in a string, the INSTR ( ) returns: [1]

a) NULL b) 1

c) 0 d) -1
12. To remove the leading and trailing space from data values in a column of MySql Table, we use [1]
 a) Right ( ) b) Trim ( )

c) Ltrim ( ) d) Left ( )
13. There is only 1 day left for Ravisha to submit her Science project. Therefore, she performed the following activities to complete her task. Which of the following activities can be [1]
considered as plagiarism?

a) Downloaded the images that were marked as CC and pasted in her b) Copied the content from some website and pasted in her file.
project file.

c) Downloaded and installed the open source software for typing the d) Copied the content from the website and gave references about the
synopsis. same in the project.
14. You are planning to go on a vacation to Kashmir. You surfed the internet for the following: [1]
i. Weather conditions
ii. Availability of air tickets and fares
iii. Places to visit
iv. Best hotel deals
Which of the above mentioned acts might have left a digital footprint?

a) i, ii and iii b) i and ii

c) all of these d) i, ii and iv

15. Statement (A): A Matplotlib figure can be categories into several parts as Axis, Artist, Labels, Title and Legend etc. [1]
Statement (B): Data is only as good as it is represented.

a) Statement B is correct. b) Both Statement A and B is correct.

c) Statement A is correct. d) Statement A is correct, but Statement B is incorrect.

16. Consider the following query [1]
SELECT * FROM employee ORDER BY salary ________, name ______;
To display the salary from greater to smaller and name in alphabetical order which of the following options should be used ?

a) Desc, Asc b) Ascending, Descending

c) Asc, Desc d) Descending, Ascending

17. ________ is a technology related health condition affecting eyesight. [1]

a) Computer vision syndrome b) Eyesight syndrome

c) Computer vision strain d) Vision imbalance

18. Consider the following dataframe df1: [1]

EName Sal Bonus

0 Kavita 50000 3000

1 Sudha 60000 4000

2 Garima 55000 5000

Write the output of the given command:

df1.loc[:0, 'Sal']

a) 3000 b) 50000

c) 55000 d) 0 Kavita 50000 300

19. Which of the following is not an aggregate function? [1]

a) MAX() b) ADD()

c) COUNT() d) AVG()
20. Assertion (A): Users or companies who distribute GPL license works may charge a fee for copies or give them free of charge. [1]
Reason (R): The GNU General public license (GPL) is a popular category of public licenses.

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.

21. Assertion (A): Nidhi has create dataframe Df1 [1]

Student Marks Sports

I ABC 24.5 Cricket

II DEF 27.5 Badminton

III GHI 30.0 Football

She can expand or delete any row /column in this dataframe.

Reason (R): In python DataFrame objects can be concatenated or merged.

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.

 Section B
22. What do you understand by the term VoIP? Give two examples of software/apps based on VoIP. [2]
OR
Write two advantages of using Internet.
23. Name any three date functions. [2]
24. Ms. Mohini is working in a school and stores the details of all students in a table SCHOOLDATA. [2]
TABLE : SCHOOLDATA

Admno Name Class House Percent Gender Dob

20150001 Aditya Das 10 Green 86 Male 2006-02-20

20140212 Harsh Sharma 11 Red 75 Male 2004-10-05

20090234 Swapnil Pant 10 Yellow 84 Female 2005-11-21

20130216 Soumen Rao 9 Red 91 Male 2006-04-10

20190227 Rahil Arora 10 Blue 70 Male 2005-05-14

20120200 Akasha Singh 11 Red 64 Female 2004-12-16

Write SQL statements from the above given table to:

i. To remove leading spaces from the column Name.
ii. Display the names of students who were born on Sunday.
25. How are NULL values treated by aggregate functions? [2]
OR
Consider the following table structure. STUDENT (RollNo, Name, Class, Stream, Percentage) Give the answer of the following questions on the basis of the above table structure
i. Write a query to display the concatenated form of name and class.
ii. Write a query to display the name of each student in uppercase letters with their ROLLNo, whose percentage is greater than 70.
26. What is the use of cyber bullying? [2]
27. Write a program to create an empty series [2]
#import the pandas library and aliasing as pd
28. Write python code to create the DataFrame emp using dictionary: [2]

Name Salary

101 Rohan 20000

102 Aman 25000

OR
What will be the output of df.iloc[3:7, 3:6]?
Section C
29. A relation Vehicles is given below: [3]

V_no Type Company Price Qty

AW125 Wagon Maruti 250000 25

J0083 Jeep Mahindra 4000000 15

S9090 SUV Mitsubishi 2500000 18

M0892 Mini van Datsun 1500000 26

W9760 SUV Maruti 2500000 18

R2409 Mini van Mahindra 350000 15

Write SQLcommands to:

i. Display the average price of each type of vehicle having quantity more than 20.
ii. Count the type of vehicles manufactured by each company.
iii. Display the total price of all the types of vehicles.
30. Help Renu in predicting the output of the following queries. [3]
i. SELECT ROUND(8.72,3);
ii. SELECT ROUND(9.8);
OR
Write commands in SQL for (i) and (ii) and output for (iii)

Store ld Name Location City No. of Emp Date Open Sales Amt

S101 Planet Fashion Bandra Mumbai 7 2015-10-16 40000

S102 Vogue Karol Bagh Delhi 8 2015-07-14 120000

S103 Trends Powai Mumbai 10 2015-06-24 30000

S104 Super Fashion Thane Mumbai 11 2015-02-06 45000

S105 Annabelle South Extn. Delhi 8 2015-04-09 60000

 S106 Rage Defence Colony Delhi 5 2015-03-01 20000

i. To display the details of the store in alphabetical order of name.

ii. To display the City and the number of stores located in that City, only if the number of stores is more than 2.
iii. SELECT COUNT(STOREID), NOOFEMP FROM STORE GROUP BY NOOFEMP HAVING MAX(SALESAMT)<60000;
31. Give an example to create a DataFrame from the list of dictionary. Also, display its output. [3]
32. What is the purpose of GROUP BY clause in MySQL? How is it different from ORDER BY clause? [3]
OR
Consider the following table School:
Table : School

Admno Name Class House Percentage Gender

20150001 Abhishek Kumar 10 Green 86 Male

20140212 Mohit Bhardwaj 11 Red 75 Male

20090234 Ramandeep Kaur 10 Yellow 84 Female

20130216 Mukesh Sharma 9 Red 91 Male

20190227 Rahil Arora 10 Blue 70 Male

20120200 Swapnil Bhatt 11 Red 64 Female

Write SQL queries for the following:

a. Display the total number of students in each House where number of students are more than 2.
b. Display the average Percentage of girls and boys.
c. Display the minimum Percentage secured by the students of Class 10.
Section D
33. Read the text carefully and answer the questions:
Mr. Vinod 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

Code to create the above data frame:

import pandas as ________

#Statement 1
data={"Year":[2010, 2010, 2012, 2010, 2012], "Month":["Jan", "Mar", "Jan", "Dec", "Dec"], "Passengers":[25, 50, 35, 55, 65]}
df=pd.________(data)
#Statement 2
print(df)

(a) Find the right code for Statement 1.

(b) Find the right code for the Statement 2.
(c) Find the correct statement/method for the required output: (5, 3)
(d) He wants to print the details of "January" month along with the number of passengers, Write the correct statement.

Month Passengers

0 Jan 25

2 Jan 35

34. Read the text carefully and answer the questions: [4]
Learn Together is an educational NGO. It is setting up its new campus at Jabalpur for its web-based activities. The campus has four compounds as shown in the diagram below:

Centre to centre distance between various compounds as per architectural drawing (in m) is as follows

Main Compound to Resource Compound 110 m

Main Compound to Training Compound 115 m

Main Compound to Finance Compound 35 m

Resource Compound to Training Compound 25 m

Resource Compound to Finance Compound 135 m

Training Compound to Finance Compound 100 m

Expected number of computers in each compound are as follows

Main Compound 5

Resource Compound 15

Training Compound 150

Finance Compound 20

(a) Suggest a cable layout of connections between the compounds.

(b) Suggest the most suitable place (i.e. compound) to house the server for this NGO. Also, provide a suitable reason for your suggestion.
(c) Suggest the placement of the following devices with justification:
i. Repeater
ii. Hub/Switch
(d) The NGO is planning to connect its international office situated in Mumbai, which out of the following wired communication link, will you suggest for a very high speed
connectivity?

a) Wireless transmission b) Optical fibre

c) Telephone analog line d) Ethernet cable

OR
Read the text carefully and answer the questions: [4]
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 Mumbai. A rough layout of the same is as follows:

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 130 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

(a) Suggest the type of network required (out of LAN, MAN, WAN) for connecting each of the following office units.
Research Lab and Back Office
Research Lab and Development Unit
(b) Which one of the following device, will you suggest for connecting all the computers with in each of their office units?

a) Telephone b) Switch/Hub

c) Line d) Modem
(c) Which of the following communication medium, will you suggest to be procured by the company for connecting their local office units in Pondicherry for very effective
(high speed) communication?

a) Optical fibre b) Telephone cable

c) Fiber cable d) Ethernet cable

(d) 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.
 Section E
35. Write the output of following queries. [5]

i. mysql>SELECT POWER(9, 3);

ii. mysql>SELECT MID('SHUCHI GOYAL', 8,5);

iii. mysql>SELECT RIGHT('Dushyant',5);

iv. mysql>SELECT INSTR('SQL FUNCTIONS', 'C');

v. SELECT LEFT('Elpis', 2);

36. a. Write a program in Python Pandas to create the following DataFrame "population" from a Dictionary: [5]

country population percent

IT Italy 61 0⋅ 83

ES Spain 46 0⋅ 63

GR Greece 11 0⋅ 15

FR France 65 0⋅ 88

PO Portugal 10 0⋅ 14

b. Perform the following operations on the DataFrame:

i. Display the columns country and population.
ii. Display all the rows where population is more than 40.
iii. Delete the last 2 rows.
37. What is bar chart? Also, give its example. [5]
OR
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()