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/08 Set ~ 8
Roll No. Q.P Code 15/8/8
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]
In DataFrame, name() function is used to rename any index, column or row.
2. Which of the following method can be used to add formatted slice percentage to Pie Chart? [1]

a) labels b) slice

c) colors d) autopct
3. Which of the following will you suggest to establish the real-time textual communication between the people. [1]

a) Chatting b) E-mail

c) Real time communication is not possible d) Video Conferencing

4. What will be the order of the data being sorted after the execution of given query? [1]
SELECT * FROM STUDENT ORDER BY ROLL_NO;

a) Custom Sort b) Sequential

c) Ascending d) Descending
5. ________ gives you right to exclude others from making, selling, using or importing a particular product or [1]
service.

a) Trademark b) Copyright
 c) Patent d) Plagiarism
6. Which of the following is the online textual or multimedia conversation? [1]

a) Conference call b) HTML

c) Chatting d) VoIP
7. Which of the following website is not used for job search? [1]

a) myspace b) naukri.com

c) monster.com d) recruitment.com
8. State true or false: [1]
pos is an integer indicating the length of the substring.
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. Technology not protected by copyright and available to everyone, is categorized as: [1]

a) Shareware b) Open Source

c) Proprietary d) Experimental
11. Which of the following are correct aggregate functions in SQL? [1]
a. AVERAGE()
b. MAX()
c. COUNT()
d. TOTAL()

a) (c) and (d) b) (a) and (d)

c) (a) and (b) d) (b) and (c)

12. What is the full form of SQL? [1]

a) Simple Query Language b) Structured Query List

c) Structured Query Language d) Simple Query List

13. Which of the following is an advantage of proprietary software? [1]

a) Not as customizable b) It is usually free

c) thoroughly tested because people are paying d) Can sometimes be to generate for specialist
to use it purposes
14. After practicals, Atharv left the computer laboratory but forgot to sign off from his email account. Later, his [1]
classmate Revaan started using the same computer. He is now logged in as Atharv. He sends inflammatory email
messages to few of his classmates using Atharv’s email account. Revaan’s activity is an example of which of the
following cybercrime?

a) Plagiarism b) Hacking

c) Cyber bullying d) Identity theft

15. Statement (A): A bar chart represents categorical data with rectangular bars. [1]
 Statement (B): It is an accurate graphical representation of the distribution of numerical data.

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

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

incorrect.
16. Aggregate functions can be used in the select list or the ________ clause of the select statement. [1]
They cannot be used in a ________ clause.

a) Group by, having b) Group by, where

c) Having, where d) Where, having

17. E-waste is harmful to the environment and human health if not properly treated or disposed of, therefore they [1]
must be handled with care. What are the health hazards which can be caused by E-waste?

a) Lung cancer b) All of these

c) Brain damage d) DNA damage

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. HAVING is used in conjunction with [1]

a) WHERE b) GROUP BY clause

c) Aggregate functions d) Aggregate by clause

20. Assertion(A): The act of presenting someone else’s work or idea as your own is Plagiarism. [1]
Reason( R): Accessing someone’s information without their permission is Plagiarism.

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 perform mathematical operations on two series objects of different size but not on two 1 [1]
D arrays of different size.
Reason (R): if two series are not aligned NaN are generated but in case of arrays no concept of NaN and hence
operations fail to perform.

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 page does not change until the developer modifies them? [2]
OR
Identify the following devices
i. A device that is used to connect different types of networks. It performs the necessary translation so that the
connected networks can communicate properly.
ii. A device that converts data from digital bit stream into an analog signal and vice-versa.
23. What will be the output of the given function: [2]
SELECT LTRIM(' INFORMATICS ');
24. Write an example of MONTH() function. [2]
25. Consider the following table BOOK. [2]

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 CONCAT (Author, Publication) FROM BOOK WHERE Price=250;

OR
What will be the output of the given function:
SELECT TRIM(' INFORMATICS ');
26. What do you understand by the term Hacking? Write any two measures that one should take to avoid being the [2]
victim of hacking.
27. Give the output: [2]
import pandas as pd
import numpy as np
data =np.arange(10,15)
s =pd.Series(data)
print(s)
28. Write the output of the following code: [2]

import pandas as pd
data=pd.DataFrame()
print(data)

OR
Give the output:
 import pandas as pd
name=['Raj', 'Ankur', 'Harsh']
p=pd.Series(name,index=[2,5,6])
print(p)
p1=p.reindex([2,5])
print(p1)

Section C
29. Predict the output of the following SQL queries: [3]
i. SELECT TRIM(" ALL THEBEST ");
ii. SELECT POWER(5,2);
iii. SELECT UPPER(MID("start up india", 10));
30. What will be the output of the following? [3]

i. SELECT POWER(5, 3);

ii. SELECT ROUND(2.67, 1);

iii. SELECT RIGHT('CALCUTTA', 5);

iv. SELECT DAYOFMONTH('2014-02-25');

OR
What will be the output of the given function:
i. SUBSTR('INFORMATICS PRACTICES',3,4);
ii. SELECT SUBSTRING('Informatics',3);
iii. SELECT SUBSTRING('Computers', -3);
iv. SELECT SUBSTRING('Computers', -5, 3);
v. SELECT MID('Informatics',3,4);
31. Write the output of the following code [3]

import pandas as pd
data = {'a' : pd. Series ([20, 85, 46, 23, 56],
index = [1, 2, 3, 4, 5]),
'b': pd.Series ([33, 45, 57, 12, 34, 82, 49],
index = [1, 2, 3, 4, 5, 6, 7])}
df = pd.DataFrame (data)
print(df)

32. Ankit, a database administrator, has grouped records of a table with the help of GROUP BY clause. [3]
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.
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]
Consider the following Data Frame df and answer questions.

Population School Hospitals

chennai 40 200 500

delhi 10 250 200

kolkatta 30 400 100

mumbai 20 350 300

(a) Display the name of city whose population >=20 range of 12 to 20.
(b) Write command to set all values of df as 0.
(c) Display the df with rows in the reverse order.
(d) Display the df with only columns in the reverse order.
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. Write suitable SQL query for the following: [5]
i. Returns the value of 5 raised to the power of 2
ii. Rounds 5.23 to zero decimal place
iii. Divides 1250 by 25 and gives the remainder
iv. Convert the string INFORMATICS in lowercase
v. Convert the string "informatics" in uppercase
36. Consider the following DataFrame 'mdf'. [5]

Rollno Name English Hindi Maths

0 1 Aditya 23 20 28

1 2 Balwant 18 1 25

2 3 Chirag 27 23 30

3 4 Deepak 11 3 7

4 5 Eva 17 21 24

A. Write Python statements for the DataFrame 'mdf':

i. To display the records of the students having roll numbers 2 and 3.
ii. To increase the marks of subject Math by 4, for all students.
B. Write Python statement to display the Rollno and Name of all students who secured less than 10 marks in
Maths.
OR
(Option for Part B only)
Write Python statement to display the total marks i.e., sum of marks secured in English, Hindi and Maths for all
students.
37. Consider the following graph. Write the Python code to plot it. Also add the Title and Label for X and Y axis. [5]
Use the following data to draw the graph.

Class Marks

7 83

8 75

9 81

10 72

11 88

12 86
 OR
Write the code to display the following graph.