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/15 Set ~ 15
Roll No. Q.P Code 15/15/15
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]
"POST requests should always be used for sensitive data’’
2. The different kinds of plot created using [1]

a) plotlib b) matplot

c) matplotlib d) matliplot
3. ________ is an online service that enables you to publish your website or web application on the internet. [1]

a) Web server b) web page

c) Web Browser d) Web Hosting

4. Write the output of the following SQL command: [1]
select round(3456.885, 2);

a) 3456.89 b) 3400

c) 3456.88 d) 3500
5. Rupam created an assistive device for the blind. This device is very helpful for the blind and people with low vision. Now, she wants that no one should copy her innovation. [1]
What should she do?

a) Get the trademark for her invention b) Get the copyright for her invention

c) Get the license for her invention d) Get the patent for her invention
6. Which of the following topologies is very efficient and all nodes are connected to a central hub? [1]

a) Ring b) Tree

c) Bus d) Star
7. The first network is [1]

a) Internet b) NSFnet

c) NET d) ARPANET
8. State true or false: [1]
In TRUNCATE (M, N), M is the number to be truncated.
9. A ________ is a collection of interconnected ________ designed with a goal in mind. [1]

a) server, client b) web browser, webpage

c) website, webpage d) webpage, website

10. Which of the following can be called as cyber-crime? [1]

a) Harassing someone over internet b) Stealing someone’s computer

c) Downloading copyright free movies over internet d) Sending emails to known people
11. If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default [1]

a) There is no default value b) There is default value

c) DESC d) ASC
12. Which SQL function is used to count the number of rows in a SQL query? [1]
 a) COUNT() b) NUMBER()

c) SUM() d) COUNT(*)
13. Digital footprint are not created: [1]

a) When we send e-mail b) when we create our e-mail address

c) when we do online shopping d) when we watch youtube videos

14. Sourabh has to prepare a project on “Digital India Initiatives”. He decides to get information from the Internet. He downloads three web pages (webpage 1, webpage 2,webpage [1]
3) containing information on Digital India Initiatives. Which of the following steps taken by Sourabh is an example of plagiarism or copyright infringement?
i. He read a paragraph on “Digital India Initiatives” from webpage 1 and rephrased it in his own words. He finally pasted the rephrased paragraph in his project.
ii. He downloaded three images of “Digital India Initiatives” from webpage 2. He made a collage for his project using these images.
iii. He downloaded “Digital India Initiative” icon from web page 3 and pasted it on the front page of his project report.
iv. All of these

a) Option (i) b) Option (ii)

c) Option (iv) d) Option (iii)

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. An aggregate function performs a calculation on ________ and returns a single value. [1]

a) double value b) no value

c) multiple values d) single value

17. Out of the following, which one will be altered or modified by a computer virus? [1]

a) Both Operating system and Speed of network connectivity b) Speed of network connectivity

c) Operating system d) Distance

18. Write the output of the given command: df1.loc[:0,'Name'] Consider the given dataframe. [1]

EmpCode Name Desig

0 1405 VINAY Clerk

1 1985 MANISH Works Manager

2 1636 SMINA Sales Manager

3 1689 RINU Clerk

a) 0 1405 VINAY Clerk b) Works Manager

c) Clerk d) VINAY
19. If column Marks contains the data set {25, 35, 25, 35, 38}, what will be the output after the execution of the given query? [1]
SELECT MARKS (DISTINCT) FROM STUDENTS;

a) 25, 35, 25, 35, 38 b) 25, 25, 35, 35

c) 25, 35, 38 d) 25, 25, 35, 35

20. Assertion (A): Someone has created a fake social media profile in the name of Saket. Saket is a victim of cyberstalking. [1]
Reason (R): Cyberstalking is a form of cybercrime.

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): import pandas as pd is used to import pandas library. [1]
Reason (R): It is a python library so it is to be imported for using its function.

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. Define the following terms: [2]
a. Plug-ins
b. Add-ons
OR
Distinguish between website and web browser.
23. Write the output of the following queries: [2]

i. mysql >SELECT POW(-6,3);

ii. mysql >SELECT YEAR('2014-02-04');

24. A numeric data field NUM contains 34786.684. Write a command to round off NUM to. [2]
 i. Whole number
ii. Upto 1 decimal place.
25. Consider the table Patient given below and write SQL commands. [2]
Table : Patient

Patientid Name City Phone Dateofadm Department

1000001 Ritvik Garg Delhi 68476213 2021-12-10 Surgery

1000002 Rahil Arora Mumbai 36546321 2022-01-08 Medicine

1000003 Mehak Bhatt Delhi 68421879 2022-02-02 Cardiology

1000004 Soumik Rao Delhi 26543266 2022-01-11 Medicine

1000005 Suresh Sood Bangalore 65432442 2021-03-09 Surgery

i. Display the details of all patients who were admitted in January.

ii. Count the total number of patients from Delhi.
iii. Display the last 2 digits of the Patientid of all patients from Surgery Department.
OR
In how many ways, we can find the current date using MySQL?
26. Define the content management system of digital property right. [2]
27. Give the output: [2]

import pandas as pd
name=['Raj', 'Ankur', 'Harsh']
p=pd.Series(name, index=[2,5,6])
print(p)
# Reindex the series and create a new series variable
p1=p.reindex([6,2,5])
print (p1)

28. Give the output

import pandas as pd
Dic={'empno' (101, 102, 103, 104, 105, 106), 'grade':('a','b','a','c','b','c'), 'dept': ('sales', 'pur', 'mar', 'sales', 'pu
df=pd.DataFrame(Dic)
print(df.tail())

OR
Which function or keyword is used to delete a column?
Section C
29. Predict the output of the following SQL queries: [3]
a. SELECT LENGTH("GOOD LUCK");
b. SELECT POWER(3, 3);
c. SELECT UPPER("examination");
30. Consider the following table: PRODUCT [3]
Table: PRODUCT

PID PNAME PRICE QUANTITY

P1001 Eraser 10.50 5

P1002 Ball Pen 15.00 2

P1003 Gel Pen 25.10 3

P1004 Ruler 5.00 1

Find the output of the following SQL queries:

i. SELECT 10+ MOD(QUANTITY,3) FROM PRODUCT WHERE PNAME = "Eraser";
ii. SELECT ROUND(PRICE, 2)*QUANTITY FROM PRODUCT WHERE QUANTITY > 2;
iii. SELECT UCASE(RIGHT(PNAME,2)) FROM PRODUCT;
OR
Mention the type of the functions given below with their purpose.
i. CHAR()
ii. TRUNCATE()
iii. DAYOFMONTH()
iv. LEFT()
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 the table ‘FANS’ and answer the following. [3]

FAN_ID FAN_NAME FAN_CITY FAN_DOB FAN_MODE

F001 SUSHANT MUMBAI 1998-10-02 MAIL

F002 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:

i. To display the details of fans in descending order of their DOB
ii. To count the total number of fans of each fan mode
iii. To display the dob of the youngest fan
OR
Predict the output of the following SQL queries:
i. SELECT TRIM(" ALL THEBEST ");
ii. SELECT POWER(5,2);
iii. SELECT UPPER(MID("start up india", 10));
Section D
33. Read the text carefully and answer the questions: [4]
HR department of ABCTech has created following dataframe to store data about salaries and bonus paid to their employees:

import pandas as pd
import numpy as np
d1={'EName':['Kavita', 'Sudha', 'Garima']']', 'Sal':[50000, 60000, 55000], 'Bonus':[3000, 4000, 5000]}
Df1=pd.DataFrame(d1)

Choose the Python statement using suitable functions for the following tasks.
(a) Display the columns Sal and Bonus.
(b) Display the details of employee Komal.
(c) Display the details of the last employee.
(d) Add a new column named 'Email' with the value "abc@gmail.com".
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. Briefly explain the string functions with atleast one example. [5]
36. Write the code in Pandas to create the following DataFrames [5]

df1

Mark1 Mark2

0 30 20

1 40 45

2 15 30
 3 40 70

df2

Mark1 Mark2

0 10 15

1 20 25

2 20 30

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.
37. What are the different parts of a plot in Matplotlib? [5]
OR
Write a Python code to draw the following bar graph representing the average marks secured by each student in Term-2 Exam. Add the Title and Label for X-axis and Y-axis. Use the
following data to draw the graph:

Names Average Marks

Ruby 84

Yugesh 92

Vishesh 45

Rakesh 72