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

 Please check that this question paper contains 08 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 datapoints plotted on a graph are called ________. [1]

a) Ticks b) Markers

c) Values d) Pointers
3. Geometric arrangement of devices on the network is called [1]

a) media b) protocols

c) LAN d) topology
4. What is the meaning of HAVING clause in SELECT query. [1]

a) To filter out the row b) To filter out the column groups.

c) To filter out the summary groups. d) To filter out the row and column values.
5. ________ stands for malicious software, is designed to infiltrate a computer system without the owner’s [1]
informed consent.

a) Attachments b) Spam

c) Malware d) Blog
 6. ________ is a software component that adds a specific feature to an existing computer program. [1]

a) Cookies b) Addon

c) All of these d) Plug in

7. The first page that we normally view at a website is called ________. [1]

a) Email b) Webpage

c) Webserver d) Home page

8. State true or false: [1]
The return value of CONCAT() has the same data type as the argument.
9. A ________ is a network device that can receive the data, analyse it and transmit it to other networks. [1]

a) Router b) Modem

c) Repeater d) Switch
10. Abhilasha forgot to sign out from her gmail id and Aditi used Abhilasha’s gmail id to send mail. This act of [1]
Aditi is considered as

a) piracy b) phishing

c) identity theft d) plagiarism

11. Which of the following will give the same answer irrespective of the NULL values in the specified column: [1]

a) MIN() b) SUB()

c) MAX() d) SUM()
12. Ravisha has stored the records of all students of her class in a MYSQL table. Suggest a suitable SQL clause that [1]
she should use to display the names of students in alphabetical order.

a) SORT BY b) GROUP BY

c) ORDER BY d) ALIGN BY
13. Which is not a measure to recycle your e-waste safely. [1]

a) Throw it in water or dig them in earth. b) Visit Civic institutions for recycling options.

c) Donate your electronics. d) Use certified e-waste recycler

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 line chart displays information as many series of data points called "Markers" connected by [1]
straight line segments.
Statement (B): plot(), cannot plot multiple lines in the same plot with different colour by default.

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

incorrect.
 c) Statement B is correct. d) Statement A is incorrect, but Statement B is
correct.
16. In SQL, ________ returns the month name from the specified date. [1]

a) MONTHNAME( ) b) MONTH( )

c) NOW( ) d) DATE( )
17. It is an act of copying another person’s idea, words or work and pretend that they are our own. [1]

a) Virus b) Copyright

c) Plagiarism d) IPR
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. What will be returned by the given query? [1]
SELECT ROUND(153.669,2);

a) 153.7 b) 153.66

c) 153.6 d) 153.67
20. Assertion (A): XYZ company making copies of the new movie DVD and send selling the copies without movie [1]
producer’s permissions. XYZ Company was seized by the cyber police on complaint given by movie producer.
Reason(R): piracy of the content comes under cyber crime.

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 cannot access more than one element of Series without slicing. [1]
Reason (R): More than one element of series can be accessed using a list of positional index or labeled index.

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. Why is a switch called an intelligent hub? [2]
OR
Write down the name of language which is commonly used to create a web page.
23. Write the output of the below SQL query. [2]
 mysql>SELECT ROUND(6.5675,2);

24. Give the syntax of the ORDER BY clause. [2]

25. Gopi Krishna is using a table EMPLOYEE. It has the following columns: [2]
Code, Name, Salary, Deptcode
He wants to display maximum salary departmentwise.
He wrote the following command:

SELECT Deptcode, MAX (Salary) FROM EMPLOYEE;

But he did not get desired result.

Rewrite the above query with necessary change to help him get the desired output.
OR
Predict the output of the following SQL queries from the given table: SCHOOLDATA
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

i. SELECT MAX(Percent) FROM SCHOOLDATA;

ii. SELECT LEFT(Gender,1),Name FROM SCHOOLDATA WHERE YEAR(Dob)=2005;
26. Which measure is used to avoid online scam? [2]
27. Give the output: [2]
import pandas as pd
s=pd.Series([10,20,30,40,50], index = ['a', 'b', 'c', 0, 1])
print(s.loc['a'])
print(s.loc[0])
28. How can you create a DataFrame? [2]
OR
Give the output:
import pandas as pd
M = [15, -10, 56, 39, -90, 15]
p = pd.Series(M)
print(p[0])
print(p[[0,3,4]])
Section C
29. What is the difference between the functions string and numeric? [3]
30. 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
What is the difference between the functions DAYNAME() and DAYOFWEEK()?
31. Consider the following DataFrame dfn [3]

A B C

Order 450 180 350

Purchase 330 550 610

Sell 250 410 380

Target 1050 980 1250

Write the output of the following statement.

i. dfn [['A', 'B']]
ii. dfn.loc ['Purchase', :]
32. Predict the output of the following SQL queries: [3]
a. SELECT LENGTH("GOOD LUCK");
b. SELECT POWER(3, 3);
c. SELECT UPPER("examination");
OR
Which SQL function is used to remove leading and trailing spaces from a character expression X, where X =
'INFORMATION
###PRACTICE####' (# denotes a blank space) and also give the output of X.
Section D
33. Read the text carefully and answer the questions: [4]
Consider the following Data Frame df and answer questions

ACC BST ECO IP

S1 90 91 92 93

S2 94 95 96 97

S3 98 99 100 100

S4 91 92 93 94
 (a) Create a new column total TOT by adding marks.
(b) Find the highest marks scored by student s1.
(c) Find the lowest marks scored by student s1.
(d) Find the highest marks in ACC.
34. Read the text carefully and answer the questions: [4]
Granuda consultants are setting up a secured network for their office campus at Faridabad 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 Kolkata.
Answer the questions after going through the building positions in the campus and other details, which are given
below.
Distance between various buildings

Building RAVI to Building JAMUNA 120 m

Building RAVI to Building GANGA 50 m

Building GANGA to Building JAMUNA 65 m

Faridabad Campus to Head Office 1460 km

Number of computers

Building RAVI 25

Building JAMUNA 150

Building GANGA 51

Head Office 10

(a) Suggest the most suitable place (i.e. block) 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 building 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 Kolkata using
a wired connection. Which of the following cable will be most suitable for this job?

a) All of these b) Co-axial cable

c) Ethernet cable d) Optical fibre

OR
Read the text carefully and answer the questions: [4]
Quick Learn University is setting up its academic blocks at Prayag Nagar and planning to set up a network. The
university has three academic blocks and one human resource centre as shown in the diagram below:
 Centre to centre distance between various blocks/centre is as follows:

Law Block to Business Block 40 m

Law Block to Technology Block 80 m

Law Block to HR Centre 105 m

Business Block to Technology Block 30 m

Business Block to HR Centre 35 m

Technology Block to HR Centre 15 m

Number of computers in each of the blocks/centre are as follows:

Law Block 15

Technology Block 40

HR Centre 115

Business Block 25

(a) Suggest the most suitable place (i.e. block/centre) to install the server of this university with a suitable
reason.
(b) Suggest an ideal layout for connecting these block/centre for a wired connectivity.
(c) Which device you will suggest to be placed/installed in each of these blocks/centre to efficiently connect
all the computers with in these blocks/centre?
(d) The university is planning to connect its admission office in the closest big city, which is more than 250
km from university, which type of network out of LAN, MAN or WAN will be formed? Justify your
answer.
Section E
35. Write the SQL queries which will perform the following operations: [5]
i. To display the year from your Date of Admission which is '2023-05-15'.
ii. To convert your email id '[email protected]' to lowercase.
iii. To remove leading spaces from a string 'my country'.
iv. To display current date.
v. To display the value of 106.
36. Write the code in Pandas to create the following DataFrame [5]

Name Designation Salary

1 Abhi DBA 35000

2 Vanshika Pragrammer 40000

3 Riya Tester 32000

 4 Chirag Content Writer 25000

5 Tushar Business Analyst 30000

6 Khushal Sales Executive 37000

7 Mahi Web Designer 42000

Write the commands to do the following operations on the DataFrame given above:
i. To select the column Designation.
ii. To change index label from 1 to E101, 2 to E102,... and so on.
37. Write a code to plot a bar chart to depict the birds in a city as shown below. [5]

OR
Consider the following graph. Write the code to plot it.