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/03 Set ~ 3
Roll No. Q.P Code 15/3/3
Candidates must write the Q.P Code
on the title page of the answer-book.

 Please check that this question paper contains 09 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]
CSV files are quick to create and load into memory before analysis.
2. Which key is used to run the module? [1]

a) F6 b) F5

c) F4 d) F3
3. Which of the following topologies needs the least cable length? [1]

a) Tree b) Star

c) Car d) Bus
4. The correct output of [1]

SELECT TRIM (LEADING '&' FROM '&&& India &&&&'); is

a) &&& India b) India &&&

c) India &&&& d) && India

5. A person who is authorized keep or transfer rights to use/distribute the software is known as ________. [1]

a) Plagiarism b) Trademark
 c) Patent d) Copyright holder
6. Modulation and demodulation is performed by [1]

a) gateway b) modem

c) satellite d) microwave
7. The Gyan international school has installed 40 computers in its Computer lab. Choose the correct deviceto form [1]
a LAN network involving the 40 computers.

a) Switch b) Hub

c) Gateway d) Repeater
8. State true or false: [1]
SQRT() returns the square root of a given number.
9. By default, web pages are saved in the ________ folder. [1]

a) Picture b) Download

c) Music d) Document
10. Which of the following term that encapsulates the legal issues related to the use of Internet? [1]

a) Cyber stalking b) Cyber attack

c) Cyber law d) Cyber crime

11. Which clause is similar to HAVING clause in MySQL? [1]

a) SELECT b) WHERE

c) FROM d) TO
12. Which aggregate function returns the count of all rows in a specified table? [1]

a) SUB b) COUNT

c) SUM d) DISTINCT
13. The trail that is automatically created, when a person uses the Internet on any digital devices like laptops, smart [1]
phones, tablets etc is called

a) cyberbullying b) digital footprint

c) digital activity d) phishing

14. After a fight with your friend, you did the following activities. Which of these activities is not an example of [1]
cyberbullying?
i. You sent an email to your friend with a message saying that "I am sorry".
ii. You sent a threatening message to your friend saying "Do not try to call or talk to me".
iii. You created an embarrassing picture of your friend and uploaded on your account on a social networking
site.
iv. None of these

a) Option (iv) b) Option (i)

c) Option (iii) d) Option (ii)

15. Statement (A): Matplotlib allows us to use different line style and colours. [1]
Statement (B): we specify colour and line style as the first argument of plot () function.
 a) Statement B is correct. b) Statement A is incorrect, but Statement B is
correct.

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

incorrect.
16. SQL applies conditions on the groups through ________ clause after groups have been formed. [1]

a) Group by b) Having

c) Where d) With
17. Which of the following is one of the most strong crime committed in the virtual world? [1]

a) Cyber stalking b) Cyber hacking

c) Cyber trolls d) Cyber bullying

18. Assuming the given structure, which command will give us the given output: [1]
Output Required: (3, 4)

EmpCode Name Desig

0 1405 VINAY Clerk

1 1985 MANISH Works Manager

2 1636 SMINA Sales Manager

3 1689 RINU Clerk

a) print(df.shape()) b) print(df.size)

c) print(df.shape) d) print(df.size())
19. Which of the following function converts the characters of an argument string to the uppercase characters? [1]

a) UCASE() b) UPPER( )

c) UPPERCASE( ) d) Both UCASE() and UPPER( )

20. Assertion (A): FSF is Non-Profit organisation to support free software development. [1]
Reason (R): FSF supports open software development also.

a) Both A and R are true and R is the correct b) Both A and R are true but R is not the
explanation of A. correct explanation of A.

c) A is true but R is false. d) A is false but R is true.

21. Assertion (A): We can read specific rows from a CSV file. [1]
Reason (R): The nrows attribute of to_csv() is used to read specific rows from a CSV file.

a) Both A and R are true and R is the correct b) Both A and R are true but R is not the
explanation of A. correct explanation of A.

c) A is true but R is false. d) A is false but R is true.

Section B
22. Which device is used to connect dissimilar networks? [2]
OR
Differentiate between web page and home page?
23. Predict the output of the following SQL queries from the below Table: SCHOOL [2]
Table : SCHOOL

Admid Sname Grade House Per Gender Dob

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

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

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

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

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

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

Write the SQL statements from the given table to:

a. SELECT AVG(Per) FROM SCHOOL WHERE House="Red";
b. SELECT Sname, Per FROM SCHOOL WHERE MONTH(Dob)=11;
24. Find the output of the following SQL queries: [2]
i. SELECT SUBSTER ("Innovation",3,4)'
ii. SELECT RIGHT ("Innovation",5)'
25. Write the output of the following query: [2]

mysql>SELECT SUBSTR('STUDENT',3,3);

OR
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.

mysql> SELECT SUBSTR (Title, 2, 3) FROM BOOK WHERE Code = 'D002';

26. Manohar received an email from a company, named Makemoney Pvt. Ltd., claiming that Manohar has won ₹20 [2]
lakhs in a survey done online. In order to claim the prize money, he was required to answer few security
questions such as his Name, Account number, PAN card details, Phone number and OTP for verification
purposes. For this, he had to click on the link provided in the email.
Answer the following questions:
i. Should Manohar give the required details to the company?
ii. What is the activity depicted above?
 iii. What should he do with this email?
27. Write python code to create the following series using Dictionary: [2]
101 Harsh
102 Arun
103 Ankur
104 Harpahul
105 Divya
106 Jeet
28. Kavyanjali, a chemical analyst, needs to arrange data of few elements in the form of two series containing [2]
symbols and their atomic numbers respectively. Thereafter, the data of these two series has to be arranged and
displayed in the form of Data Frame as shown below:

Symbol Atomic Number

Hydrogen H 1

Helium He 2

Lithium Li 3

Beryllium Be 4

Help her in writing suitable Python code to complete the task.

OR
Write single line Pandas statement to declare a Pandas series named SR having dataset as:
{1:'one', 2:'two', 3:'three'}
Section C
29. While dealing with string data type in MySQL, its observed that sometimes unnecessary space character comes [3]
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.
30. What will be the output of the given function: [3]
i. SELECT INSTR('Informatics', 'mat');
ii. SELECT INSTR ('Computers', 'pet');
iii. Select instr("good morning to all", "or")
OR
Which type of MySQL function accepts only numeric values? Give the name of some functions of that type.
31. Write a program to change the order of a DataFrame columns. [3]
e.g. Original DataFrame

Col1 Col2 Col3

0 10 40 70

1 40 50 80

2 30 60 90

3 40 70 0

4 50 80 10
 After altering col1 and col3

Col3 Col2 Col1

0 70 40 10

1 80 50 40

2 90 60 30

3 0 70 40

4 10 80 50

32. Consider a Table "PETDATA" with the following data: [3]

Table : PETDATA

Id Pname Breed LifeSpan Price Discount

101 Adi Golden Retriever 15 16000 5

202 Candy Boxer 11 22000 10

303 Dazzler Bulldog 10 18000 NULL

404 Cooper Yorkshire Terrier 16 20000 12

505 Akira Pug NULL 25000 8

Write SQL queries for the following:

a. Display all the pet names in uppercase.
b. Display the total price of all the pets.
c. Display the average discount available on all the pets.
OR
Write the names of SQL functions to perform the following operations:
a. Display name of the Month from your date of birth.
b. Convert email-id to lowercase.
c. Count the number of characters in your name.
Section D
33. Read the text carefully and answer the questions: [4]
Consider the following Data Frame df and answer questions

A B C

DEPT CS PROD MEDICAL

EMPNO 101 102 103

ENAME ABC PQR LMN

SALARY 200000 100000 20000

(a) Write code to delete column B.

(b) Write the output of the below code
print(df.tail(2))
(c) Write code to delete row salary.
 (d) Change the value of column A to 100.
34. Read the text carefully and answer the questions: [4]
Expertia Professional Global (EPG) in an online corporate training provider company for IT related courses. The
company is setting up their new campus in Mumbai. You as a network expert have to study the physical
locations of various buildings and the number of computers to be installed. In the planning phase, provide the
best possible answers for the queries raised by them.
Physical locations of the buildings of EPG

Building to building distance (in metre)

From To Distance

Administrative Building Finance Building 60

Administrative Building Faculty Studio Building 120

Finance Building Faculty Studio Building 70

Expected computers to be installed in each building

Buildings Computers

Administrative Building 20

Finance Building 40

Faculty Studio Building 120

(a) Suggest the most appropriate building, where EPG should plan to install the server.
(b) Suggest the most appropriate building to building cable layout to connect all three buildings for efficient
communication.
(c) Which type of network out of the following is formed by connection the computers of these three
buildings?

a) MAN b) Wifi

c) WAN d) LAN
(d) Which wireless channel out of the following should be opted by EPG to connect to students of all over the
world?

a) Satellite b) Infrared

c) Wired d) Microwave
OR
Read the text carefully and answer the questions: [4]
 Workalot consultants are setting up a secured network for their office campus of Gurgaon 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 Mumbai.
Answer the questions after going through the building positions in the campus and other details, which are given
below:

Distance between various buildings

Building GREEN to Building RED 110 m

Building GREEN to Building BLUE 45 m

Building BLUE to Building RED 65 m

Gurgaon Campus to Head Office 1760 km

Number of computers

Building GREEN 32

Building RED 150

Building BLUE 45

Head Office 10

(a) Suggest the most suitable place (i.e. building) to house the server of this organisation. Also, give a reason
to justify your suggested location.
(b) Suggest a cable layout of connections between the buildings inside the campus.
(c) Suggest the placement of the following devices with justification:
i. Switch
ii. Repeater
(d) The organisation is planning to provide a high speed link with its head office situated in the Mumbai using
a wired connection. Which of the following cables will be most suitable for this job?

a) Optical fibre b) Ethernet cable

c) Co-axial cable d) Cable

Section E
35. Consider a table ITEM with the following data: [5]

S.No. Item name Type Stock date Price Discount

1 Eating Paradise Dining Table 19-02-2002 11500⋅ 58 25

2 Royal Tiger Sofa 22-02-2002 31000⋅ 67 30

 3 Decent Office Table 01-01-2002 25000⋅ 623 30

4 Pink Feather Baby Cot 20-01-2001 7000⋅ 3 20

5 White Lotus Double Bed 23-02-2002 NULL 25

Write SQL queries using SQL functions to perform the following operations:
i. Display the first 3 characters of the Itemname.
ii. Display the month name from the Stockdate.
iii. Display the total price of the whole stock.
iv. Display the average Price of all the stocks.
v. Display all the Price round off up to 2 decimal places.
36. Consider the dataframe medaltally. Here header and index arguments are True; Hence the index and column [5]
labels are written to the csv file processed_medaltally.csv.
37. You are provided with the following data on the number of students who participated in a programming [5]
competition over the years:

Year Participants

2018 150

2019 180

2020 210

2021 250

Create a bar graph to visualize the growth in participants over the years.
OR
Draw the approximate graph for the following code.

import matplotlib.pyplot as plt

x=[2,5,7]
y=[1,5,9]
plt.plot(x, y)
plt.xlabel ('x-axis')
plt.ylabel('y-axis')
plt.title('Data Visualization')
plt.show()