CHENNAI SAHODAYA SCHOOL COMPLEX

General Instructions:
1. This question paper contains 10 printed pages.
2. This question paper contains 35 questions.
3. Write down the question number before attempting.
4. An additional reading time of 15 minutes.
5. This question paper contains five sections, Section A to E.
6. All questions are compulsory.
7. Section A have 18 questions carrying 01 mark each.
8. Section B has 07 Very Short Answer type questions carrying 02 marks each.
9. Section C has 05 Short Answer type questions carrying 03 marks each.
10. Section D has 03 Long Answer type questions carrying 05 marks each.
11. Section E has 02 questions carrying 04 marks each. One internal choice is given
in Q35 against part c only.
12. All programming questions are to be answered using Python Language only.

COMMON EXAMINATION
Class – 12
INFORMATICS PRACTICES(065)
SET - 1
Time Allowed: 3 hours Maximum Marks: 70
Roll No.: Date:dd/mm/yyyy
PART A
1. Which networking device is used to amplify a network signal when it travels a 1
long distance in transmission media and due to resistance of media signal
becomes weak.
i. Router
ii. Switch
iii. Gateway
iv. Repeater
2. The trail that is automatically created when a person uses the internet on any 1
digital devices like Laptops, smart phones, tablets, etc is called _____________.
i. Cyberbullying
ii. Phishing
iii. Digital Footprint
iv. Digital Activity
3. Discarded electrical or electronic devices are known as _____________. 1
i. E waste
ii. Software Waste
iii. Hardware waste
iv. Computer waste

Page 1 of 10
4. Find the output of the following SQL command: 1
SELECT mid(‘Informatics Practices’, -9);
i. Practices
ii. Infor
iii. Informatics
iv. None of the above
5. If column “City” contains the data set (CHENNAI, MUMBAI, KOLKATA, 1
CHENNAI, KOLKATA), what will be the output after the execution of the given
query?
SELECT COUNT(DISTINCT City) FROM Customer;
i. 4
ii. 5
iii. 3
iv. 2
6. OSS stands for 1
i. Open system security
ii. Open system source
iii. Open software and security
iv. Open source software
7. Akhil has given the following command to arrange the data in ascending order of 1
date.
Select * from travel where order by tdate;
But he is not getting the desired result. Help him by writing the correct command.
i. Select * from travel where order by tdate;
ii. Select * from travel order by tdate;
iii. Select * from travel in ascending order;
iv. Select tdate from travel order by tdate;
8. What will be returned by the given query? 1
SELECT ROUND(49.88);
i. 49.88
ii. 9.8
iii. 49.0
iv. 50
9. The avg() function in MySql is an example of _____________. 1
i. Math function
ii. Text function
iii. Date function
iv. Aggregate function
10. A Series by default have numeric data labels starting from _______________. 1
i. 3
ii. 2
iii. 1
iv. 0

Page 2 of 10
11. Which of the following command is used to install pandas ? 1
i. pip install pandas
ii. pip pandas
iii. install pandas
iv. install pip pandas
12. Which of the following statement is correct? 1
i. We can create Series from Dictionary in Python
ii. Keys of the dictionary becomes the index of the series
iii. Order of the indexes created from keys may not be in the same order as
typed in the dictionary
iv. All of the above
13. Which of the following would be a creative work protected by copyright? 1
i. A list of all Indian President names
ii. A portrait of your family
iii. A song you wrote
iv. Name of your pet dog
14. To specify condition with a GROUP BY clause, _________ clause is used. 1
i. USE
ii. WHERE
iii. HAVING
iv. LIKE
15. A sentinel program which tries to protect computer system from data loss, 1
destruction of system files and attack of any external threats like worm or virus is
called _____________.
i. Virus program
ii. Worm scripts
iii. Antivirus program
iv. Spyware
16. Out of the following which one will be altered or modified by a computer virus? 1
i. Operating system
ii. Speed of network connectivity
iii. Application software
iv. All of the above
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct choice as
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True
17. Assertion (A): - Intellectual Property rights are the rights of the owner of information 1
to decide how much information to be exchanged, shared or distributed.

Reasoning (R):- IPR must be protected because protecting them encourages

individuals and businesses to create new software and new software applications as well
as improving existing applications.

Page 3 of 10
18. Assertion (A):- A series object is size mutable. 1
Reasoning (R): - A data frame is value mutable.

PART B
19. Distinguish between LAN and WAN. 2
OR
Explain the function of the following network devices:
a. Modem
b. Firewall
20. Write SQL commands: - 2
a. To print the length of the string “Happy Holidays”
b. To print the string “Happy Holidays” in capital letters.
21. Explain why the following queries give different outputs on execution: 2
(i) SELECT COUNT(NAME) FROM CUSTOMER;
Output: 5
(ii) SELECT COUNT(*) FROM CUSTOMER;
Output: 9
22. What is unauthorized access? How can confidentiality of data be maintained? 2

23. Consider the following Series object, s 2

Apple 10
Mango 20
Banana 30
Orange 40
i. Write the command which will display only apple.
ii. Write the command to increase price of all fruits by 10.
OR
Mention any four net etiquettes.
24. What will be the output of the following code: 2
import pandas as pd
a=pd.Series([10,20,30,40],index=['a','b','c','d'])
print(a*5)
25. A dictionary Grade contains the following: 2
Grade={'Name':['rashmi','Harsh','Ganesh','Priya','Vivek'],'Grade':['A1','A2','B1','A
1','B2']}
Write statements for the following:
i. Create a dataframe name “Gr”.
ii. Add a column called „marks‟ with the following data: [97,92,95,89,96,82]

Page 4 of 10
 SECTION C
26. A relation Product is given below: 3
TABLE: PRODUCT

P_No Ptype P_Manufacturer Price Qty

P1001 Pencil Nataraj 15 20
P1002 Ball Pen Reynolds 10 50
P1003 Gel Pen Flair 20 100
P1004 Sketch Pen Doms 50 35
P1005 Paint Brush Doms 30 15
P1006 Pencil Nataraj 15 30
P1007 Ball Pen Reynolds 10 10
P1004 Sketch Pen Doms 50 60
P1005 Paint Brush Doms 30 85
P1006 Pencil Nataraj 15 45
Write SQL commands to:
i. Display the Average price of each type of Product having
quantity more than 50.
ii. Increase the price of the products manufactured by Doms by 2%.
iii. Display the Maximum and Minimum price of all types of Products.
27. Write a Python code to create the following dataframe books suing Python 3
Pandas. Use any method of dataframe creation that you have learnt:
BookName Class Price
Let us C BCA 270
Artificial Intelligence B.Tech 350
Database Management BCA 450
Computer Architecture BCA 550
Give index as „B1‟, „B2‟, „B3‟, „B4‟.
28. Write a code to plot the speed of a passenger train as shown in the figure given 3
below. Assume the values for x from 1 to 5 and the other axis is taken as 1.5x,
3.0x and x/3.0.

Page 5 of 10
29. What are the different ways in which authentication of a person can 3
be performed?
OR
Describe measures to recycle your e-waste.
30. Based on table SCHOOL given here, write suitable SQL queries for 3
the following:

Code Teacher Subject Categ DOJ PDS EXP

Name ory
1001 RAVI ENGLISH PGT 12/03/2000 24 10
SHANKA
R
1009 PRIYA PHYSICS TGT 03/09/1998 26 12
RAI
1203 LISA ENGLISH TGT 09/04/2000 27 5
ANANAD
1045 YASHRAJ MATHS PGT 24/08/2000 24 15
1123 GANAN PHYSICS TGT 16/07/1999 28 3
1167 HARISH CHEMIST PGT 19/10/1999 27 5
B RY

TABLE: SCHOOL

Page 6 of 10
 1215 UMESH PHYSICS TGT 11/05/1998 22 16

a. Display subject wise highest experience.

b. Display category wise lowest experience.
c. Display total number of PGT and TGT teachers.
OR
What is the difference between the ORDER BY and GROUP BY clause when
used along with the select statement? Explain with an example.
SECTION D
31. Explain the following functions with examples: 5
a. SUBSTRING()
b. POWER()
c. DAYNAME()
d. LTRIM()
e. LENGTH()
OR
Write suitable SQL query for the following:
i. Display 7 characters extracted from 7th left character onwards
from the string „INDIA SHINING‟.
ii. Display the position of occurrence of string „COME‟ in the string
„WELCOME WORLD‟.
iii. Round off the value 23.78 to one decimal place.
iv. Display the remainder of 100 divided by 9.
v. Remove all the expected leading and trailing spaces from a
column userid of the table „USERS‟.
32. Prime Computer services Ltd. is an international educational organization. It is 5
planning to 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 raised in (i) to (v), keeping in mind the distances between the
buildings and other given parameters.

EXAMINATION ADMIN
DELHI HEAD OFFICE
Page 7 of 10
 ACCOUNTS RESULT

Shortest distances between various buildings:

ADMIN TO ACCOUNTS 55 m
ADMIN TO EXAMINATION 90 m
ADMIN TO RESULT 50 m
ACCOUNTS TO EXAMINATION 55 m
ACCOUNTS TO RESULT 50 m
EXAMINATION TO RESULT 45 m
DELHI Head Office to MUMBAI CAMPUS 2150 m
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 (out of the four buildings) 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.
(iii) Which networking device will you suggest being 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 the static or
dynamic, which type of website will you suggest?
(v) Which of the following will you suggest establishing 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 5
below:

Page 8 of 10
 Also give suitable python statement to save this chart.
OR
Write a python program to plot a line chart based on the given data to depict the
changing medal tally between four Houses in school.
House=['Nehru', 'Patel', 'Netaji', 'Tagore']
medal=[50,70,90,110]
SECTION E
34. Consider a table LOANS with the following data: 1+1+2
TABLE: LOANS
AccNo Cust_Name Loan_Amount Int_Rate Interest
1 R.K.Gupta 300000 12.00 1200
2 S.P.Sharma 500000 10.00 1800
3 K.P.Jain 300000 NULL 1600
4 M.P.Yadav 800000 10.00 2250
5 S.P.Sinha 200000 12.50 4500
6 P.Sharma 700000 12.50 3500
7 K.S.Dhall 500000 NULL 3800
Answer the following questions:
i. Display the sum of all loan amounts whose interest rate is greater than 10.
Page 9 of 10
 ii. Display the maximum interest from Loans table.
iii. Display the count of all loan holders whose name ends with „Sharma‟.
OR (Option for part iii only)
Display the count of all loan holders whose interest is Null.
35. Mr. Sam, a data analyst has designed the DataFrame df that contains data about 1+1+2
Computer Olympiad with „CO1‟, „CO2‟, „CO3‟, „CO4‟, „CO5‟ as indexes shown
below. Answer the following questions:
School Tot_students Topper First_Runnerup
CO1 PPS 40 32 8
CO2 JPS 30 18 12
CO3 GPS 20 18 2
CO4 MPS 18 10 8
CO5 BPS 28 20 8
Predict the output of the following python statement:
i. df.shape
ii. df[2:4]
iii. Write Python statement to display the data of Topper column of indexes CO2
to CO4.
OR (Option for part iii only)
Write Python statement to compute and display the difference of data of
Tot_students column and First_Runnerup column of the above given DataFrame.

End of paper

Page 10 of 10