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/12 Set ~ 12
Roll No. Q.P Code 15/12/12
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]
List and tuple can be easily converted into Series by Series() method.
2. Which method will be add inside the file to display plot? [1]

a) show() b) execute()

c) plot() d) display()
3. Which of the following is a text based web browser? [1]

a) Lynx b) All of these

c) Safari d) Opera
4. Consider the Club (coachid, coachname, sport, dateofapp, pay). [1]
List names of all coaches with their date of appointment in descending order.

a) Select coachname, dataofapp from club b) Select * from club order by dateofapp
order by dateofapp DSC DESC

c) Select coachname, dataofapp from club d) Select * from club order by dateofapp DSC
order by dateofapp DESC
5. Which of the following is the effect of mismanaged e-waste? [1]

a) Air pollution b) Sea Pollution

 c) All of these d) Global warming
6. The length of a network segment in a LAN network is more than 100 metres. Select the device to be connected [1]
to maintain the strength of signal:

a) Router b) Repeater

c) Switch d) Gateway
7. ________ is a service that allows to put a website or a web page on the Internet. [1]

a) Web Hosting b) Domain Name System

c) Web Server d) Web Browser

8. State true or false: [1]
In TRUNCATE (M, N), M is the number to be truncated.
9. In the ________ field of the e-mail, enter the recipients whose address you want to hide from other recipients. [1]

a) All of these b) To

c) Carbon Copy d) Blind Carbon Copy

10. Which one of the following is not a malware? [1]

a) Computer virus b) Spam

c) Worm d) Application Software

11. Which of the following keyword sorts the records in ascending order by default? [1]

a) NUMBER BY b) GROUP BY

c) HAVING d) ORDER BY
12. Which of the following is not a valid aggregate function in MYSQL? [1]

a) MAX ( ) b) SUM ( )

c) COUNT ( ) d) LEN ( )
13. With the outset of Covid-19, schools started online classes but due to continuous online classes, students health [1]
issues also started. Health practitioner advised the parents to follow a few health tips. Which of the following
health tip should not be suggested?

a) The sitting posture should be correct. b) To protect the eyes the gadgets should be
placed above eye level.

c) Breaks should be taken in between the d) Wash the eyes regularly.

online classes.
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): In Python, Exclusive libraries can be used for graphical or visual representation of information [1]
and data using elements like charts, graphs and maps etc.
Statement (B): Matplotlib is a python package for 2D plotting that generates production quality graphs.

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

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

incorrect.
16. A patent protects an invention for ________ years, after which it can be freely used. [1]

a) 20 b) 30

c) 40 d) 10
17. The ________ has issued guidelines for the proper handling and disposal of e-waste. [1]

a) all of these b) central pollution control board

c) central e-waste management board d) waste management and maintenance

authority
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. Which of the following SQL function returns the number of values in the specified column ignoring the NULL [1]
values?

a) COUNT(columnname) b) LENGTH(*)

c) LENGTH(columnname) d) COUNT(*)
20. Assertion (A): Intellectual property rights are the rights given to persons over the creations of their minds. [1]
Reason (R): Intellectual Property Rights protect the use of information and ideas that are of commercial value.

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): Boolean indexing is a type of indexing. [1]
Reason (R): DataFrame.loc(False) function can be used to find the relative values where index value is False.

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. What are Cookies? How can we disable Cookies? [2]
OR
Explain the Netscape enterprise web server.
23. Predict the output of the following queries: [2]

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

ii. mysql >SELECT DATE('2009-1-21 02:01:04');

24. Find the output of the following SQL queries: [2]

a. SELECT ROUND(21.341, 2);
b. SELECT MOD(10, 3);
25. Can we use where clause after Group By clause? Name the clause which is used to restrict the number of records [2]
returned by the Group By clause.
OR
Which type of output does the following functions return?
i. DATE()
ii. YEAR()
iii. DAYNAME()
iv. NOW()
26. Give some examples of computer worms. [2]
27. Give the output: [2]
import pandas as pd
s =pd.Series(10, index=[5,6,7,9])
print(s)
28. Consider a dataframe Travel created with the following information. Write single line Pandas statements for (i), [2]
(ii) and (iii):

T_Id Type Amount

0 T_01 TO 550

1 T_02 FROM 300

2 T_03 TO 280

3 T_02 FROM 250

4 T_03 FROM 410

i. To display the maximum value of the column Amount

ii. To display the sum of Amounts for each Type separately (i.e. sum of TOs and sum of FROMs)
iii. To display the mean for the column Amount
OR
Write the output of the following :
import pandas as pd
S1 = pd.Series(range(100, 150, 10), index=[x for x in "My name is Amit Gandhi".split()])
 print(S1)
Section C
29. What will be the output of the given function: [3]
i. Select POW(2,4);
ii. SELECT POW(2,-2);
iii. SELECT POW(-2,3);
30. Renu is working with functions of MySQL. Explain her following. [3]
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?
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. Write a small Python code to create a DataFrame with headings (a and b) from the list given below: [3]
[[10, 20], [30, 40], [50, 60], [70, 80]]
32. 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.
OR
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
Section D
33. Read the text carefully and answer the questions: [4]
A clerk in the exam department has created the following dataframe df in order to calculate the final result for
the students of commerce stream.

Name English Physics Accounts

S.No. 1 vinay 88 77 69
 S.No. 2 adith 92 62 88

S.No. 3 mihir 79 71 74

S.No.4 akanksha 84 80 81

It was later found that by mistake the clerk had mixed the marks of commerce and science stream. Help the class
teacher to rectify the mistakes and calculate the final result.
(a) Marks for physics must be removed from the commerce section dataframe.
(b) Add columns BST and Economics with marks of students given as [78,61,54,81] and [83, 85, 76, 91].
(c) Add student the data of student Raj, his score for the subject is as follows:
Eng: 88, BST: 91, Accounts: 93, Economics: 87
(d) Roll number 2 has scored 82 instead of 92 in English.
34. Read the text carefully and answer the questions: [4]
Elpis Education Service Ltd. is an educational organisation. It is planning to set up its India campus at Nepal
with its head office at Mumbai. The Nepal campus has 4 main buildings-
ADMIN, ENGINEERING, BUSINESS and MEDIA.
You as a network expert have to suggest the best network-related solutions for their problems raised in
Questions, keeping in mind the distance between the buildings and other given parameters.

Shortest distance between various buildings

ADMIN To ENGINEERING 50 m

ADMIN To BUSINESS 80 m

ADMIN To MEDIA 45 m

ENGINEERING To BUSINESS 60 m

ENGINEERING To MEDIA 50 m

BUSINESS To MEDIA 45 m

Mumbai Head Office To Nepal Campus 2175 m

Number of computers installed at various buildings are as follows

ADMIN 110

ENGINEERING 75

BUSINESS 40

MEDIA 10

Mumbai Head Office 20

(a) Suggest the most appropriate location of the server inside the Nepal Campus (out of 4 buildings), to get the
 best connectivity for maximum number of computers. Justify your answer.
(b) Suggest and draw the cable layout to efficiently connect various buildings within the Nepal Campus for
connecting the computers.
(c) 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.
(d) Which of the following will you suggest to establish the online face-to-face communication between the
people in the ADMIN office of Nepal Campus and Mumbai Head Office?

a) Video Conferencing b) Cable TV

c) Text Chat d) E-mail

OR
Read the text carefully and answer the questions: [4]
XEED Private Ltd., Delhi is a company that deals with educational toys. They have different divisions HR (A1),
Sales (A2), Production (A3) and Marketing (A4).
The layout of the Delhi branch is:

The company also has a branch in Bangalore. The management wants to connect all the divisions as well as all
the computers of each division (A1, A2, A3, A4).
Distance between the wings are as follows:

A3 to A1 25 m

A1 to A2 40 m

A2 to A4 25 m

A4 to A3 20 m

A3 to A2 30 m

A1 to A4 170 m

Delhi Head Office to Bangalore Office 2154 km

Number of computers in each of the wing:

A1 50

A2 40

A3 110

A4 60

(a) Suggest the topology and draw the most suitable cable layout for connecting all the divisions of Delhi
branch.
(b) Suggest the kind of network required (out of LAN, MAN, WAN) for connecting Production (A3) with the
Bangalore branch.
(c) Which device can be used to connect the network of Delhi Branch to the Internet? This device should be
 able to receive data, analyse it and then transmit it to the network.
(d) Suggest the placement of switch/hub with justification.
Section E
35. Consider the following table Schooldata: [5]
Table: Schooldata

Admno Name Grade Club Marks Gender

20150001 Sargam Singh 12 STEM 86 Male

20140212 Alok Kumar 10 SPACE 75 Male

20090234 Mohit Gaur 11 SPACE 84 Male

20130216 Romil Malik 10 READER 91 Male

20190227 Tanvi Batra 11 STEM 70 Female

20120200 Nomita Ranjan 12 STEM 64 Female

Write SQL queries for the following:

(i) Display the average Marks secured by each Gender.
(ii) Display the minimum Marks secured by the students of Grade 10.
(iii) Display the total number of students in each Club where number of students are more than 1.
OR
(Option for Part (iii) only)
(iii) Display the maximum and minimum marks secured by each gender.
36. Write a code to create the following DataFrame [5]

RNo Name Marks

SecA 21 Abhi 69.5

SecB 45 Anjali 84.5

SecC 23 Tushar 70.0

SecD 17 Mahi 78.0

Write the commands to do the following operations on the DataFrame given above:
i. To add new section SecE with the values [08, 'Kushal', 80.0].
ii. To modify the marks of SecC to 68.5.
37. Write a Python code to draw the following bar graph representing the average marks secured by each student in [5]
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
 OR
You are provided with the following data on the number of students who participated in a programming 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.