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/07 Set ~ 7
Roll No. Q.P Code 15/7/7
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]
List and tuple can be easily converted into Series by Series() method.
2. To give a title to x-axis, which of the following method is used? [1]

a) plt.xheader("title") b) plt.xlabel("title")

c) plt.xlabel.show("title") d) plt.xtitle("title")
3. Which of the following is a web browser? [1]

a) Coral Draw b) Apple Safari

c) MS word d) Adobe Photoshop

4. Which of the following is true about the HAVING clause? [1]

a) Acts exactly like a WHERE clause. b) Similar to the WHERE clause but is used for columns rather than
groups.

c) Similar to WHERE clause but is used for groups rather than rows. d) Similar to WHERE clause but is used for rows rather than columns.
5. Which of the following is suggested while browsing internet? [1]

a) Don’t save passwords b) Don’t click on unknown links

c) All of these d) Don’t share personal information

6. The connector used for networking is: [1]

a) RJ - 11 b) RI - 45

c) RI - 11 d) RJ - 45
7. There are numerous websites, which provide search facility for searching the contents on [1]

a) LAN b) Internet

c) Website d) Web page

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 of the following is feasible method to manage e-waste? [1]

a) Recycle b) Reuse

c) Reduce d) All of these

11. Select correct SQL query from below to find the temperature in increasing order of all cites. [1]

a) SELECT city FROM weather ORDER BY temperature; b) SELECT city, temperature FROM weather ORDER BY
temperature;

c) SELECT city, temperature FROM weather ORDER BY city; d) SELECT city, temperature FROM weather;
12. What is returned by INSTR('SEVEN POINT', 'P')? [1]

a) POINT b) 6

c) JAVAT d) 7
13. The cadmium used in semiconductors and registers can damage a human’s [1]

a) Neurological system b) Human eyes

c) kidney, heart d) Liver, bones & kidney

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 [1]
2,webpage 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): Bin are usually represented using rectangular bars with the length proportional to the values that they represent. [1]
Statement (B): They show what portion of the dataset falls into each category.

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

c) Statement A is correct, but Statement B is incorrect. d) Statement A is incorrect, but Statement B is correct.
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. What is the name of the IT law that India is having in the Indian legislature? [1]

a) India's Digital information technology DIT Act, 2000 b) The technology act, 2008

c) India's Information Technology IT Act, 2000 d) India's Technology IT Act 2000

18. Given the following csv file which of the command will correctly read the details into a dataframe from csv file sectors_economy.csv. [1]
sectors_economy.csv

1953-54 1970-71 1990-91 2014-15

Household 10 12 12 23

Agriculture 1 3 8 18

Industries 40 50 45 44

Transport 44 28 22 2

Service 5 7 13 13

a) pandas.read_csv('sectors_economy.csv', header = 1, index_col = 1) b) pandas.read_csv('sectors_economy.csv', header = 0, index_col = 0)

c) pandas.read_csv('sectors_economy.csv', header = 1, index_col = 0) d) pandas.read_csv('sectors_economy.csv', header = 0, index_col = 1)

19. Find the output of the following SQL queries: [1]

Select INSTR("Data Science","ie");

a) False b) 8

c) True d) -5
20. Assertion (A): Cyber Bullying refers to act of online harassment of someone by using online tools such as Internet, email, instant messages, chat rooms or social [1]
networking sites etc.
Reason (R): It is called harassing, demeaning, embarrassing, defaming or intimidating someone using modern technologies.

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): loc() is used to extract a subset of a data frame. [1]
Reason (R): Transpose of a data frame df can be obtained using df.T.

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. What is the role of plug-ins? [2]
OR
Explain the Homepage.
23. What is meant by NULL value in MySQL? [2]
24. What will be the output of the given function: [2]
SELECT LENGTH(‘#INFOR MATICS#’);
25. Harjat has created the table EMP in his database. [2]
Table: EMP

E_Id Name Dept Comm

E001 Ditya Admin 35000

E002 Uzair Production 42500

E003 Rajnikant Admin 21000

E004 Moushami Sales 23575

E005 Samantha Sales 37000

E006 Sunder Admin 43000

Now he wants to find the sum of commission earned by each department. He has executed the following query:
SELECT dept,sum(comm)
GROUP BY dept
FROM EMP;
But, he got an error. Rewrite the correct query after identifying the error(s).
OR
Find the output of the following SQL queries:
a. SELECT MID("YOUNG INDIA",5);
b. SELECT INSTR("MACHINE INTELLIGENCE","IN");
26. Give the examples of permissive license. [2]
27. Give the output: [2]

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

28. Write statement to modify a single cell in DataFrame. [2]

OR
Write python code to create the Series EMP with following data (using Dictionary)
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. A character expression name contains ‘try yourself’. Write a command to pick the following set of characters from it. [3]
i. First 3 characters
ii. From 3rd to 7th character
OR
Why we use Having clause?
31. Write the output of following code. [3]

import pandas as pd
import numpy as np
data = np.array (['Computer', 'SST', 'Science', 'English', 'Math', 'Hindi'])
a=pd.Series(data)
hd=a.head(4)
print("First output")
print(hd)
t1=a.tail(3)
print("Second output")
print(t1)

32. 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
Consider the following Table: ITEM :
Table : ITEM

ID INAME PRICE QTY

P1001 Sketch Pen 20.50 5

P1002 Roller Ball Pen 55.00 1

P1003 Gel Pen 25.10 3

P1004 Notebook 75.80 1

Find the output of the following SQL queries:

a. SELECT 10+ QTY FROM ITEM WHERE ID = "P1003";
b. SELECT PRICE*QTY FROM ITEM WHERE QTY < 2;
c. SELECT LEFT(INAME,3) FROM ITEM;
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 the output of print(len(df)).

(b) Write the output of print(df.count()).
(c) Write the output of print(df.count(1)).
(d) Write the output of print(min(df.loc['SALARY'])).
34. Read the text carefully and answer the questions: [4]
Trine Tech Corporation (TTC) is a professional consultancy company. The company is planning to set up their new offices in India with its hub at Hyderabad. As a network
adviser, you have to understand their requirement and suggest them the best available solutions. Their queries are mentioned as (i) to (v) below.
Physical locations of the blocks of TTC

Block to block distance (in metre)

Block (From) Block (To) Distance

Human Resource Conference 110

Human Resource Finance 40

Conference Finance 80

Expected number of computers to be in each block

Block Computers

Human Resource 25

Finance 120

Conference 90

(a) Which will be the most appropriate block, where TTC should plan to install their server?
(b) Draw a block to block cable layout to connect all the buildings in the most appropriate manner for efficient communication.
(c) What will be the best possible connectivity out of the following, you will suggest to connect the new set up of offices in Bangalore with its London based office.
Satellite Link
Infrared
Ethernet
(d) Which of the following device will be suggested by you to connect each computer in each of the buildings?
Switch
Modem
Gateway
OR
 Read the text carefully and answer the questions: [4]
Freshminds University of India is starting its first campus in Ana Nagar of South India with its centre admission office in Kolkata. The university has three major blocks
comprising of Office block, Science block and Commerce block is in 5 km area campus.
As a network expert, you need to suggest the network plan as per to the authorities keeping in mind the distance and other given parameters.

Expected wire distance between various locations

Office Block to Science Block 90 m

Office Block to Commerce Block 80 m

Science Block to Commerce Block 15 m

Kolkata Admission Office to Ana Nagar Campus 450 km

Expected number of computers to be installed at various locations in the university are as follows:

Office Block 10

Science Block 140

Commerce Block 30

Kolkata Admission Office 8

(a) Suggest the authorities, the cable layout amongst various blocks inside university campus for connecting the blocks.
(b) Suggest the most suitable place (i.e. block) to house the server for this university with a suitable reason.
(c) Suggest an efficient device form the following to be installed in each of the block to connect all the computers.

a) Modem b) Switch

c) All of these d) Gateway

(d) Suggest the most suitable (very high speed) service to provide data connectivity between admission office located in Kolkata and the campus located in Ana Nagar
form the following options:
Telephone line
Fixedline dial-up connection
Co-axial cable network
GSM
Leased line
Satellite connection
Section E
35. Explain the following SQL functions using suitable examples: [5]
i. LTRIM( )
ii. RTRIM( )
iii. INSTR( )
iv. MOD( )
v. TRIM( )
36. Write a Pandas program to sort the DataFrame first by Name in descending order, then by Score in ascending order. [5]
Sample DataFrame :

exam_data={'Name':['Abhi', 'Chirag', 'Tarim', 'Anjali', 'Mahi', 'Tushar', 'Shubham', 'Harsh', 'Vanshika', 'Kartik'],
'Score':[12.5, 9, 16.5, np.NaN, 9, 20, 14.5, np.NaN, 8, 19],
'Attempts':[1, 3, 2, 3, 2, 3, 1, 1, 2, 1],
'Qualify': ['Yes','No', 'Yes', 'No', 'No', 'Yes', 'Yes', 'No', 'No', 'Yes']}
labels=['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j']

37. Write the code for the following bar graph. [5]
 OR
Consider the following population data of Males and Females. for which we want to show the stacked bar plot. Write a code to plot a bar chart to depict the same.

city Male Female Total

Area A 20 17 37

Area M 30 19 49

Area B 12 15 27

Area N 8 7 15