CBSE Class 12 Informatics Practices Question Paper 2024 with Solutions

Students can use CBSE Sample Papers for Class 12 Informatics Practices with Solutions and CBSE Class 12 Informatics Practices Question Paper 2024 to familiarize themselves with the exam format and marking scheme.

CBSE Class 12 Informatics Practices Question Paper 2024 with Solutions

Time : 3Hrs.
Max. Marks : 70

No. of Ques : 35
No. of Sections: 5

General Instructions

1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A has 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 2 questions carrying 4 marks each.
7. Section E has 3 questions carrying 5 marks each.
8. All programming questions are to be answered using Python Language only.

Section A

Question 1.
In ……. topology, the devices are arranged in the form of multiple branches in hierarchical manner.
(a) Star
(b) Tree
(c) Mesh
(d) Bus
Answer:
(b) Tree

Question 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 ……
(a) Trademark Infringement
(b) Identity Theft
(c) Copyright Infringement
(d) Patent
Answer:
(c) Copyright Infringement

Question 3.
What can an individual do to enhance the privacy of data stored digitally?
(a) Share sensitive information on social media platforms.
(b) Use your date of birth as your password.
(c) Regularly update software installed on your device.
(d) Download and install software from unknown sources.
Answer:
(c) Regularly update software installed on your device

Question 4.
What will be the output of the following query?

SELECT POWER(2, MOD (17, 3)) ;

(a) 8
(b) 1
(c) 0
(d) 4
Answer:
(d) 4

Question 5.
Which of the following is not an aggregate function in MySQL?
(a) AVG ()
(b) MAX ()
(c) LCASE ()
(d) MIN ()
Answer:
(c) LCASE()

Question 6.
…….. is the gaining of unauthorized access to data in a conputer system.
(a) Phishing
(b) Plagiarism
(c) Hacking
(d) Copyright violation
Answer:
(c) Hacking

Question 7.
Which of the following is not true with respect to CSV files?
(a) Values are separated by commas.
(b) to_csv ()can be used to save a dataframe to a CSV file.
(c) CSV file is created using a word processor.
(d) CSV file is a type of text file.
Answer:
(c) CSV file is created using a word processor

Question 8.
Which MySQL command helps to add a primary key constraint to any table that has already been created? (1)
(a) UPDATE
(b) INSERT INTO
(c) ALTER TABLE
(d) ORDER BY
Answer:
(c) ALTER TABLE

Question 9.
What will be the output of the following query? (1)

SELECT SUBSTR("G20 2023 INDIA", 5, 4) :

(a) G20 2
(b) 2023
(c) INDI
(d) 023
Answer:
(b) 2023

Question 10.
What will be the output of the following Python code? [1]

import pandas as pd
dd = {'One': 1, 'Two' 2, 'Three' : 3, 'Seven' : 7)}
rr = pd. Series (dd)
rr ['Four'] = 4
print (rr)

(a) One 1
Two 2
Three 3
Seven 7
dtype: int64

(b) One 1
Two 2
Three 3
Four 4
Seven 7
dtype: int64
(c) Four 4
One 1
Two 2
Three 3
Seven 7
dtype: int64
(d) One 1
Two 2
Three 3
Seven 7
Four 4
dtype: int64
Answer:
(d)

Question 11.
Which of the following clause cannot work with SELECT statement in MySQL?
(a) FROM
(b) INSERT INTO
(c) WHERE
(d) GROUP BY
Answer:
(b) INSERT INTO

Question 12.
Which of the following command will not show first five rows from the Pandas series named SI? [1]
(a) S1 [0 : 5]
(b) S1. head ( )
(c) S1. head (5)
(d) S1. head [0 : 5]
Answer:
(d) S1.head[0:5]

Question 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]
(a) Carbon Footprint
(b) Water Footprint
(c) Online print
(d) Digital Footprint
Answer:
(d) Digital Footprint

Question 14.
Which MySQL string function is used to extract a substring from a given string based on a specified starting position and length ? [1]
(a) SUBSTRING_INDEX ( )
(b) LENGTH ( )
(c) MID ( )
(d) TRIM ()
Answer:
(c) MID()

Question 15.
The software that is free for anyone, and its source code is available for access, modification, correction, and improvement is called …….
(a) Proprietary software
(b) Commercial software
(c) Free and Open source software
(d) Copyrighted software
Answer:
(c) Free and open source software.

Question 16.
……. help in data protection through copyrights, patents and trademarks.
(a) Data Privacy Right
(b) Right to Innovation
(c) Intellectual Property Rights (IPR)
(d) Right to Data Protection
Answer:
(c) Intellectual Property Rights (IPR)

Question 17.
Assertion (A) Cyber Bullying can have serious, emotional and psychological effects on victims. HI
Reason (R) Online Bullying is not a crime while offline bullying ig a crime.
(a) Both A and R are true and R is the correct explanation for A.
(b) Both A and R are true but R is not the correct explanation for A.
(c) A is true and R is false.
(d) A is false but R is true.
Answer:
(c) A is true but R is false.

Question 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.
(a) Both A and R are true and R is the correct explanation for A.
(b) Both A and R are true but R is not the correct explanation for A.
(c) A is true and R is false.
(d) A is false but R is true.
Answer:
(b) Both A and R are true’but R is not the correct explanation for A.

Section B

Question 19.
(a) Expand URL. Identify the protocol and domain in the following URL: https: // epatfishala. nic. in/ topics, php? len = en
Or
(b) Write any one advantage and one disadvantage of Star topology.
Answer:
(a) URL Uniform Resource Locator
Protocol https – Hypertext transfer protocol secured
Domain epathshala.nic.in
Or
(b) Star Topology
Advantage : Error detection is easy
Disadvantage: Costly due to independent cables.

Question 20.
The Python code written below has syntactical errors. Rewrite the correct code and underline the correction(s) made. 12]

import Pandas as pd
stud = ['Name': 'Ramya', 'Class': 11. 'House': 'Red']
s = p.Series(s)
print(s)

Answer:
Correct code:

import pandas as pd
stud={'Name’:'Ramya'.'Class':11,'House':'Red'}
s=pd.Series(stud)
print (s)

Question 21.
What will be the output of the following SQL queries? 12]
(i) SELECT RIGHT (“CHANDRAYAN3”, 4) ;
(ii) SELECT ROUND (76345.456, 2) ;
Answer:
(i) YAN3
(ii) 76345.46

Question 22.
Find the output of the following Python code: 12]

import pandas as pd
com = pd. Series ([45, 12, 15, 200], index =['mouse', 'printer', 'webcam', 'keyboard'])
print(com [1 : 3])

Answer:
Output
printer 12
webcam 15

Question 23.
What is the primary function of a gateway in a computer network? Explain briefly.
Answer:
A Gateway is a network device that connects two dissimilar networks.
For example : A private office network connected to the Internet.

Question 24.
Consider the following Python code: [2]

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

Answer:
Complete code:

import pandas as pd
S1=pd.Series(['Rubina','Jaya','Vaibhav'], index =[10, 16, 18])
S2=pd.Series(['IP','HSc','IP'], index = [10, 16, 18])
S3= pd.Series([56, 67, 86], index=[10, 16, 18])
xiia={'Name':S1.'Subject':S2.'Marks':S3}
df=pd.DataFrame(xiia)
print(df)

Question 25.
Write any two differences between UPDATE and ALTER TABLE commands of MySQL.
Answer:
Difference between UPDATE and ALTER TABLE :

UPDATE	ALTER TABLE
It is a DML command	It is a DDL command.
Makes changes to data of a table.	Makes changes to structure of the table.

Section C

Question 26.
(a) Consider the given table and write the following queries in MySQL: [3]

(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:
Answer:
(a)

(i)

Select Sid.SName from Sports where month(DateofPlay)=09:

(ii)

Select lcase(Sname) from Sports:

(iii)

Select right(Sname, 2) from Sports where fees < 1500:

Or
(b) (i) BADMINTON

(ii)

LEFT(Sname,3)
Law
Bad

(iii)

Substr(CoachId/1)
S3
S4

Question 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: [3]

Help Kabir in writing a Python program to complete the task.
Answer:

import pandas as p
dvoter={“Voter_Name'': ["Arjun", "Bala", “Govind”, “ Dhruv'', “ Navya" ]," Voter_Age": [35, 23, 25, 19, 18]}
vdf=p.DataFrame(dvoter, index=[''Ar1001", ''Ba3002', "Go4002",“Dh4007", "Na6005"])

Question 28.
Answer the following questions based on the table Salesman given below: [3]

(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.
Answer:
(i) Number of tuples :6
(ii) Primary key – Salesman_Id
(iii) Select * from Salesman order by Commission Desc;

Question 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. [3]
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 ₹ 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.
Answer:
(a) (i) Phishing
(ii) IT Act 2000
(iii)

• Check the authenticity of the websites by their address
• Check for the https:// and padlock.
• Do not respond to unknown mail ids.
• Do not ever click on links.

Or

(b) (i) When electronics are improperly disposed and end up in landfills, toxic chemicals are released, impacting the earth’s air, soil, water and ultimately, human health.
(ii) He can remove his old data to a proper media and sell it to a proper vendor who can either repair it or extract the useful components from the old smartphone and make it usable.
(iii) They can contact a proper e-Waste recycler , who can collect the e-wastes from ABC Electronics and reuse , recycle the electronic wastes of the company.

Question 30.
Consider the given DataFrame ‘password’: [3]

Write suitable Python statements for the following:
(i) To add a new row with following values:
CodeName – ‘abcl23’
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.
Answer:
(i) password.loc[7]=[‘abc123’, ‘alphanumeric’, 12.8]
(ii) password =password.drop(2)
(iii) password.pop(‘Frequency’)

Section D

Question 31.
Rupam created a MySQL table to store the details of Nobel prize winners. Help her to write the following MySQL queries: [4]
TABLE : NOBEL

(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.
Answer:
(i) Select WINNER from NOBEL where SUBJECT=”Literature” and YEAR=1970:
(ii) Select SUBJECT. CATEGORY from NOBEL where COUNTRY IS NULL:
(iii) Select * from NOBEL where CATEGORY=’’Scientist”:
(iv) Select count(*) from NOBEL where SUBJECT=”Literature’;

Question 32.
Ms. Ritika conducted an online assessment and stored the details in a DataFrame result as given
below: [4]

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’.
Answer:
(i)

(ii)

result.tail(3)

(iii)

result.loc[['a':'d'],[:]]

Or

(iii)

regis=p.read_csv("registration.csv")

Section E

Question 33.
Excellent Consultancy Pvt. Ltd. maintains two tables for all its employees.

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.
Answer:
(i)

Update Employee set Department = “IT” where First_name="Shivam”;

(ii)

Delete from Employee where First_Name ="Alisha";

(iii)

Alter table Employee ADD Experience integer;

(iv)

Select A.First_Name. A. Last_Name. B.Amount from Employee A , Reward B where A.Enployee_ID= B. Employee_ID:

(v)

Select A.First_Name . A. SALARY from Employee A, Reward B where A.Employee_ID= B.
Emloyee_ID and B.AMOUNT<2000:

Or

Write suitable SQL queries for the following task:

(i) Display the year of joining of all the employees from the table Employee.
Answer:

Select.year(Joining_Date) from Employee

(ii) Display each department name and its corresponding average salary.
Answer:

Select Department. avg(Salary) from Employee GROUP BY DEPARTMENT:

(iii) Display the first name and date of reward of those employees who joined on Monday from the tables Employee and Reward.
Answer:

Select A.First Name, B.Date_Reward from Employee A . Reward B ‘where A.Employee_ID= B.Employee_ID and dayname(A.Joining_Date)=Monday:

(iv) Display sum of salary of those employees whose reward amount is greater than 3000 from the tables Employee and Reward.
Answer:

Select sum(A.SALARY) from Employee A.Reward B where A.Employee_ID= B.Employee_ID and B.Amount>3000;

(v) Remove the table Reward.
Answer:

Drop table Reward:

Question 34.
FULLMAN Tech, Bengaluru is a company that deals with software development. They have different divisions HR (HI), Sales (H2), Production (H3) and Marketing (H4). The layout of the Bengaluru branch is : [5]

The management wants to connect all the divisions as well as all the computers of each division (HI, H2, H3 and H4).
Distance between the divisions are as follows:

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.
Answer:
(i) Star Topology
Layout

(ii) WAN
(iii) H2, as it has the largest number of computers.
(iv) (a) Repeater
H2 to H3
H2 to H4
(b) Switch/Hub in all the buildings
(v) Browser apps, add-ons, plug-ins, and extensions

Question 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 “C02 Emission” having title and label for X and Y axis as shown below.

Also give suitable Python statement to save this chart with the name, emission.png.
Answer:
(a)

import matplotlib.pyplot as p
Fruits = ['Apple', 'Guava', 'Papaya', 'Grapes', 'Mango']
Price = [150, 70, 50, 30, 120]
p.bar(Fruits.Price)
p.xlabel("Fruits”)
p.ylabel(“Price”)
p.title("Fruit Price Analysis”)
p.show( )
p.savefig("fruits.png")

Or

(b)

import matplotlib.pyplot as p
Months=['April', 'May', 'June', 'July', 'August']
Perc=[40, 50, 30, 60, 20]
p.plot(Months.Perc)
p.xlabel(“Month”)
p.ylabel(“Percentage”)
p.title(“Monthwise C02 emission")
p.show()
p.savefig("emission.png”)