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/11 Set ~ 11
Roll No. Q.P Code 15/11/11
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]
In DataFrame, name() function is used to rename any index, column or row.
2. Which are pros of data visualization? [1]

a) It can be misleading b) It can be accessed quickly by a wider audience

c) It can be distracting d) It can misrepresent information

3. The device used to connect two networks using different protocols is: [1]

a) Repeater b) Router

c) Gateway d) HUB
4. Which of the following function returns an integer that indicates the position of the first occurrence of the sub-string within the string? [1]

a) TRIM() b) LENGTH()

c) INSTR() d) RTRIM()
5. The practice of sending fraudulent communications that appear to come from a reputable source. It is usually done through email. The goal is to steal [1]
sensitive data like credit card and login information.

a) Licensing b) Bullying

c) Plagiarism d) Phishing
6. Which of the following is a collection of independent computers and other hardware interconnected by communication channels? [1]

a) Networking b) Computer

c) Transferring d) Sharing
7. Which of the following is peace of information stored in a form of a text file and that helps in customizing the displayed information, login, showing [1]
data based on user’s interests from the website?

a) Extension b) Cookies

c) Session d) Login
8. State true or false: [1]
pos is an integer indicating the length of the substring.
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. ________ is a licence that gives right opposite to copyright. [1]

a) IPR b) Copyleft

c) Left copy d) Digital copy

11. Write the output of the following SQL command. [1]
SELECT ROUND(47.89);

a) 50 b) 47.8

c) 48 d) 47.88
12. An aggregate function: [1]
a. Takes a column name as its arguments
b. May take an expression as its argument
c. Both takes a column name as its arguments and may take an expression as its argument
d. None of these

a) Option (a) b) Option (d)

c) Option (b) d) Option (c)

13. We need to exhibit proper manners and etiquettes while being online. Pick up one such net etiquette from the following: [1]

a) Feed the troll b) Do not share the expertise

c) Respect privacy and diversity d) Copyright violation

14. Sourabh has to prepare a project on “Digital India Initiatives”. He decides to get information from the Internet. He downloads three web pages [1]
(webpage 1, webpage 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. Read the statements given below and identify the right option to draw a histogram. [1]
Statement A: To make a histogram with matplotlib, we can use the plt.hist() function.
Statement B: The bins parameter is compulsory to create histogram.

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

c) Statement A is incorrect, but Statement 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. A category of software that spies of your computer activities is [1]

a) Spyware b) Freeware

c) Utilities d) De-ware
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 is the correct output of the following SQL command? [1]

SELECT ROUND (7876.4568, 2) ;

a) 7876.45 b) 7876.46

c) 7900 d) 7900.4568
20. Assertion (A): Privacy of sensitive data can be implemented by encryption. [1]
Reason(R): Encryption hides (Encodes) the details of the Actual data.

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): DataFrame.count() function will display the sum of the values from the data frame. [1]
Reason (R): axis=0, argument is to used to find sum column-wise.

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 structure of URL with example. [2]
OR
Explain the Webserver.
23. 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 LCASE (Author) FROM BOOK;

24. Which type of output does the following functions return? [2]
i. LENGTH()
ii. RTRIM()
iii. POW()
iv. SUBSTR()
25. To display the roll number, name and marks of all the students in descending order of their marks and ascending order of their names. [2]
OR
What will be the output of the given function:
SELECT DATE('2020-04-06 01:02:03');
26. What are the factors in rise of cyber crimes? [2]
27. In pandas, S is a series with the following result: [2]
S=pd.Series([5,10,15,20,25])
The series object is automatically indexed as 0,1,2,3,4. Write a statement to assign the series as a, b, c, d, e index explicitly.
28. What is the use of empty attribute of DataFrame? [2]
OR
What is the use of GroupBy function in Python Pandas?
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
Consider the following table: PRODUCT
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;
31. Write the code to create the following DataFrame [3]

Name Marks Subject

a Abhi 75 Maths

b Chirag 82 Science

c Tushar 69 English

d Mahi 70 Science

e Vanshika 92 Computer

32. Which type of MySQL function accepts only numeric values? Give the name of some functions of that type. [3]
OR
What will be the output of the following?

i. SELECT POWER(5, 3);

ii. SELECT ROUND(2.67, 1);

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

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

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]
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]
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
Section E
35. Write the SQL functions which will perform the following operations: [5]
i. To display the name of the weekday for your date of birth.
ii. To convert e-mail-id to lowercase.
iii. To count the number of characters in your name.
iv. To display the first character of your name.
v. To calculate the average marks secured by the class.
36. Explain the features of Python Pandas. [5]
37. Write the code to display the following 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