BHARATIYA VIDYA BHAVAN, KOCHI

TERM END EVALUATION 2023-2024

INFORMATICS PRACTICES (065)
Std XII MARKS:70
TIME: 3 hrs
General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each.
8. All programming questions are to be answered using Python Language only.

PART A
1. Which network topology connects all devices in a linear fashion? 1
a) Bus b) Star c) Ring d)Mesh
2. What is a pandas DataFrame? 1
a) A data structure for storing a single dimensional labeled array.
b) A 2-D, size-mutable and heterogenous tabular data structure.
c) A python module for mathematical operations.
d) A visualization library for data analysis.
3. Minimum number of arguments required in pandas Series function for creating a non-empty 1
series is ____________.
a) 0 b)1 c) 2 d) 3
4. In SQL, which function is used to display current date and time? 1
a) Date () b) Time () c) Current () d) Now ()
5. How many values will be there in array1, if given code is not returning any error? 1
>>> series4 = pd.Series(array1, index = [“Jan”, “Feb”, “Mar”, “Apr”])
a) 1 b) 2 c) 3 d) 4
6. To display the last 5 values of a dataframe df, you may write: 1
a) df.head(5) b) df.Tail() c) df.tail() d) df.Head()
7. Ananya wants to store her Term-I mark in a Series which is already stored in a NumPy array. 1
Choose the statement which will create the series with Subjects as indexes and Marks as
elements.

import pandas as pd
import numpy as np
Marks =np.array([30,32,34,28,30])
subjects = ['English','Maths','Chemistry','Physics','IP']
Series1= _______________________________

a) pd.Series(Marks,index=subjects) b) pd.Series(np.Marks,index=subjects)
c) pd.Series(index=Marks, subjects) d) pd.Series(Marks,index)
8. Which of the following attribute is used to assigns a name to the index of the Series. 1
a) name b) index c) index.name d) All of the above
9. In a DataFrame, Axis= 1 represents the elements 1
a) columns b)first column c) rows d) first row

1
10. Which of the following is the correct output for the following sql command : 1
Select round(6754.89)
a) 6754.9 b) 6750 c) 6754 d) 6755
11. Rajesh has purchased a new Smart TV and wants to cast a video from his mobile to his new 1
Smart TV. Identify the type of network he is using:
a) LAN b) WAN c) MAN d)PAN
12. The location of a resource on the internet is given by its _____ 1
a) Protocol b) URL c) e-mail address d) ICQ
13. It can be a software program or a hardware device that filters all data packets coming through 1
the internet or a network it is known as the_______:
a) Antivirus b) firewall c) cookies d) malware
14. What does the trim() function in mysql do? 1
a) Removes spaces from the beginning and end of a string
b) Adds spaces to a string
c) Counts the number of characters in a string
d) Replaces specific characters in a string
15. What will be the output of the following mysql command? 1
Select mod(pow(2,3),3);
a) 1 b) 2 c) 3 d) 4
16. Which module of matplotlib library is required for plotting a graph ? 1
a) Plot b) graphics c) matplot d) pyplot
Q. 17 and 18 are ASSERTION (A) and REASONING (R) based questions.
Mark the correct choice as
a) Both (A) and (R) are true and (R) is the correct explanation for (A).
b) Both (A) and (R) are true and (R) is not the correct explanation for (A).
c) (A) is true and (R) is false.
d) (A) is false but (R) is true.
17. Assertion (A) : The output of addition of two series will be NaN, if one of the elements or 1
both the elements have no value(s).
Reason (R) : While performing mathematical operations on a series, by default all missing
values are filled in with 0.
18. ASSERTION(A) : A histogram is basically used to represent data provided in the 1
form of groups spread in non-continuous ranges
REASON(R) : matplotlib.pyplot.hist() function is used to compute and create
histogram of a variable.
PART B

19. Explain the terms web page and home page? 2

20. What is the purpose of Order By clause in SQL? Explain with the help of suitable example. 2
21. Write a program to create a series object that stores the number of students in each division of 2
class 12 of your school.
Assume there are 4 divisions A,B,C,D and 40,44,42,41 students respectively.
22. What are plug-ins? Give examples of any 2 plug-ins 2
23. What are cookies? How can we disable cookies? 2
24. What is the function of a gateway? 2

2
25. Consider the dataframe rainfall 2

Write python statement for the following:

i. Set the row labels as 2018,2019,2020,2021,2022.
ii. List the column names of the dataframe rainfall.
SECTION - C

26. Consider the table Training 3

Predict the output for the following:

i. Select substr(City,2,4) from training where topic<> “Cyber security”;
ii. Select name from training where instr(email_id, “@”)>4;
iii. Select mod(fee,10) from training;
27. Write a Python code to create the following DataFrame df : 3
Population Schools Hospitals
Chennai 40 200 500
Delhi 10 250 200
Kolkata 30 400 100
Mumbai 20 350 300
28. Consider the dataframe Stock

Name Price 3
101 Fridge 50000
201 Washing Machine 24000
301 Microwave 20000
i. Add a column called Discount% with the following data: [20,20,5].
ii. Add a new item named ‘Air conditioner' having price 35000 and discount 10% at
index 401.
iii. Remove the column Discount.
29. Define the following: 3
i. Switch
ii. Repeater
iii. Modem
30. Write the output of the following SQL queries: 3
i. Select length(### “Vasudhaiva#Kutumbakam”); (# represent a space)
ii. Select pow(4,2);
iii. Select round(980.8,-2);

3
 SECTION D

31. Consider the table student: 5

Write SQL queries to perform the following operations:

i. Display the first 3 characters of all names in uppercase.
ii. Display the details of the students of commerce stream.
iii. Display the details of those students who are born in the month of June.
iv. Display the details of those students who pay fees between 10000 and 20000.
v. Display the names of the students whose marks are not available.
32. Prime Computer Services LTD is an international educational organization. It is planning to 5
set up its India campus at Mumbai with its head office in Delhi. The Mumbai office campus
has four main buildings – ADMIN, ACCOUNTS, EXAMINATION and RESULT.
You as a network expert have to suggest the best network related solutions for their problems
(i) to (v), keeping in mind the distances between the buildings and other given parameters.

Examination Admin
Delhi Head Office

Accounts Result

Shortest distances between various buildings:

Admin to Accounts 55m

Admin to Examination 90m
Admin to Result 50m
Accounts to Examination 55m
Accounts to Result 50m
Examination to Result 45m
Delhi head office to Mumbai Campus 2150m

Number of computers installed at various buildings are as follows:

Admin 110
Accounts 75
Examination 40
Result 12
Delhi Head Office 20

i. Suggest the most appropriate location of the server inside the Mumbai campus to
get the best connectivity for maximum number of computers. Justify your answer.

ii. Suggest and draw cable layout to efficiently connect various buildings within the
Mumbai campus for a wired connectivity.
4
 iii. Which networking device will you suggest to be procured by the company to
interconnect all the computers of various buildings of Mumbai campus?
iv. Company is planning to get its website designed which will allow students to see
their results after registering themselves on its server. Out of static or dynamic,
which type of website will you suggest?

v. Which of the following will you suggest to establish the online face to face
communication between the people in the admin office of Mumbai campus and
Delhi head office?
a) Cable TV
b) Email
c) Video Conferencing
d) Text chat

33. Write python code to plot a bar chart for India’s medal tally as shown below. Also give 5
suitable python statement to save this chart.

SECTION E

34. Consider the table Library. 4

Write SQL queries for the following:

i. Display the names of the books of category comedy and education.
ii. Display the details of the books in the ascending order of price.
iii. Display the details of the books purchased in the year 2006.
iv. Display the names of the books that starts with the letter “A”.

5
35. Consider the dataframe df: 4

Write python statements for the following:

i. Display the Name of student who has got more than 50 marks in UT1.
ii. Increase the marks in UT2 of all students by 5.
iii. Display the record of the student with roll no 13.
iv. Rename the column UT1 to PT1 and UT2 to PT2.

************************************