Class 12 Informatics Practices 065 Previous Year Question Paper 2023 – Solution

by

Series ΣHEFG
Question Paper Code 327 Set 4

INFORMATICS PRACTICES – SOLUTION
(Session 2022-23)

Time allowed : 3 hours
Maximum 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 1 mark each.
  4. Section B has 7 Very Short Answer type questions carrying 2 marks each.
  5. Section C has 5 Short Answer type questions carrying 3 marks each.
  6. Section D has 3 Long Answer type questions carrying 5 marks each.
  7. Section E has 2 questions carrying 4 marks each. One internal choice is given in Q. 35 against Part E only.
  8. All programming question are to be answered using python language only.

PART – A

1. Which of the following topologies is very efficient and all nodes are connected to a central hub?
i) Star
ii) Tree
iii) Bus
iv) Ring

2. Ramandeep is a young woman with great aspirations and has a good team of like-minded people. She along with her team members started a company to sell handicrafts online and also designed a logo for their company. What type of intellectual property does this logo represent ?
i) Patents
ii) Copyright
iii) Design
iv) Trademark

3. Which of the following is a type of cybercrime where objectionable and demeaning comments are posted on social media platform about a person, such that he/she is mentally harassed ?
i) Phishing
ii) Hacking
iii) Cyber bullying
iv) Identity Theft

4. Which of the following is the correct output of the following SQL command ?
SELECT ROUND (7876. 4568 , 2) ;
i) 7876.46
ii) 7876.45
iii) 7900
iv) 7900.4568

5. Aggregate functions are also known as :
i) Scalar Functions
ii) Single Row Functions
iii) Multiple Row Functions
iv) Hybrid Functions

6. Primary law in India for matters related to e-commerce and cyber crime is :
i) IT Act 1995
ii) IT Act 2000
iii) IT Act 1998
iv) IT Act 2010

7. Ravisha has stored the records of all students of her class in a MYSQL table. Suggest a suitable SQL clause that she should use to display the names of students in alphabetical order.
i) SORT BY
ii) ALIGN BY
iii) GROUP BY
iv) ORDER BY

8. To remove the leading and trailing space from data values in a column of MySql Table, we use
i) Left ( )
ii) Right ( )
iii) Trim ( )
iv) Ltrim ( )

9. If the substring is not present in a string, the INSTR ( ) returns:
i) — 1
ii) 1
iii) NULL
iv) 0

10. What will be the output of the following code ?
Class 12 IP 065 Previous Year Question Paper 2023 Q.10
Answer: (ii)

11. Which of the following is a two-dimensional labelled data structure of Python ?
i) Relation
ii) DataFrame
iii) Series
iv) Square

12. To compare data values of commission earned by salesmen over a year, which of the following type of graph should preferably be used ?
i) line
ii) area
iii) bar
iv) scatter

13. Which of the following is not a web browser ?
i) Opera
ii) Google Chrome
iii) Linux
iv) Mozilla Firefox

14. Which of the following is not a valid aggregate function in MYSQL ?
i) COUNT ( )
ii) SUM ( )
iii) MAX ( )
iv) LEN ( )

15. The digital footprint that we leave online unintentionally is called
i) Active digital footprint
ii) Passive digital footprint
iii) True digital footprint
iv) False digital footprint

16. E-waste is responsible for the degradation of our environment if not properly treated or disposed of. Some of the feasible methods of e-waste management are reduce, and recycle.
i) reuse
ii) recheck
iii) resubmit
iv) regular

Q. 17 and 18 are ASSERTION (A) and REASONING (R) 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 and (R) is false.
iv) (A) is false but (R) is true.

17. Assertion (A) : A static webp age does not change for each person visiting the web page.
Reason (R) : When a web server receives a request for a dynamic web page, it locates and updates the page and sends it to the browser of the client.
Answer: i) Both (A) and (R) are true and (R) is the correct explanation for (A).

18. Assertion (A) : The output of addition of two series will be NaN, if one of the elements or 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.
Answer: iii) (A) is true and (R) is false.

PART – B

19. What is web server? How is it different from web browser?
Answer: Web server is a software or hardware that serves web pages to clients upon their request(s).

Web ServerWeb Browser
It stores the data of the website.It requests and displays web pages from web servers.
Typically located on a remote server.Installed on the user’s local machine.
Example: Apache, Nginx, Microsoft IIS, Tomcat, etc.Example: Chrome, Firefox, Safari, Edge, etc.

OR

What do you understand by the term cookies? Give any two benefits of cookies.
Answer: Cookies are small pieces of data that websites store on a user’s device (usually in their web browser). They enhancing the user experience. These are text files.
Benefits of Cookies:
(i) Personalization: Cookies enable websites to remember user preferences, such as language settings, theme choices, and customized layouts.
(ii) Targeted Advertising: Cookies are often utilized in online advertising to track users’ interests and serve them targeted advertisements based on their browsing history.

20. Keshav has written the following query to find out the sum of bonus earned by the employees of WEST zone:
SELECE zone, TOTAL (bonus) FROM employee HAVING zone = 'WEST';
But he got an error. Identify the errors and rewrite the query by understanding the correction(s) done.

SELECT zone, SUM(bonus) FROM employee HAVING zone='WEST';

OR

SELECT zone, SUM(bonus) FROM employee WHERE zone='WEST';

21. Differentiate between COUNT ( ) and COUNT (*) functions in MYSQL. Give suitable examples to support your answer.

COUNT()COUNT(*)
Counts the number of rows that have a non-NULL value in the specified column.Counts the total number of rows in a table, including those with NULL values.
It takes column name(s) in the parenthesis (bracket).It takes asterisk sign (*) in the parenthesis (bracket).
Example: SELECT COUNT(column_name) FROM table_name;Example: SELECT COUNT(*) FROM table_name;

22. Write a Python program to create a series object, country using a list that stores the capital of each country.
Note : Assume four countries to be used as index of the series object are India, UK, Denmark, and Thailand having their capitals as New Delhi, London, Copenhagen, and Bangkok respectively.

import pandas as pd
l=[New Delhi, London, Copenhagen,Bangkok]
country=pd.Series(['New Delhi', 'London', 'Copenhagen','Bangkok'],
          index=['India', 'UK', 'Denmark','Thailand'])
print(country)

23. Explain plagiarism with an example.
Answer: Plagiarism is like copying someone else’s work and pretending it’s your own. Imagine you have to write a story for school, and your friend wrote a really cool story. Instead of creating your own, you just take your friend’s story, change a few words here and there, and say you wrote it. That’s plagiarism!
Example: Plagiarism is when you use someone else’s words or ideas without giving them credit, and you pretend that you did all the work yourself.

OR

Nowadays all of us frequently use social media to connect with our friends. Give any two netiquettes that we should follow while communicating on social media.
Answer: Netiquette, or internet etiquette, is crucial for maintaining positive and respectful communication on social media platforms.
(i) Treat others as you would like to be treated.
(ii) Avoid offensive language, and be mindful of cultural differences.
(iii) Write in a clear and understandable manner.
(iv) Use emojis or other cues to convey emotion appropriately.

24. What will be the output of the following code :
import pandas as pd
sl=pd.Series(data=2*(3,10))
print(s1)

0 3
1 10
2 3
3 10
dtype: int64

25. Carefully observe the following code :
Class 12 IP 065 Previous Year Question Paper 2023 Q.25
Write Python statements for the following :
(i) In the dataframe player created above, set the row labels as ‘Player1’, ‘Player2’, ‘Player3’, ‘Player4’, ‘Player5’.

index=pd.Index(['Player1','Player2','Player3','Player4','Player5'])
player=player.set_index(index)

OR

player=pd.DataFrame (dic,index=['Player1','Player2','Player3','Player4','Player5'])

(ii) Rename the column ‘points’ to ‘netpoint’ in the DataFrame player.

player.rename(columns={'points':'netpoint'},inplace=True)

OR

player.columns=['pid','pname','sports','netpoints']

SECTION – C

26. Consider the table “Patient: given below and write SQL commands.
Class 12 IP 065 Previous Year Question Paper 2023 Q.26
(i) Display the details of all patients who were admitted in January.

SELECT * FROM Patient WHERE monthname(Dateofadm)='January';

(ii) Count the total number of patients from Delhi.

SELECT COUNT(*) FROM Patient WHERE City='Delhi';
OR
SELECT City, COUNT(*) FROM Patient GROUP BY City HAVING City='Delhi';

(iii) Display the last 2 digits of the Patientid of all patients from Surgery Department.

SELECT right(PatientID,2) FROM Patient WHERE Department='Surgery';
OR
SELECT mid(PatientID,-2) FROM Patient WHERE Department='Surgery'
;

27. Kavyanjali, a chemical analyst, needs to arrange data of few elements in the form of two series containing symbols and their atomic numbers respectively. Thereafter, the data of these two series has to be arranged and displayed in the form of Data Frame as shown below :
Class 12 IP 065 Previous Year Question Paper 2023 Q.27
Help her in writing suitable Python code to complete the task.

import pandas as pd
idx=['Hydrogen','Helium','Lithium','Beryllium']
s1=pd.Series(['H','He','Li','Be'],index=idx)
s2=pd.Series([1,2,3,4],index=idx)
d={'Symbol':s1,'Atomic Number':s2}
df=pd.DataFrame(d)
print(df)

28. Consider the given DataFrame ‘health’.
Class 12 IP 065 Previous Year Question Paper 2023 Q.28
Write suitable Python statements for the following :
(i) Remove the row containing details of disease named Tuberculosis.
Answer: health=health[health[“Diseasename”]!=’Tuberculosis’]
(ii) Add a new disease named ‘Malaria’ caused by ‘Protozoa’.
Answer: health.loc[len(health)]=[‘Malaria’,’Protozoa’]
(iii) Display the last 2 rows.
Answer: print(health.tail(2))

29. Manohar received an email from a company, named Makemoney Pvt. Ltd., claiming that Manohar has won Z20 lakhs in a survey done online. In order to claim the prize money, he was required to answer few security questions such as his Name, Account number, PAN card details, Phone number and OTP for verification purposes. For this, he had to click on the link provided in the email.
Answer the following questions :
(i) Should Manohar give the required details to the company ?
Answer: No, Manohar should not give the required details to the company.
(ii) What is the activity depicted above ?
Answer: Phishing
(iii) What should he do with this email ?
Answer: He should delete that email immediately.

OR

What do you understand by the term Hacking? Write any two measures that one should take to avoid being the victim of hacking.
Answer: Hacking is when someone tries to get into computer systems or networks to access, change, or take information without permission.
Imagine you have a diary with all your secrets, and someone tries to read it without your permission. That’s a bit like what hacking is, but with computers. Hackers use their computer skills to find ways to get into systems and see or change things they’re not supposed to.
Here are some measures you can take to avoid being a victim of hacking:
(i) Use strong and complex passwords that include a mix of letters, numbers, and symbols.
(ii) Regularly update your operating system, antivirus software, and other applications.

30. Write the output (i-iii) for the following SQL commands.
Class 12 IP 065 Previous Year Question Paper 2023 Q.30
(i) SELECT COUNT(Product) FROM FASHION;
Answer: 6
(ii) SELECT SUM (Price*Qty) FROM FASHION WHERE Product=”Night Cream” ;
Answer: 34000
(iii) SELECT LEFT (Product, 4) FROM FASHION WHERE Price>1500 ;
Answer:
Foun
Nigh
OR
Find the output of the following SQL queries :
(i) SELECT SUBSTR (“CLIMATE CHANGE” , 4 , 4) ;
Answer: MATE
(ii) SELECT UCASE(RIGHT (“Pollution” , 3) ) ;
Answer: ION
(iii) SELECT LENGTH (“HAPPY”) +3 ;
Answer: 8

SECTION – D

31. Write the SQL queries which will perform the following operations :
(i) To display the year from your Date of Admission which is ‘2023-05-15’.

SELECT YEAR(‘2023-11-23’);

(ii) To convert your email id ‘ABC@XYZ.com‘ to lowercase.

SELECT LOWER(‘LEARNCSEDOTIN@GMAIL.COM’);
OR
SELECT LCASE(‘LEARNCSEDOTIN@GMAIL.COM’);

(iii) To remove leading spaces from a string ‘ my country ‘.

SELECT LTRIM(‘my country’);

(iv) To display current date.

SELECT DATE(now());

(v) To display the value of 106.

SELECT POW(10,6);

OR
Consider a table PRODUCT with the following data :
Class 12 IP 065 Previous Year Question Paper 2023 Q.31-OR
Write SQL queries using SQL functions to perform the following operations :
(i) Display the first 3 characters of all Itemnames.

SELECT LEFT(Itemname, 3) FROM PRODUCT;

(ii) Display the names of all items whose Stockday is “Monday”.

SELECT Name FROM PRODUCT WHERE dayname(Stockdate)='Monday';

(iii) Display the total price of all the products.

SELECT SUM(Price) FROM PRODUCT;

(iv) Display the maximum Price.

SELECT MAX(Price) FROM PRODUCT;

(v) Display the average Price of all the products by the company named ‘Logitech’.

SELECT AVG(Price) FROM PRODUCT WHERE Company='Logitech';

32. XEED Private Ltd., Delhi is a company that deals with educational toys. They have different divisions HR (Al), Sales (A2), Production (A3) and Marketing (A4).
The layout of the Delhi branch is :
Class 12 IP 065 Previous Year Question Paper 2023 Q.32-i
The company also has a branch in Bangalore. The management wants to connect all the divisions as well as all the computers of each division (Al, A2, A3, A4).
Distance between the wings are as follows :
Class 12 IP 065 Previous Year Question Paper 2023 Q.32-ii
Number of computers in each of the wing:
Class 12 IP 065 Previous Year Question Paper 2023 Q.32-iii
Based on the above specifications, answer the following questions :
(i) Suggest the topology and draw the most suitable cable layout for connecting all the divisions of Delhi branch.
Answer: Bus Topology
(ii) Suggest the kind of network required (out of LAN, MAN, WAN) for connecting Production (A3) with the Bangalore branch.
Answer: WAN
(iii) Which device can be used to connect the network of Delhi Branch to the Internet ? This device should be able to receive data, analyse it and then transmit it to the network.
Answer: Router
(iv) Suggest the placement of switch/hub with justification.
Answer: Switch or Hub is required in all divisions.
(v) Many employees were finding it difficult to cope up with work pressure and hence were showing stress related symptoms. In order to improve the mental health of its employees, HR planned to conduct an online session with a mental health expert from Mumbai. Out of the options given below, suggest the protocol that will help to send the voice signals over internet to conduct the session successfully.
(a) FTP
(b) SMTP
(c) VOIP
(d) POP

33. Consider the following graph. Write the Python code to plot it. Also add the Title, label for X and Y axis.
Use the following data for plotting the graph
smarks=[10,40,30,60,55]
sname=["Sahil", "Deepak", "Anil", "Ravi","Riti"]
Class 12 IP 065 Previous Year Question Paper 2023 Q.33

import matplotlib.pyplot as plt
smarks=[10,40,30,60,55]
sname=["Sahil", "Deepak", "Anil", "Ravi", "Riti"]
plt.plot(sname,smarks)
plt.xlabel("Student Name")
plt.ylabel("Marks Scored")
plt.title("Marks Secured by students in Term - 1")
plt.show()

OR
Write Python code to draw the following bar graph representing the total sales in each quarter. Add the Title, Label for X-axis and Y-axis.
Use the following data for plotting the graph :
sales=[450,300,500,650] qtr=["QTR1", "QTR2", "QTR3", "QTR4"]
Class 12 IP 065 Previous Year Question Paper 2023 Q.33-OR

import matplotlib.pyplot as plt
sales=[450,300,500,650]

qtr=["QTR1","QTR2","QTR3","QTR4"]
plt.bar(qtr,sales)
plt.xlabel("Quarter")  
plt.ylabel("Sales")
plt.title("Sales each quarter")
plt.show()

SECTION – E

34. Consider the following table “Schooldata“:
Class 12 IP 065 Previous Year Question Paper 2023 Q.34
Write SQL queries for the following :
(i) Display the average Marks secured by each Gender.

SELECT GENDER, AVG(Marks) FROM Schooldata GROUP BY Gender;

(ii) Display the minimum Marks secured by the students of Grade 10.

SELECT GRADE, MIN(Marks) FROM Schooldata WHERE Grade=10;

(iii) Display the total number of students in each Club where number of students are more than 1

SELECT CLUB, COUNT(*) FROM Schooldata GROUP BY Club HAVING COUNT(*)>1;

OR – Option for Part (iii) only
(iii) Displaty the maximum and minimum marks secured by each gender.

SELECT MAX(Marks), MIN(Marks) FROM Schooldata GROUP BY Gender;

35. Consider the following DataFrame ‘mdf’.
Class 12 IP 065 Previous Year Question Paper 2023 Q.35
(A) Write Python statements for the DataFrame ‘mdf’:
(i) To display the records to display the Rollno and Name of all students who secured less than 10 marks in Maths.
Answer: print(mdf.loc[1:2])
(ii) To increase the marks of subject Math by 4, for all students.
Answer: mdf.Maths=mdf.Maths+4
(B) Write Python statement to display the Rollno and Name of all students who secured less than 10 marks in Maths.
Answer: print(mdf.loc[(mdf[‘Maths’]<10),[‘Rollno’,’Name’]])

OR [Option for Part (B) only]

Write Python statement to display the total marks i.e., sum of marks secured in English, Hindi and Maths for all students.
Answer: s_cols=mdf.sum(numeric_only=True,axis=0)
print(s_cols[1:])

Find Class 12 Informatics Practices Previous Year Question Papers

Find Class 12 Informatics Practices Previous Year Question Papers Solution

Find Class 12 Informatics Practices Previous Year Compartment Question Papers

Find Class 12 Informatics Practices Previous Year Compartment Question Papers Solution

Leave a Comment