Downloaded from www.tutorialaicsip.

com
Answer Key Sample Paper 1
Subject: Informatics Practices (065) Class 12
Time: 3:00 Hours Max. Marks: 70
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 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. One internal choice is
given in Q35 against part c only.
8. All programming questions are to be answered in Python Language only.
Section –A
1. Two friends are working in the same office are transferring their files through
Bluetooth in their devices. Which type of network the have used?
a) LAN c) WAN
b) MAN d) PAN
2. Which of the following is an example of absolute URL?
a) samplepaper-ip-class12
b) https://www.tutorialaicsip.com
c) /Sample-Paper-2023/Samplepaper-ip-class12.html
d) All of these
3. Read the following statement and select an appropriate term for the same:
“It includes websites visited by user, emails sent by user, information submitted
online by user, IP address, location and other serviced online. “
a) Digital Footprint c) Plagiarism
b) IPR d) Cyber Stalking
4. Rama is working on MySQL. She wants to count the employees not earning
commission from the table emp. Which of the following is correct statement for her?
a) Select count(empno) from emp where commission is not null;
b) Select count(empno) from emp where commission = null;
c) Select count(empno) from emp where commission is null;
d) Select commission(empno) from emp where commission =’null’;
 Downloaded from www.tutorialaicsip.com
5. Krushn wants to display the unique departments from table emp. Which of the
following is correct statement for him?
a) Select unique department from emp;
b) Select distinct department from emp;
c) Select department from emp;
d) Select department(unique) from emp;
6. The software which are sold commercially and their source code not shared or
distributed to the users are known as _____________
a) Proprietary software c) GPL License software
b) FOSS software d) Pirated Software
7. Which function In SQL, we can use similarly as substr() or substring() ?
a) instr() c) middle()
b) mid() d) between()
8. Which of the following is not a multiple row function?
a) round() c) max()
b) sum() d) count()
9. Minakshi wants to sort the SQL query result in sorted form of a particular columns,
which of the following clause is correct for the same?
a) order by c) group by
b) sort by d) sorted by
10. Nirmal has written following code to get the last five records from Series object S,
but he is not getting the correct output.
print(s.bottom(5))
Help him by selecting an appropriate option from the following to get his desired
result?
a) s.last() c) s.tail()
b) s.trail() d) s.end()
11. NumPy stands for
a) Numbered Python c) Numeric Python
b) Number Python d) Numerical Python
12. The pandas Series can be considered as
a) Column in a spreadsheet
b) Row in a spreadsheet
c) Cell in a spreadsheet
d) Header in a spreadsheet
 Downloaded from www.tutorialaicsip.com
13. Which amongst from the following is used to identifies a resource by its location
or by its name or both?
a) URL c) URA
b) URI d) URR
14. Mehal wants to display name of day of his birthday. Select appropriate function
name for him.
a) day() c) weekday()
b) dayname() d) nameofday()
15. A patent protects an invention for _____ years and then it can be freely used.
a) 10 c) 20
b) 15 d) 25
16. Be secure refers to
a) Choose password wisely c) Beware of fake information
b) Know who you be friend d) All of these
Q17 & 18 are ASSERTION & REASONING 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 but R is False
d) A is false but R is True
17. Assertion(A): User cannot download any image directly from google and use in
their content.
Reasoning(R):The images are subject to copyrights.
a) Both A and R are true and R is the correct explanation for A
18. Assertion(A): In python pandas at attribute is to select or access multiple values
from data frame.
Reasoning(R): In python pandas, loc attribute is used to select or access a
single/multiple value(s) from dataframe.
d) A is False but R is True
Section –B
19. List out any four services provided by internet.
Ans.: The services provided by internet are as follows:
i. The world wide web
ii. Electronic Mail
iii. Chat
iv. VoIP
(Reference: NCERT Text Book – P.G.No:149/(159/220))
 Downloaded from www.tutorialaicsip.com
OR
Differentiate between LAN and MAN. (Any two points)
Ans.:
LAN MAN
Full Form Local Area Network Metropolitan Area Network
Connection Connects small area Covers large regions like cities
Speed Offers High Speed Offers moderate speed
Uses Schools, Homes, Colleges etc. Government Sectors

For more points refers this link:Byjus.com

20. Write the output for the following:
a) Select mod(8/4,3);
b) Select power(2,-2);
Ans.: a) 2.0000 b) 0.25
21. Write MySQL for the following purposes for table invoice:
a) Compute GST as 18% of price and display the result with 2 decimal places.
b) Display the result in the multiple of hundreds and remaining amount
Ans.: a) select round(price*0.18,2) from invoice;
b) select mod(amt,100) from invoice
22. Write a panda’s code to create a series to store player details who played most
T20 World cup matches from Team India from following data:
Player No. of Matches
Rohit Sharma 39
M S Dhoni 33
Yuvraj Singh 31
Virat Kohli 27
R Ashwin 24
Store player name as index and no. of matches as data.
Ans.: import pandas as pd
L=[39,33,31,27,24]
S=pd.Series(L,index=[‘Rohit Sharma’,’M S Dhhoni’,’Yuvraj Singh’,’Virat Kohli’,’R
Ashwin’])
print(S)
23. Expand:
Ans.:
a) WEEE – Waste Electrical and Electronic Equipment
b) CPCB – Central Pollution Control Board
c) DIT – Department of Information Technology
d) CAT - Cyber Appellate Tribunal
 Downloaded from www.tutorialaicsip.com
OR
What do you mean by identity theft? Illustrate answer with example.
Ans.: On internet user’s identifiable personal data like demographic details, email ID,
banking credentials, passport, PAN, adhaar ID and some other important data
stolen and misused by hacker is known as identity theft.
For example: Financial identity theft done when stolen identity is used for
financial gain.
24. Consider the following series and write output for given statement:
S1 S2
1 20 0 10
2 30 1 30
0 40 2 20
a) S1 + S2
b) S1 < S2
Ans.: a)
0 50
1 50
2 50
dtype: int64
b) No output, as this statement will raise error because indexes are not identical.
25. Observe the following code and write statements for the below given questions:
import pandas as pd
player1={‘IG1’:34,’IG2’:0,’IG3’:23}
player2={‘IG1’:21,’IG2’:10,’IG3’:39}
pl={‘p1’:player1,’p2’:player2}
df=pd.DataFrame(pl)
a) Display data of player scored more than 30 runs
b) Display all rows of first inning of all players
Ans.: a) print(df[df>30])
b) print(df.loc['IG1',:]) or print(df.iloc[0,:])
Section – B
26. Consider the given table students and write the output of given queries:
Rno Name Stream Doa Percentage
1 Gayatri Arts ‘2018-04-01’ 78.2
2 Amit Commerce ‘2017-04-13’ 65.3
3 Sagar Science ‘2016-06-03’ 85.8
4 Manisha Arts ‘2015-07-01’ 53.5
5 MaheMahk Science ‘2018-07-05’ 79.6
6 Maulin Commerce ‘2018-06-05’ 82.3
 Downloaded from www.tutorialaicsip.com
a) Select length(name) from students where percentage between 80 and 90;
b) Select name, stream from students where month(doa) in (7,6);
c) Select power(len(stream),2) from students where stream=’Arts’
Ans.:
a) length(name)
---------------
5
6
b) name stream
-------------- -----------------
Sagar Science
Manisha Arts
Mahek Science
Maulin Commerce
c) power(len(stream),2)
---------------------------
16
16
27. Write python code to create a dataframe by using following data:
[[201,’Manoj’,4500],[202,’Dhara’,3200],[203,’Mohini’,2300]]
i. Dataframe name should be cust
ii. Use column headings as: cust_id,cust_name and amount
Ans.:
import pandas as pd
L=[[201,'Manoj',4500],[202,'Dhara',3200],[203,'Mohini',2300]]
cust=pd.DataFrame(L,columns=['cust_id','cust_name','amount'])
print(cust)
28. Consider the following dataframe ‘tempurature:
City max
0 Ahmedabad 31
1 Surat 29
2 Vapi 25
3 Vadodara 32
Write suitable python code to:
a) Add new column min with these data: [25,22,19,28]
Ans.: df.loc[:,'min']=[25,22,19,28] or
df.insert(2,’Min’,[25,22,19,28]) or
df.insert(loc=2,column='Min',value=[22,25,19,28])
 Downloaded from www.tutorialaicsip.com
b) Add new city Mahesana with 30 value
Ans.: df=df.append({'City':'Mahesana','Max':30},ignore_index=True) or
df.loc[4]=['Mahesana',30] or df.loc[len(df)]=['Mahesana',30]
c) Delete column min
Ans.: del df['Min'] or df=df.drop('Min',axis=1) or df=df.drop(columns='Min')
29. Write any three safety measures to reduce the risk of cybercrime.
Ans.:
1) Take regular backup for important data
2) Use updated antivirus software always
3) Avoid install pirated software
4) Use and download software from known and secured (https) source
5) Use strong passwords
6) Use or always secure wireless by a strong password
Reference: NCERT Textbook(Page No.:182/(192/220))
OR
Raj has created a group on social media to share and discuss about academics.
But his friend Mitul is posting rumours in the group.
i) What is the term used for the task done by Mitul?
Ans.: Cyber Bullying
ii) Any act by Indian Government imposed to protect and safeguard issues like
this? Explain in detail.
Ans.: Yes, Indian Government imposed IT Act 2000, amended in 2008. It provides
legal measures for protection of sensitive personal data and to safeguard the rights
of users. It provides guidelines to the user on the processing, storage and
transmission of sensitive information. It also provides a legal framework for
electronic governance by giving recognition to electronic records and digital
signatures.
Reference: NCERT Textbook (Page No.:182 & 183/(192&193/220))
30. Consider the following table transactions and write queries for given questions:
Cno Cname City Amount Modeofpay
101 Dinesh Anand 574 COD
102 Mahesh Petlad 630 UPI
103 Jayshree Anklav 145 Debit Card
104 Ketan Vasad 700 UPI
105 Mitesh Anand 595 Debit Card
 Downloaded from www.tutorialaicsip.com
106 Ramesh Anklav 680 UPI
108 Dhaval Vasad 900 COD
109 Zarna Petlad 150 COD
110 Manohar Anand 450 Debit Card
i. Display the maximum amount for each payment method.
Ans.: select modeofpay, max(amount) from transactions group by modeofpay;
ii. Display the lowest amount for each city.
Ans.: select city, min(amount) from transaction group by city;
iii. Display total amount of Orders for Anand city.
Ans.: select sum(amount) from transactions where city=’Anand’;
OR
Write output for following:
i. select instr(‘Pre-Board Exam 2023’,’2’);
Ans.: instr(‘Pre-Board Exam 2023’,’2’)
---------------------------------------
16
ii. select substr(‘Pre-Board Exam 2023’,5);
Ans.: substr(‘Pre-Board Exam 2023’,5)
--------------------------------------
Board Exam 2023
iii. select left(‘Pre-Board Exam 2023’,4)
Ans.: left(‘Pre-Board Exam 2023’,4)
-----------------------------------
Pre-
Section – D
31. Consider the following table (salesperson) and Write SQL queries for following:
SID Name PhoneNo DOB Salary Zone
S101 Ankit 9824532586 1981-01-22 65000 North
S102 Bhvya 9725412396 1984-10-19 75000 South
S103 Bhumi 9898457120 1983-12-04 64000 East
S104 Vruti 9324578695 1988-04-05 45000 West
S105 Vikas 9612574891 1987-05-02 58000 Soutch
i. Display the salesperson name’s first two letters whose name ends with ‘i’.
Ans.: select left(name) from salesperson where right(name,1)=’i’; or
select left(name) from salesperson where name like ‘%i’;
ii. Display the eldest salesperson name
Ans.: select name,min(DOB) from salesperson;
iii. Display the square of last 4 digits of phone number
 Downloaded from www.tutorialaicsip.com
Ans.: select power(right(phoneno,4)) from salesperson;
iv. Count the sales person area wise and display the details of salesperson in
which more than 2 sales persons are belonging.
Ans.: select zone, count(SID) from salesperson group by zone having
count(SID)>2;
v. Display the longest name of the sales person area wise.
Ans.: select zone, max(length(name)) from salesperson;
OR
Explain the following functions with suitable examples.
i) trim() iii) date() v) now()
ii) ucase() iv) day()
Ans.:
i) trim(): This function removes the extra space from the left (leading) and right
(trailing) from the text.
Ex.: select trim(‘ IP Class 12 ’)
ii) ucase(): Converts the text into upper case.
Ex.: select ucase(‘cbse’);
iii) date(): Returns the date part from the specified date.
Ex.: select date(now());
iv) day(): Returns day number of given date.
Ex.: select day(now());
v) now(): Returns current date along with time.
Ex.: select now();
32. Soft Infotech Software Development Company has set up its new centre at
Ahmedabad for its office and web based activities. It has 4 blocks of building
named Design, HR, Development, R & D.
It has following no. computers in each block.
Department Computers
HR 25
Design 50
Development 125
R&D 10
Shortest distances between various Blocks in meters are as follows:
Block HR to Design 60 m
Design to Development 40 m
Development to HR 30 m
R & D to Development 50 m
i. Suggest the most suitable place (i.e. block) to house the server of this
company with a suitable reason.
Ans.: Development block is best block to house the server for this company.
 Downloaded from www.tutorialaicsip.com
ii. Suggest the type of network to connect all the blocks with suitable reason.
Ans.: As the distance is given within 1 KM, LAN network will connect all the
blocks.
iii. The company is planning to link all the blocks through a secure and high speed
wired medium. Suggest a way to connect all the blocks.
Ans.:

Suggest the most suitable block to

place the following devices:
a) Hub/Switch b) Modem
Ans.: a) Hub/Switch must be placed in every block
b) Modem is placed in Development to provide the internet connection
iv. Company is planning to purchase a new hardware to protect the network from
network from unauthorised access from outside the network. Name the device.
Ans.: Firewall
33. Write python code to plot a bar chart for India’s runs in T20 World cup as shown
below:
 Downloaded from www.tutorialaicsip.com
Colours: Pakistan – Green, Netherlands – red, South Africa – Blue,
Bangladesh – Cyan, Zimbabve – Magenta, England - Black
Apply appropriate labels to the chart, x and y axis.
Ans.:
import matplotlib.pyplot as plt
teams=["Pakistan","Netherlands","South
Africa","Bangladesh","Zimbabwe","England"]
runs=[160,179,137,184,186,168]
plt.bar(teams,runs,color=['r','g','b','c','m','k'])
plt.title("India's T20W Cup 2022")
plt.xlabel("Teams")
plt.ylabel("Runs")
plt.show()

OR
Write python code to depict the data of India/England semi final runs by over on
line chart. The data as following:
Overs 5 10 15
India 31 62 100
England 52 98 156
i) Display the overs as same as given here on x-axis.
ii) Apply the line colours as – India : Blue, England: Red
iii) Apply appropriate labels
iv) Apply chart label – T20W Cup 2022 : Semi-final 2
Ans.:
import matplotlib.pyplot as plt

overs=[5,10,15]

ind=[31,62,100]

eng=[52,98,156]

plt.plot(overs,ind,'b')

plt.plot(overs,eng,'r')

plt.title("T20W Cup Semi-final 2")

plt.xlabel("Overs")

plt.xticks(overs)

plt.ylabel("Runs")

plt.show()
 Downloaded from www.tutorialaicsip.com

Section – E
34. Consider the below given table – SuperArcade:
SNo AgencyName Owner Opening_Date Rent FLR
1 Gujarat Gas Gujarat Gas 2021-01-01 35000 I
2 Padhai Classes Ankur Patel 2018-04-01 32000 II
3 Ram Enterprise Ram Patel 2018-06-15 38000 I
4 SP InfoTech Siraj Patel 2020-05-17 28000 II
5 Gallops Niraj Desai 2018-05-20 48000 III
6 GK Classes Geet Kapoor 2019-08-15 34000 I
7 Nishtha Couriers Nishtha Patel 2020-11-04 22000 G
Krunal joined as DBA and written following partial queries, complete the queries and
help him: (1 + 1 + 2)
a) Select _________, _________ from superarcade; (Maximum & Minimum Rent)
Ans.: max(rent), min(rent)
b) Select __________ from superarcade; (owner name into capital)
Ans.: ucase(owner)
c) Select FLR, avg(rent) from superarcade _________ having ______>=2;
(Floor wise average rent where shops are more than 2)
Ans.: group by, count(agencyname)
OR
Select AgencyName, Owner from superarcade ____________ opening_date
___________ (Display the shops as per by history (Latest to Oldest)).
Ans.: order by, desc
35. Consider the following dataframe:
AppName Category Rating Installs
Coloring Book Barbaie Entertainment 3.8 646456
Pocket Bowling 3D Sports 3.6 334144
Smart File Manager Productivity 4.4 3741253
Photo Collage Photography 3.6 2534748

NVIDIA Games Entertainment 3.2 2073437

Sudoku Free Puzzles 3.9 438756
World Soccer Challenge Sports 4.1 1358733
SIGMA LINK Sports 2.4 261568
Live Up Social 3.9 287092
Status Saver for WhatsApp Social 4.7 1060986
Write code to do the following: (1 + 1 + 2)
a) Display categories from dataframe
Ans.: df.category or df[‘category’] or df.loc[:,category] or df.iloc[:,1]
 Downloaded from www.tutorialaicsip.com
b) Display Appname, Category and Rating for app having rating more than 4
Ans.:
d1=df[df['Rating']>4] or d1=df[df.Rating>4] or d1=df[df.loc[:,'Rating']>4]
print(d1.loc[:,['AppName','Category','Rating']])
c) Display AppName and installs for sports category apps
Ans.:
d1=df[df['Category']=='Sports'] or d1=df[df.Category=='Sports'] or
d1=df[df.loc[:,'Category']=='Sports']
print(d1.loc[:,['App','Installs']])
OR
Display the dimensions and shape of given dataframe
Ans.:
d=df.ndim
s=df.shape
print(d,s)

-------------X-----------------

Follow this link for more Question Papers:

Download IP Sample Papers for 2023

For note & question bank follow this link:

Download PDF for complete notes

Thank You