Class 12 Informatics Practices 065 Previous Year Question Paper 2024

by

Series &RQPS
Question Paper Code 90 Set 4

INFORMATICS PRACTICES
(Session 2023-24)

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.

SECTION – A

1. In topology, the devices are arranged in the form of multiple branches in hierarchical manner.
(i) Star
(ii) Tree
(iii) Mesh
(Iv) Bus

2. Ridhima purchased a license for a copy of a software and made additional copies without the permission of the copyright owner. This act of hers is known as _____.
(i) Trademark Infringement
(Ii) Identity Theft
(iii) Copyright Infringement
(iv) Patent

3. What can an individual do to enhance the privacy of data stored digitally ?
(i) Share sensitive information on social media platforms.
(ii) Use your date of birth as your password.
(iii) Regularly update software installed on your device.
(iv) Download and install software from unknown sources.

4. What will be the output of the following query ?
SELECT POWER (2,MOD(17,3));
(i) 8
(ii) 1
(iii) 0
(iv) 4

5. Which of the following is not an aggregate function in MYSQL ?
(i) AVG ()
(ii) MAX ()
(iii) LCASE ()
(iv) MIN ()

6. _____ is the gaining of unauthorized access to data in a computer system.
(i) Phishing
(ii) Plagiarism
(iii) Hacking
(iv) Copyright violation

7. Which of the following is NOT true with respect to CSV files ?
(i) Values are separated by commas.
(ii) to_csv() can be used to save a dataframe to a CSV file.
(iii) CSV file is created using a word processor.
(iv) CSV file is a type of text file.

8. Which MySQL command helps to add a primary key constraint to any table that has already been created ?
(i) UPDATE
(ii) INSERT INTO
(iii) ALTER TABLE
(iv) ORDER BY

9. What will be the output of the following query ?
SELECT SUBSTR(“G20 2023 INDIA”,5,4) ;
(i) G20 2
(ii) 2023
(iii) INDI
(iv) 023

10 What will be the output of the following Python code ?
import pandas as pd
dd={'One':1,'Two':2, 'Three':3, 'Seven':7}
rr=pd. Series (dd)
rr['Four']=4
print (rr)
(i) One 1
Two 2
Three 3
Seven 7
dtype: int64

(ii) One 1
Two 2
Three 3
Four 4
Seven 7
dtype: int64

(iii) Four 4
One 1
Two 2
Three 3
Seven 7
dtype: int64

(iv) One 1
Two 2
Three 3
Seven 7
Four 4
dtype: int64

11. Which of the following clause cannot work with SELECT statement in MYSQL ?
(i) FROM
(ii) INSERT INTO
(iii) WHERE
(iv) GROUP BY

12. Which of the following command will not show first five rows from the Pandas series named S1 ?
(i) S1[0:5]
(ii) S1.head()
(ili) S1.head (5)
(iv) S1.head[0:5]

13. Rama was unable to understand how the recruiters were able to know about her digital activity when she has not shared anything with them. The recruiters might have checked _____ of Rama.
(i) Carbon Footprint
(ii) Water Footprint
(iii) Online print
(iv) Digital Footprint

14 Which MySQL string function is used to extract a substring from a given string based on a specified starting position and length ?
(i) SUBSTRING_INDEX ()
(ii) LENGTH ()
(iii) MID ()
(iv) TRIM ()

15. The software that is free for anyone, and its source code is available for access, modification, correction, and improvement is called _____.
(i) Proprietary software
(ii) Commercial software
(iii) Free and Open source software
(iv) Copyrighted software

16. _____ help in data protection through copyrights, patents and trademarks.
(i) Data Privacy Right
(ii) Right to Innovation
(iii) Intellectual Property Rights (IPR)
(iv) Right to Data Protection

17. Assertion (A) : Cyber Bullying can have serious, emotional and psychological effects on victims.
Reason (R) : Online Bullying is not a crime while offline bullying is a crime.
(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.

18. Assertion (A) : A Series is a one dimensional array and a DataFrame is a two-dimensional array containing sequence of values of any data type. (int, float, list, string, etc.)
Reason (R) : Both Series and DataFrames have by default numeric indexes starting from zero.
(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.

SECTION – B

19. (a) Expand URL. Identify the protocol and domain in the following URL:
https://epathshala.nic.in/topics.php?len=en
OR
(b) Write any one advantage and one disadvantage of Star topology.

20. The Python code written below has syntactical errors. Rewrite the correct code and underline the correction(s) made.
import Pandas as pd
stud=['Name': 'Ramya','Class':11, 'House': 'Red']
s=p.Series (s)
print (s)

21. What will be the output of the following SQL queries :
(i) SELECT RIGHT (“CHANDRAYAN3” , 4) ;
(ii) SELECT ROUND (76345.456,2) ;

22. Find the output of the following Python code :
import pandas as pd 2
com=pd. Series ([45,12,15,200] ,index=['mouse', 'printer',‘webcam', 'keyboard'])
print (com[1:3])

23. What is the primary function of a gateway in a computer network ? Explain briefly.

24. Consider the following Python code :
import pandas as pd
S1=pd.Series(['Rubina', 'Jaya','Vaibhav'] ,index=[10,16,18])
S2=pd. Series ( _ , index=[10,16,18]) S3=pd.Series ([56,67,86], _ )
xiia={'Name': , 'Subject':S2, 'Marks' :S3} df=pd.DataFrame(_)
print (df)
Complete the above Python code to display the following output :
Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2024

25. Write any two differences between UPDATE and ALTER TABLE commands of MySQL.

SECTION – C

26. (a) Consider the given table and write the following queries in MySQL:
Table : Sports

SidSNameFeesDateofPlayCoachID
1Karate12002024-08-24S1
2Football18002024-09-13S2
3Cricket15002024-06-14S3
4Lawn Tennis25002024-09-25S4
5Badminton18002024-10-20S5
(i) To display Sid and name of those sports which are to be played in the month of September.
(ii) To display all Sports names in lower case.
(iii) To display last two characters of all sports names whose fees is less than 1500.

OR
(b) Predict the output of the following queries based on the table Sports given above:
(i) SELECT UCASE(TRIM(SName)) FROM Sports WHERE Sid=5;
(ii) SELECT LEFT (SName , 3) FROM Sports WHERE DateofPlay>“2024-09-13” ;
(iii) SELECT SUBSTR (CoachId,1) FROM Sports WHERE SName=“Cricket” or Fees>=2000;

27. Kabir, a data analyst, has stored the voter’s name and age in a dictionary. Now, Kabir wants to create a list of dictionaries to store data of multiple voters. He also wants to create a DataFrame from the same list of dictionaries having appropriate row labels as shown below:
Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2024
Help Kabir in writing a Python program to complete the task.

28. Answer the following questions based on the table Salesman given below :
Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2024
(i) How many tuples does the given table have ?
(ii) Suggest the primary key for the given table.
(iii) Write the MySQL query to display all the records in descending order of commission.

29. (a) Police officials arrested four members of an interstate gang for allegedly duping many people from different states on the pretext of providing them with holiday packages after creating fake websites of Tours and Travels. The cyber criminals sent fraudulent emails containing links to fraudulent websites created by them.
The victim in his complaint told police that he was offered a holiday package to Dubai for a total of 10 times in the next 10 years and was charged Rs. 1.45 lakh through his credit card.
Answer the following questions pertaining to the given news byte :
(i) Identify the type of cybercrime mentioned in above case.
(ii) Which Act deals with such crimes in India ?
(iii) Suggest any one precaution that can be taken to avoid falling prey to such criminals.
OR
(b) ABC Electronics, a popular electronics retail chain, has been a prominent player in the market for years. However, recent concerns over environmental degradation and e-waste have prompted the company to rethink its strategies and practices. As the newly appointed sustainability manager, you’ve been asked to answer the following questions :
(i) Considering the environmental concerns associated with e-waste, outline any one negative impact of the electronic products on the environment.
(ii) Gopal is a college student who recently bought his new smartphone from ABC electronics. He’s excited about the new features and improved performance of his new device. However, he’s now left with his old smartphone, which is still functional but considered outdated. Suggest him any one action that he can take for his old smartphone.
(iii) Provide any one recommendation on how ABC Electronics can responsibly manage its e-waste while minimizing harm to the environment.

30. Consider the given DataFrame ‘password’ :
Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2024
Write suitable Python statements for the following :
(i) To adda new row with following values :
CodeName - ‘abc123’
Category - alphanumeric
Frequency - 12.8
(ii) To delete the row with the row label 2.
(iii) To delete the column having column label as Frequency.

SECTION – D

31. Rupam created a MySQL table to store the details of Nobel prize winners.
Help her to write the following MySQL queries :
Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2024
(i) Display the names of Nobel Prize winner in ‘Literature’ for the year 1970.
(ii) Display the subject and category of winners whose country is not known.
(iii) Display the details of all Nobel Prize winners who were Scientists.
(iv) Count total number of winners whose subject is Literature.

32. Ms. Ritika conducted an online assessment and stored the details in a DataFrame result as given below :
Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2024
Answer the following questions :
(i) Predict the output of the following Python statement :
print(result.loc [:,’Attempts’] > 1)
(ii) Write the Python statement to display the last three records.
(iii) Write Python statement to display records of ‘a’ and ‘d’ row labels.
OR
(Option for Part (iii) only)
(iii) Write suitable Python statement to retrieve the data stored in the file, ‘registration.csv’ into a DataFrame,’regis’.

SECTION – E

33. Excellent Consultancy Pvt. Ltd. maintains two tables for all its employees.
Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2024
Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2024
Write suitable SQL queries to perform the following task :
(i) Change the Department of Shivam to IT in the table Employee.
(ii) Remove the record of Alisha from the table Employee.
(iii) Add a new column Experience of integer type in the table Employee.
(iv) Display the first name, last name and amount of reward for all employees from the tables Employee and Reward.
(v) Display first name and salary of all the employees whose amount is less than 2000 from the tables Employee and Reward.
OR
Write suitable SQL queries for the following task :
(i) Display the year of joining of all the employees from the table Employee.
(ii) Display each department name and its corresponding average salary.
(iii) Display the first name and date of reward of those employees who joined on Monday from the tables Employee and Reward.
(iv) Display sum of salary of those employees whose reward amount is greater than 3000 from the tables Employee and Reward.
(v) Remove the table Reward.

34. FULLMAN Tech, Bengaluru is a company that deals with software development. They have different divisions HR (H1), Sales (H2), Production (H3) and Marketing (H4). The layout of the Bengaluru branch is:
Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2024
The management wants to connect all the divisions as well as all the computers of each division (H1, H2, H3 and H4).
Distance between the divisions are as follows :
Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2024
Based on the above specifications, answer the following questions :
(i) Suggest the topology and draw the most efficient cable layout for connecting all the divisions of Bengaluru branch.
(ii) FULLMAN Tech is expanding its reach and therefore it establishes a new office in Delhi. Out of LAN, MAN, and WAN what kind of network will be created to connect Bengaluru office with Delhi Office ?
(iii) Suggest the division for the placement of server in Bengaluru branch. Explain the reason for your selection.
(iv) Suggest the placement of the following devices in Bengaluru branch :
(a) Repeater
(b) Switch/Hub
(v) The company’s manager Ms. Ritu is worried as to how she can extend and modify the functionality of the web browser. Help her by giving names of any two tools.

35. (a) The inventory management software of a grocery shop stores the price of all fruits as follows :
Fruits=[‘Apple’, ‘Guava’,’Papaya’, ‘Grapes’, ‘Mango’ ]
Price=[150,70,50,30,120]
Write suitable Python code to generate a Bar Chart on the given data. Also add the chart title and label for X and Y axis. Also add suitable statement to save this chart with the name fruits.png.
OR
(b) Write suitable Python code to draw the following line chart “CO2 Emission” having title and label for X and Y axis as shown below.
Class-12-Informatics-Practices-065-Previous-Year-Question-Paper-2024
Also give suitable Python statement to save this chart with the name, emission.png.

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